你可以这样:sql="select * from biao1 Where ziduan1 like '%AAA%' orziduan1 like '%BBB%' order by classid但这样是夹杂着输出,既有AAA的也有BBB的。如果要单独另外输出可以:sql2="select * from biao1 Where ziduan1 like '%BBB%' order by classid后面再:set rs2=server.createobject("adodb.recordset")rs2.open sql2,conn,1,1然后一样的通过for输出。...
if Cid="" then sql="select * from biao1 Where ziduan1 like '%AAA%' order by classid sql2="select * from biao1 Where ziduan1 like '%BBB%' order by classid desc"End if'response...