注册 登录
编程论坛 ASP技术论坛

ODBC 驱动程序不支持所需的属性。 求解!跪求

a0427 发布于 2012-12-03 13:30, 443 次点击
源代码<%
dim rs
 set rs = server.CreateObject("ADODB.Recordset")


 rs.Open "select * from Comment where Topic = "&request.QueryString("topic")&"or Id = "&request.QueryString("topic")&" order by topic asc,date desc",conn,1  这就是第25行


 conn.execute("Update Comment set browse = browse + 1 where id = "&request.QueryString("topic"))
 
 Dim pageNo,pageS
 if request.QueryString("pageNo") = "" then
 pageNo = 1
 else
 pageNo=cInt(request.QueryString("pageNo"))
 end if
 
 rs.pageSize = 5
 pageS = rs.pageSize
 rs.Absolutepage =  pageNo
 if pageNO=1 then
%>
<table width="98%" border="0" cellpadding="5" cellspacing="1" bgcolor="#666666">
  <tr>
    <td class="td1">标题:<% =myReplace(rs("Title"))%></td>
  </tr>
</table>
<%end if
do while not rs.eof and pageS>0
%>
<table width="98%" border="0" cellpadding="5" cellspacing="1" bgcolor="#666666">
<tr bgcolor="#FFFFFF">
<td width="120" valign="top">
<% dim rs2
 set rs2 =server.CreateObject("ADODB.Recprdset")
 rs2.open "select * from User where name ="&rs("Author")&",".conn
%>

Access  SQL输出 提示语法错误(操作符丢失)在 Topic = "&request.QueryString("topic")&"or Id = "&request.QueryString("topic")&"中

求高手帮忙!跪求!

6 回复
#2
cnfarer2012-12-04 06:46
这通常是Query未取到值.也可能缺少''
#3
a04272012-12-04 11:35
回复 2楼 cnfarer
如果Query未取到值,该如何解决
#4
ysf01812012-12-04 16:24
rs.Open "select * from Comment where Topic = "&request.QueryString("topic")&" or Id = "&request.QueryString("topic")&" order by topic asc,date desc",conn,1,1  这就是第25行

红色的地方,or 的前后要加空格。
#5
a04272012-12-05 12:44
回复 3楼 a0427
还是不行 提示还是一样
#6
cnfarer2012-12-06 07:15
"select * from Comment where Topic = '"&request.QueryString("topic")&"' or Id = "&request.QueryString("topic")&" order by topic asc,date desc"
#7
a04272012-12-06 13:00
还是不行
1