谁能帮我修改一下网页代码？谢谢！
我做了个聊天室，运行时有两处出错地方，原因是[日期的语法错误在查询表达式'puttime>#2007-5-12上午08:27:06#'中。]麻烦哪位大哥大姐帮忙修改一下，...
我做了个聊天室，运行时有两处出错地方，原因是[日期的语法错误 在查询表达式 '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 "&maxrecordnum&" userid,sayto,saycontent,textcolor,userface,ispublic,puttime from chatinfo where puttime>#"&dateadd("s",(0-5*sessionout),now())&"# order by puttime desc"
rs.open sql,conn,0,1
if not(rs.bof and rs.eof) then
chatinfodata=rs.getrows()
rs.close
set rs=nothing
-----------------------------------------------------------------
左边：
set rs2=server.createobject("adodb.recordset")
※sql="select * from userinfo where logintime<#"&dateadd("s",(0-sessionout),now())&"# and isonline=true"
rs.open sql,conn,0,3
systeminfo=rs.recordcount
do while not rs.eof 展开
麻烦哪位大哥大姐帮忙修改一下，不胜感激！谢谢！[出错地方以※标出]
----------------------------------------------------------------
右边：
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 "&maxrecordnum&" userid,sayto,saycontent,textcolor,userface,ispublic,puttime from chatinfo where puttime>#"&dateadd("s",(0-5*sessionout),now())&"# order by puttime desc"
rs.open sql,conn,0,1
if not(rs.bof and rs.eof) then
chatinfodata=rs.getrows()
rs.close
set rs=nothing
-----------------------------------------------------------------
左边：
set rs2=server.createobject("adodb.recordset")
※sql="select * from userinfo where logintime<#"&dateadd("s",(0-sessionout),now())&"# and isonline=true"
rs.open sql,conn,0,3
systeminfo=rs.recordcount
do while not rs.eof 展开
1个回答
展开全部
右边改为：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"
左边改为：sql="select * from userinfo where datediff(s,logintime,getdate())<"&sessionout&" and isonline=true"
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
