UC知道insert语句哪错了
来源：百度知道 编辑：UC知道 时间：2024/05/21 07:13:41
if request("title")<>"" and request("username")<>"" then
dim title,body,layer,username,parentid,hits,ip
title=request.Form("title")
body=request.Form("body")
username=request.Form("username")
layer=1
parentid=1
child=0
hits=0
ip=request.ServerVariables("remote_addr")
dim sqla,sqlb,strsql
sqla="insert into bbs(title,layer,parentid,child,hits,ip,username,time,body)"
sqlb="values('" & title & "'," & layer & "," & parentid & "," & child & "," & hits & ",'" & ip & "','" & username & "',# " & date() & " #,'" & body & "')"
strsql=sqla & sqlb
db.execute(strsql)
db.close
response.Redirect"tzxs.asp"
end if
测试时说INSERT INTO 语句的语法错误。我是哪错了，谢谢。
dim title,body,layer,username,parentid,hits,ip
title=request.Form("title")
body=request.Form("body")
username=request.Form("username")
layer=1
parentid=1
child=0
hits=0
ip=request.ServerVariables("remote_addr")
dim sqla,sqlb,strsql
sqla="insert into bbs(title,layer,parentid,child,hits,ip,username,time,body)"
sqlb="values('" & title & "'," & layer & "," & parentid & "," & child & "," & hits & ",'" & ip & "','" & username & "',# " & date() & " #,'" & body & "')"
strsql=sqla & sqlb
db.execute(strsql)
db.close
response.Redirect"tzxs.asp"
end if
测试时说INSERT INTO 语句的语法错误。我是哪错了，谢谢。
insert into bbs(title,layer,parentid,child,hits,ip,username,time,body)
改成
insert into bbs(title,layer,parentid,child,hits,ip,username,[time],body)"
不知道你的数据库的字段类型是什么。但是只要是文本的要这么写
'"&值&"'
数字的这么写 "&值&"
你的Insert语句是不是layer这里错了？'"&layer&"'
把所有'" & title & "'后面的字段加对单引号(''),像'" & title & "'这种格式,如还不行把&换成+号!