HTTP 错误 500.100 - 内部服务器错误
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
在关键字 'and ' 附近有语法错误。
/taobao1/membersarea/pingjiabuysell.asp, 第 103 行
<%
Set rs=Server.CreateObject( "ADODB.Recordset ")
If wwwnet( "id ")= "1 " then
sql= "select * from list where huiyuan= ' "&Request.Cookies(Rikeeshop)( "huiyuan ")& " ' and [over]= 1 and sellxinyong=2 order by id desc "
Else
sql= "select * from list where userid= "&myuserid& " and [over] = 1 and buyxinyong=2 order by id desc "
End if
rs.open sql,conn,1,1
page1( "10 ")
%>
大家看看哪里错了
------解决方案--------------------在关键字 'and ' 附近有语法错误。
一个一个条件试。
如:将sql= "select * from list where userid= "&myuserid& " and [over] = 1 and buyxinyong=2 order by id desc "
改成(去掉:[over] = 1 and):sql= "select * from list where userid= "&myuserid& " and buyxinyong=2 order by id desc "