sas中国:语法错误 (操作符丢失) 在查询表达式 'by '%384%'' 中

来源:百度文库 编辑:神马品牌网 时间:2024/04/27 20:42:00
请个位大侠帮忙看看,运行下面代码出现的错误提示
错误行 rs2.open rs2.source,conn,1,1

<%

id=trim(request.QueryString("id"))
Str=trim(request.QueryString("Str"))

set rs2 = server.createobject("adodb.recordset")
rs2.source = "select id,parentid,content from deeptree where by '%"&id&"%'"
rs2.open rs2.source,conn,1,1
if rs2.eof then response.write"<div align='center' font style='font-size:10pt;font-family: 宋体;color=green'><br><b>还没有添加栏目!</b><br></div><br><br>"

Pid=rs2("id")
%>
<tr onMouseOver = "this.style.backgroundColor = '<%=Request.cookies("MouseON")%>'" onMouseOut = "this.style.backgroundColor = ''"><td width="27%" align="right"><img src="imgs/6.gif" width="11" height="11"></td>
<td width="73%"><a href="ProductsAllZ.asp?id=<%=rs2("id")%>&Str=<%=rs2("content")%>"><%=rs2("content")%></a></td></tr>
<%
set rss = server.createobject("adodb.recordset")
rss.source = "select id,parentid,content from deeptree where parentid="&Pid&""
rss.open rss.source,conn,1,1
while not rss.eof
%>
<tr onMouseOver = "this.style.backgroundColor = '<%=Request.cookies("MouseON")%>'" onMouseOut = "this.style.backgroundColor = ''"><td width="27%" align="right"> </td><td width="73%"><img src="imgs/6.gif" width="11" height="11"><a href="ProductsAllX.asp?id=<%=rss("id")%>&Str=<%=rss("content")%>&Pid=<%=Pid%>&PStr=<%=rs2("content")%>"><%=rss("content")%></a></td></tr>
<%
rss.movenext
wend
rss.close
set rss=nothing
%>