ASP 擷取網頁資料

ServerURL="http://c5aweb01/MFG/Personal/Personal_Info.asp?WorkID=" & Session("WorkID")

Set Mail1 = Server.CreateObject("CDO.Message") 

Mail1.CreateMHTMLBody ServerURL,31 

AA=Mail1.HTMLBody '結果回傳到AA裡 

Set Mail1 = Nothing

message_count = Split(AA,",")

message_count = Array(0,0)

'=====重要訊息=====

ServerURL="http://c5aweb01/MFG/common/重要訊息/Top5.asp?FAB=" & FAB

Set Mail1 = Server.CreateObject("CDO.Message") 

Mail1.CreateMHTMLBody ServerURL,31 

MFG_MESSAGE = Mail1.HTMLBody

Set Mail1 = Nothing

python df 轉換成SQL的寫法

原本的方式為逐筆寫入list，在join成SQL

table_name = "l5ab_eqp_port_status"

SQLS = []

for row in df.values:

    SQL = "('" + "','".join(row.astype("str")) + "')"

    SQLS.append(SQL)

SQL = "insert into " + table_name + " values " + ",".join(SQLS)

一行搞定

SQL = "insert into " + table_name + " values " + ",".join("('" + "','".join(row.astype("str")) + "')" for row in df.values)

筆記