Question

语法错误 (操作符丢失) 在查询表达式 'where userid=1' 中

运行出现 下列提示
语法错误 (操作符丢失) 在查询表达式 'where userid=1' 中

大侠们帮看看哪错了
谢谢
<%
Server.ScriptTimeout=999
userid=session("userid")
set rs=Server.CreateObject("adodb.recordset")
sql="select * from tonglist where where userid=" & session("userid")
rs.open sql,conn,1,1

if rs.eof then
Response.write "<br/>暂无该类信息!"
Else
rs.PageSize=10
page=CLng(Request("page"))
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page
if page=1 then
bianhao=0
else
bianhao=page*5-5
bianhaocont=bianhao
End if
For i=1 to rs.PageSize
bianhaocont=bianhaocont+1

response.write "广告说明:" & rs("adname")& "<br/>"
rs.Movenext
if rs.EOF then Exit for
Next
response.write "--------<br/>"
If Page<rs.PageCount then
Response.Write "<a href='listad.asp?page=" & (page+1) & "'>下一页</a>"
End if

If page>1 then
Response.Write "<a href='listad.asp?page=" & (page-1) & "'>上一页</a>"
End if
if rs.RecordCount>rs.PageSize then
response.write "<br/>"
End if
response.write "第" & Page & "/" & rs.PageCount & "页" & "共" & rs.RecordCount & "条"
End if
response.write "<br/><a href='lxwe.asp'>联系我们</a>"
response.write "<br/><a href='/'>返回首页</a></p></card></wml>"

rs.close
Set rs= Nothing
conn.close
set conn=nothing
%>
寒
改成<%
Server.ScriptTimeout=999
userid=session("userid")
set rs=Server.CreateObject("adodb.recordset")
sql="select * from tonglist where userid=" & session("userid")
提示
标准表达式中数据类型不匹配
该如何解决?

Answer 1

sql="select * from tonglist where where userid=" & session("userid")
<br>
<br>这里多了一个where

------------------------------------------------
sql="select * from tonglist where where userid='"&session("userid") &"'"