Microsoft JET Database Engine (0x80040E14) 语法错误 (操作符丢失) 在查询表达式 'newsID=' 中。

来源:百度知道 编辑:UC知道 时间:2024/06/30 15:01:29
<td height="1" bgcolor="cccccc">
<img src="../../../shop/images/dot_03.gif" width="9" height="1" border="0"></td>
</tr>
<tr>
<td height="25" bgcolor="efefef"><strong>  <img src="../../../shop/images/dot_03.gif" width="9" height="9" border="0">
商品评论:</strong>
<b>
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from xinwen where newsID="&request("ID")&" order by biaoti desc",conn,1,1
%>
</b>
<%=trim(rs("biaoti"))%></td>
</tr>
<tr>
<td heig

这语句rs.open "select * from xinwen where newsID="&request("ID")&" order by biaoti desc",conn,1,1
有问题吧,
id=request("ID")
rs.open "select * from xinwen where [newsID]="&id
改成这样试试

出错原因:request("ID")为空
请检察你传递的参数值是否正确