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

错在哪里了呢???????????
1行   <%
2行   select   case   request( "sheng ")=0   and   request( "youdate ")= " "   and   request( "youdate2 ")= " "   and   request( "check ")= " "   and   request( "lanmu ") <> 0          
3行     sql= "select   *   from   [ "&request( "lanmu ")& "]   where   adminid   is   not   null   order   by   id   desc "    

4行   case     request( "sheng ")=0   and   request( "youdate ") <> " "   and   request( "youdate2 ") <> " "   and   request( "check ")= " "   and   request( "lanmu ") <> 0          
5行     sql= "select   *   from   [ "&request( "lanmu ")& "]   where   adminid   is   not   null   and   addtime> = ' "&request( "youdate ")& " '   and   addtime <= ' "&request( "youdate2 ")& " '   order   by   id   desc "    

6行 case     request( "sheng ") <> 0   and   request( "youdate ")= " "   and   request( "youdate2 ")= " "   and   request( "check ")= " "   and   request( "lanmu ") <> 0              
7行 sql= "select   *   from   [ "&request( "lanmu ")& "]   where   adminid   is   not   null   and   sheng= ' "&request( "sheng ")& " '   order   by   id   desc "    

8行 case     request( "sheng ")=0   and   request( "youdate ")= " "   and   request( "youdate2 ")= " "   and   request( "check ") <> " "   and   request( "lanmu ") <> 0              
9行 sql= "select   *   from   [ "&request( "lanmu ")& "]   where   adminid   is   not   null   and   recommend= ' "&request( "check ")& " '   order   by   id   desc "    

10行 case     request( "sheng ") <> 0   and   request( "youdate ")= " "   and   request( "youdate2 ")= " "   and   request( "check ") <> " "   and   request( "lanmu ") <> 0              
11行 sql= "select   *   from   [ "&request( "lanmu ")& "]   where   adminid   is   not   null   and   sheng= ' "&request( "sheng ")& " '   and   recommend= ' "&request( "check ")& " '   order   by   id   desc "    

12行 case   else  
13行     response.write   "查询不符合条件 "  
14行     End   Select
15行%>
单独执行每句都好用,放到select   case里他就报第4行错误。把第2、3行去掉,在第4行加上select他就报第6行