SQL 第5行错误，请教 正确答案，谢谢

来源：百度知道 编辑：UC知道 时间：2024/05/26 17:49:54
1 dim sql,bid,cid 'bid 大类名 cid小类名

2 bid=Request.QueryString("bid")
3 cid=Request.QueryString("cid")

4 sql="select * from knows "
5 sql=sql & "where bid="&bid and cid="&cid
6 sql=sql & "order by viewpoint Desc"

1）bid和cid是整型
sql="select * from knows where bid="&bid&" and cid="&cid&" order by viewpoint Desc"
2）bid和cid是是字符型
sql="select * from knows where bid=‘"&bid&"’ and cid=‘"&cid&"’ order by viewpoint Desc"

5 sql=sql & "where bid=" & bid & " and cid=" & cid

楼上的说的应该是对的，还有注意的是 & 的前后必须都有空格