口袋妖怪黑雾:sql数据库更新问题

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 16:43:26
dim conn,rs,connstr,sqlstmt
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
connstr = Application("ConnStr")
conn.Open connstr
sqlstmt = "Update volaction Set actname='" & actname & "',"
sqlstmt = sqlstmt & "acttype='" & acttype & "',"
sqlstmt = sqlstmt & "actaim='" & actaim & "',"
sqlstmt = sqlstmt & "actdate='" & actdate & "',"
sqlstmt = sqlstmt & "actsite='" & actsite & "',"
sqlstmt = sqlstmt & "actman='" & actman & "',"
sqlstmt = sqlstmt & "actcont='" & actcont & "',"
sqlstmt = sqlstmt & "priman='" & priman & "',"
sqlstmt = sqlstmt & "actest='" & actest & "',"
sqlstmt = sqlstmt & "monuse='" & monuse & "',"
sqlstmt = sqlstmt & "recman='" & recman & "'"
sqlstmt = sqlstmt & " WHERE actno ='" & actno & "'"

Set RS = conn.execute(sqlstmt)
这是我写的用sql更新多个字段的数据库语句,但是怎么也不行,这个数据库没有问题的,字段也没有问题,我插入新字段都能成功的
现在已经解决了,这个语法没有错误,是字段错了,现在有出现一个新问题,Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'

[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
这个怎么改?他说是参数不足,但是我提交的数据已经检查很多次,都没有问题的,不少的.

建议response.write(sqlstmt),然后把它在sql查询分析其中执行,看看有没有错误

建议response.write(sqlstmt),然后把它在sql查询分析其中执行,看看有没有错误

作者最好能将错误信息发上来,以供判断