求大神解答!!!一个小问题
程序如下:
<%
Set rs1=Server.CreateObject("adodb.recordset")
sql="select * from category where id="&request("id")
rs1.open sql,conn,1,1 %>
<link href="css.css"rel="stylesheet"type="text/css" >
<title>新闻列表首页-<%=rs1("category")%></title>
<table width="778"border="1"align="center" cellpadding="0"
<table width="778" border="1" align="center" cellpadding="0" cellspacing="2" bordercolor="#999999">
<tr>
<td align="center"><a href="index.asp">首页</a></td>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from category"
rs.open sql,conn,1,1
while not rs.eof
%>
<td align="center"><a href=list.asp?id=<%=rs("id")%>><%=rs("category") %></a></td>
<% rs.movenext
wend
rs.close
%>
<td align="center"><a href="aboutus.asp">联系我们</a></td>
</tr>
</table>
<p class="title"><strong>新闻列表 -><%=rs1("category")%></strong></p>
<%
page=cint(request("page"))
if page=""then
page=1
end if
mypagesize =8
Set rs=server.CreateObject("adodb.recordset")
sql="select * from news where categoryid="&id &" order by id desc"
rs.open sql,conn,1,1
rs.pagesize=mypagesize
pages=cint(rs.pagecount)
if page<1 or page> pages then
page=1
end if
rs.absolutepage=page %>
<table width="778" border="1" align="center" cellspacing="2"bordercolor="#CCCCCC">
<tr>
<td>标题</td> <td>添加时间</td>
<td>点击次数</td>
</tr>
<% for i=1 to rs.pagesize %>
<tr>
<td width="439"height="24"><a href="news_show.asp?id=<%=rs("id")%>"target="_blank"><%=rs("title") %></a></td>
<td width="242"><%=rs("addtime")%></td>
<td width="75"><%=rs("hits")%></td>
</tr><%
rs.movenext
if rs.eof then
exit for
end if
next
rs.close %>
</table>
<div align="center"><br>
一共<%=pages %>页,每页<%=mypagesize %>条
<%
if pages>1 and page>1 then
Response.Write("<a href=?page=1>第一页</a> ")
end if
if page>1 and pages>1 then
Response.Write("<a href=?page="&page-1&">上一页</a> ")
end if
if page<pages and page>1 then
Response.Write("<a href=?page="&page+1&">下一页</a> ")
end if
if page<pages and pages>1 then
Response.Write("<a href=?page="&page&">尾页</a> ")
end if %>
</div>
问题为:
Microsoft Access Database Engine 错误 '80040e14'
语法错误 (操作符丢失) 在查询表达式 'categoryid=' 中。
求大神解答