日期:2014-05-17  浏览次数:20851 次

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 "