set rs=conn.execute("select * from tablename order by name1")
name1=""
while not rs.eof
if name1<>rs("name1") then
response.write "<br>类别:"&rs("name1")&"<br>"
name1=rs("name1")
end if
response.write rs("para1")&" "&rs("para2")&" "&rs("name1")&" "rs("name2")&"<br>"
rs.movenext
wend
rs.close
set rs=nothing