传统方法
rs.open sql,conn, 1, 3
绑定变量方法
Dim objComm
Set objComm = Server.CreateObject(”ADODB.Command”)
objComm.ActiveConnection = conn
objComm.CommandType = 1
objComm.CommandText = sql
objComm.Parameters.Append objComm.CreateParameter(”@customerId”,21,1,16,customerId) ‘http://www.activeserverpages.ru/ADO/daprop06_4.htm
Set rs = objComm.Execute
说明:传统的sql是直接的写sql,使用绑定变量的sql把变量替换成?
rs.open sql,conn, 1, 3
绑定变量方法
Dim objComm
Set objComm = Server.CreateObject(”ADODB.Command”)
objComm.ActiveConnection = conn
objComm.CommandType = 1
objComm.CommandText = sql
objComm.Parameters.Append objComm.CreateParameter(”@customerId”,21,1,16,customerId) ‘http://www.activeserverpages.ru/ADO/daprop06_4.htm
Set rs = objComm.Execute
说明:传统的sql是直接的写sql,使用绑定变量的sql把变量替换成?