怎样解决INSERT INTO 语句的语法错误

来源：百度知道编辑：UC知道时间：2024/05/09 20:10:57

145 user_id=Request.Form("user_id")
146 user_name=Request.Form("user_name")
147 sex=Request.Form("sex")
148 user_old=request.Form("user_old")
149 user_status=Request.Form("user_status")
150 user_post=Request.Form("user_post")
151 dept=Request.Form("dept")
152 tel=request.Form("tel")
153 sql="select count(*) from readerinfo where userid="&user_id&""
154 set rs=conn.execute(sql)
155 if rs(0)=0 then
156 sql1="insert into readerinfo(userid,name,sex,age,identity,post,dept,tel)"
157 sql1=sql1&" values ("&user_id&",'"&user_name&"','"&sex&"',"&user_old&",'"&user_status&"','"&user_post&"','"&dept&"','"&tel&"')"
158 conn.execute(sql1

列名用[]括起来
尤其name这种保留关键字，是不能直接用的
insert into readerinfo(〔userid〕,〔name〕,〔sex〕,〔age〕,〔identity〕,〔post〕,〔dept〕,〔tel〕)
这样

"insert into readerinfo(userid,name,sex,age,identity,post,dept,tel)"
sql 语句错了
应该是
"insert into readerinfo(" & userid & "," & name & "," & sex & "," & age & "," & identity & "," & post & "," & dept & "," & tel & ")"
还有你其他的代码中每个“&”字符要和左右有个空格

怎样解决INSERT INTO 语句的语法错误如何解决 INSERT INTO 语句的语法错误 INSERT INTO 语句的语法错误，急救！！！解决再加50 INSERT INTO 语句的语法错误,帮忙解决一下. asp insert into 问题 ASP insert into Insert into 语句语法错误 asp insert into 语法 insert into 问题 insert into 出错