ASP基本語法

VBSctipt
好像沒有區分大小寫
語法跟流程控制還蠻簡易的
Request("column name")  GET and POST
Request.form("column name") POST only
Request.QueryString("")
Request.ServerVariables()

Response.Write("")
Response.Redirect("")

do until rs.EOF
 for each x in rs.Fields
  Response.Write(x.name)
  Response.Write(x.name)

  Response.Write(x.name)
 next
 Response.Write("")
 rs.MoveNext
loop


if xxx then
xxxxxxxxx
xxxxxxxxx
else
xxxxxxxx
xxxxxxxx
end if

ASP筆記(連接MYSQL)

先安裝MYSQL ODBC

set conn = server.CreateObject("ADODB.Connection")
conn.open
"DRIVER={};
SERVER = 192.168.X.X;
DATABASE=test;
UID=;
PASSWORD=;
OPTION=3"

str = "SELECT * FROM ..."
set rs = ServerCreateObject("ADODB.recordset")
rs.open str,conn,1,A   A=1(讀) or 3(寫)

rs.Fields.Count
rs(i).Name
rs(i)
rs('column name')
rs.RecordCount
rs.BOF
rs.EOF
rs.MoveFirst
rs.MoveNext
rs.GetRows
rs.Properties.Count
rs.Properties(item).Name
rs.Properties
rs.colse()