Question

asp代码出现错误无法更新数据库 update语法错误

Sub ysh()
file=year(now)&month(now)&day(now)&hour(now)&minute(now)&second(now)
rcID=request.Form("IDs")
if rcID="" then
response.write"<script>alert('未选择！');history.go(-1)</script>"
response.end
end if
for i=1 to request.form("IDs").count 'IDs为多选框
pingpaiid=replace(request.form("IDs")(i),"'","")
pingpaiorder=replace(request.form("sel")(i),"'","") ‘sel为下拉菜单1
tuijian=replace(request.form("sel1")(i),"'","") ’sel为下拉菜单2

conn.execute("update DB_yy set shtime='"&file&"',ysmemo1='"&pingpaiorder&"',check='"&tuijian&"' where id="&pingpaiid)
next
conn.close
set conn=nothing
end sub

Answer 1

1 where id = " 这里为什么只有一个引号？ 这个ID是字符串类型吗？应该后边也有引号啊

2 双引号换成单引号试试

3 上边的set什么什么的，为什么双引号后边还有个单引号？ 去掉双引号试试