极限脱出999真结局攻略:Microsoft JET Database Engine (0x80040E14)的错误,高手帮忙啊?

来源:百度文库 编辑:高考问答 时间:2024/04/26 10:37:32
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 + "1,'"
else
sql = sql + "0,'"
end if

sql = sql + htmlencode(request("txtcontent")) + "',0)"
response.Write(sql)
conn.execute sql

================================================
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
1楼的,你说的没用,还是错误

sql = sql + htmlencode(request("txtlink")) + "','"
sql = sql + request("txtaddtime") + "','"

时间日期可以直接写入