sql update 语句的语法错误 请大家帮帮忙吧
来源:百度知道 编辑:UC知道 时间:2024/06/04 00:37:03
xxd=request.form("cc")
xxz=request.form("dd")
ldd=request.form("ee")
ldz=request.form("ff")
swd=request.form("gg")
swz=request.form("hh")
sql1="update yltj set xxd=" & xxd & ",xxz = " & xxz & ",ldd=" & ldd & ",ldz=" & ldz & ",swd=" & swd & ",swz=" & swz & " where rqsj=#" & rq & "# and hbh= '" & hbh & "' "
myconn.execute (sql1)
set myconn=nothing
修改表中的信息
但是总说 UPDATE语句语法有问题
我的格式应该都没有问题呀
你的方法不行呀
5555555555555怎么办?
xxz=request.form("dd")
ldd=request.form("ee")
ldz=request.form("ff")
swd=request.form("gg")
swz=request.form("hh")
sql1="update yltj set xxd=" & xxd & ",xxz = " & xxz & ",ldd=" & ldd & ",ldz=" & ldz & ",swd=" & swd & ",swz=" & swz & " where rqsj=#" & rq & "# and hbh= '" & hbh & "' "
myconn.execute (sql1)
set myconn=nothing
修改表中的信息
但是总说 UPDATE语句语法有问题
我的格式应该都没有问题呀
你的方法不行呀
5555555555555怎么办?
sql1="update yltj set xxd=" & xxd & ",xxz = " & xxz & ",ldd=" & ldd & ",ldz=" & ldz & ",swd=" & swd & ",swz=" & swz & " where rqsj=#" & rq & "# and hbh= '" & hbh & "' "
如果确定你没加引号的参数没错
改成
sql1="update yltj set xxd=" & xxd & ",xxz = " & xxz & ",ldd=" & ldd & ",ldz=" & ldz & ",swd=" & swd & ",swz=" & swz & " where rqsj='" & rq & "' and hbh= '" & hbh & "' "
或者
sql1="update yltj set xxd=" & xxd & ",xxz = " & xxz & ",ldd=" & ldd & ",ldz=" & ldz & ",swd=" & swd & ",swz=" & swz & " where datediff('d', rqsj, '" & rq & "') = 0 and hbh= '" & hbh & "' "