set con=server.CreateObject("adodb.connection")
db="cfsoft/mydb.mdb"
con.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from bbs order by djl desc"
rs.open sqlstr,con,1,3
set rs1=server.CreateObject("adodb.recordset")
sqls="update bbs set zd=1,time="& date() &" where bid=" & request("bid")
sqls1="update bbs set zd=0 where bid=" & request("bid")
'response.write "update bbs set zd=1,time="& date() &" where bid='" & request
("bid") & "'"
'response.End
if request("zd")=1 then
rs1.open sqls,con,1,3
else
rs1.open sqls1,con,1,3
end if
%>
为何提示
Microsoft JET Database Engine 错误 '80040e14'
UPDATE 语句的语法错误。
/zd.asp,行 14
那位大侠帮忙解决一下呀
谢谢2位朋友的帮忙,但time 是日期格式,没法转换,
下面2钟方法都试过了,不管用呀.
展开