您所在位置：主题：求救，操作符丢失
yexuexue
[专家分：0] 发布于 2007-03-11 17:19:00
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'bbs.name=[user].name and boardid=' 中。
<%
if session("name")="" then
response.Write "您还没登陆呢"
response.End
end if
boardid=request.QueryString("id")
response.Write "<a href=post.asp?id="&boardid&">[发表新贴]</a>"
page=request.QueryString("page")
if page=""then
page=1
end if
opendb
sql="select * from bbs,[user] where bbs.name=[user].name and boardid="&boardid&" order by istop desc,time desc"
rs.pagesize=5
rs.cursortype=3
rs.open sql,conn
if rs.eof then
response.Write "没有主题贴"
else
rs.absolutepage=cint(page)
%>
语法错误 (操作符丢失) 在查询表达式 'bbs.name=[user].name and boardid=' 中。
<%
if session("name")="" then
response.Write "您还没登陆呢"
response.End
end if
boardid=request.QueryString("id")
response.Write "<a href=post.asp?id="&boardid&">[发表新贴]</a>"
page=request.QueryString("page")
if page=""then
page=1
end if
opendb
sql="select * from bbs,[user] where bbs.name=[user].name and boardid="&boardid&" order by istop desc,time desc"
rs.pagesize=5
rs.cursortype=3
rs.open sql,conn
if rs.eof then
response.Write "没有主题贴"
else
rs.absolutepage=cint(page)
%>
