求高手帮我解决一下asp和数据库问题

来源:百度知道 编辑:UC知道 时间:2024/05/31 23:09:34
Dim nn
nn = Request("Id")
splstr="update Table1 set Bestplayers = " & zjqy & "Runnerup = " & dsyj & "Champion = " & ycgj & "Echampion = " & aa & "ERunnerup = " & bb & "EBestplayers = " & cc & "Useropinions = " & dd & "where Id =" &nn
Response.Write splstr
oconn.execute(splstr)
我要让这段ASP修改数据库表,可是执行时候总是显示‘=’附近有语法错误

splstr="update Table1 set Bestplayers = " & zjqy & ",Runnerup = " & dsyj & ",Champion = " & ycgj & ",Echampion = " & aa & ",ERunnerup = " & bb & ",EBestplayers = " & cc & ",Useropinions = " & dd & " where Id =" &nn

各字段要用逗号分隔,如果字段是字符或时间类型,值需要加上单引号。