孟子老大已经说的很清楚了,你取两个记录集就行了
set rs1=conn.execute("select * from pro where type='供应'")
set rs2=conn.execute("select * from pro where type='求购'")
while not (rs1.eof and rs2.eof)
response.write rs1("id") & rs1("type") & rs1("name")
if not rs1.eof then rs1.movenext
response.write rs1("id") & rs1("type") & rs1("name")
if not rs2.eof then rs2.movenext
wend