谁能帮我修改一下网页代码?谢谢!

来源:百度知道 编辑:UC知道 时间:2024/05/21 22:43:22
我做了个聊天室,运行时有两处出错地方,原因是[日期的语法错误 在查询表达式 'puttime>#2007-5-12 上午 08:27:06#' 中。]
麻烦哪位大哥大姐帮忙修改一下,不胜感激!谢谢![出错地方以※标出]
----------------------------------------------------------------
右边:
response.write "</head>"&vbcrlf
response.write "<body onload='gotop()'>"&vbcrlf
response.write "<div id='announce'><script language='javascript'>"&vbcrlf&"if(top!=window)"&vbcrlf&"{"&vbcrlf&"bulletintxt=top.online.document.title;"&vbcrlf&"if(bulletintxt.substr(0,8)=='没有可以显示的页')"&vbcrlf&"top.online.window.location.href='online.asp';"&vbcrlf&"else"&vbcrlf&"document.write(top.online.document.title);"&vbcrlf&"}"&vbcrlf&"</script></div>"&vbcrlf
response.write "<hr width=""100%""><br>"&vbcrlf
※sql="select top "&maxrecordnu

右边改为:sql="select top "&maxrecordnum&" userid,sayto,saycontent,textcolor,userface,ispublic,puttime from chatinfo where datediff(s,puttime,getdate())>"&5*sessionout&" order by puttime desc"

左边改为:sql="select * from userinfo where datediff(s,logintime,getdate())<"&sessionout&" and isonline=true"