高考问答龙之气息技能:高手来看看这段SQL语句错在哪里?
来源：百度文库 编辑：高考问答 时间：2024/05/06 11:00:42
sql="insert into news(title,cateid,topicid,link,addtime,image,"
sql=sql+"special,content,hits) values('"
sql=sql+htmlencode(request("txttitle"))+"',"
sql=sql+request("selcate")+","
sql=sql+request("seltopic")+",'"
sql=sql+htmlencode(request("txtlink"))+"',#"
sql=sql+request("txtaddtime")+"#,'"
sql=sql+htmlencode(request("txtimage"))+"',"
'检查是否特别新闻
if request("chkspecial")="checked" then
sql=sql+"true,'"
else
sql=sql+"flase,'"
end if
sql=sql+htmlencode(request("txtcontent"))+"',0)"
conn.execute sql
注释:cateid,topicid,hits这三字段是数值型,addtime-日期时间,special-是否类型,content--备注型,其它是文本型.运行时提示INSETR TO 语句语法出错 把+ 改成 & 还是出错
1楼的，你说的没用啊，还是那个错误
sql=sql+"special,content,hits) values('"
sql=sql+htmlencode(request("txttitle"))+"',"
sql=sql+request("selcate")+","
sql=sql+request("seltopic")+",'"
sql=sql+htmlencode(request("txtlink"))+"',#"
sql=sql+request("txtaddtime")+"#,'"
sql=sql+htmlencode(request("txtimage"))+"',"
'检查是否特别新闻
if request("chkspecial")="checked" then
sql=sql+"true,'"
else
sql=sql+"flase,'"
end if
sql=sql+htmlencode(request("txtcontent"))+"',0)"
conn.execute sql
注释:cateid,topicid,hits这三字段是数值型,addtime-日期时间,special-是否类型,content--备注型,其它是文本型.运行时提示INSETR TO 语句语法出错 把+ 改成 & 还是出错
1楼的，你说的没用啊，还是那个错误
类型要转换,而且你少写了引号,以下代码在dw8+Access中测试通过
txttitle=htmlencode(request("txttitle"))
selcate=request("selcate")
seltopic=request("seltopic")
txtlink=htmlencode(request("txtlink"))
txtaddtime=request("txtaddtime")
txtimage=htmlencode(request("txtimage"))
chkspecial=request("chkspecial")
txtcontent=htmlencode(request("txtcontent"))
sql="insert into news(title,cateid,topicid,link,addtime,image,"
sql=sql+"special,content,hits) values('"
sql=sql+txttitle+"',"
sql=sql+cstr(selcate)+","
sql=sql+cstr(seltopic)+",'"
sql=sql+txtlink+"',#"
sql=sql+cstr(txtaddtime)+"#,'"
sql=sql+txtimage+"',"
...
改这段试试
if request("chkspecial")="checked" then
sql=sql+"1,'"
else
sql=sql+"0,'"
end if