错在哪里了呢???????????
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行