Question

asp提交文本表单 到SQLserver数据库问题

cgtjok.asp源码如下：
<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=192.168.8.209;UID=sa;PWD=q1w2e3r4;DATABASE=baite"
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="insert into dbo.baite_purbill (stockdate,suppid,suppname,prodcode,prodname,prodnum,prodspec,prodquantity,prounit,unitprice,sum,stocktype) VALUES("&request.Form("textfield")&","&request.Form("select")&","&request.Form("select4")&","&request.Form("areaid")&","&request.Form("townid")&","&request.Form("textfield6")&","&request.Form("textfield7")&","&request.Form("textfield8")&","&request.Form("select8")&","&request.Form("textfield14")&","&request.Form("textfield11")&","&request.Form("select3")&")"
rs.open sql,conn
%>
<%
Conn.close
set conn=nothing
%>
以上是我提交到数据库的链接程序，但不知道哪有问题？老是无法提交。还报错,如下：
Microsoft OLE DB Provider for SQL Server ?? '80040e14'',' ????????/cgtjok.asp,? 12
请高手指点

Answer 1

记住一点 rs.open 的是 “查” SQL语句
conn.execute "增/删/改" SQL语句

所以 你不需要 set rs....
直接 conn.execute sql 即可

追问

我换成conn.execute sql这个了，也不行，报告这一行错误。