SQL Server 插入数据时的问题:错误 '80040e14'
awash 2000-06-13 03:26:00 Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.
/sc4.asp, 行162
set conn=server.createobject("adodb.connection")
conn.open "driver={SQL server}; server=wrench; uid=sa; pwd=; database=cn338"
sql= "insert into member(name,phone,email,register_address,sex,countryid,introducerid,password,login_name,pwd_question,pwd_answer,zipcode) values ('"&name&"','"&phone&"','"&email&"','"&address&"','"&sex&"','"&area&"','"&sponsor&"','"&passwd&"','"&login&"','"&question&"','"&answer&"','"&zipcode&"')" ‘此为161行
conn.Execute sql '此为162行