语法错误 (操作符丢失) ?这是怎么回事?

来源:百度知道 编辑:UC知道 时间:2024/05/12 04:58:35
程序如下:

singerName = trim(request("singerName"))
firstLetter = trim(request("firstLetter"))
singerInfo = trim(request("singerInfo"))
discription = trim(request("discription"))

if(singerName <> "" and firstLetter <> "" ) then
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
sql1 = "select * from singer_tb where singerName ='"&singerName&"'"
rs1.open sql1,conn,1,3
if rs1.recordcount < 1 then
sql = "select * from singer_tb"
rs.open sql,conn,1,3
rs.addnew

rs("singerName") = singerName
rs("infoId") = singerInfo
rs("discription") = discription
rs("firstLetter") = firstLetter
rs.update
rs.close
Set rs=nothing
set

把i'm换成i am试试,这是单引号(')操作符不成对的原因;要嘛转义字符了哦.

'singerName ='i'm'' 中的 i'm这个有问题。但我不知道怎么表述ASP的替代符,,JAVA是用 转义字符 。。