<%
set odb=server.createobject("adodb.connection")
odb.open application("trans_ora")
set rs=server.createobject("adodb.recordset")
sql="select * from (select projname,url,sort_count from proj_sort where sort_name='普通住宅热门楼盘' and city='大连' order by sort_count desc) where rownum<=20"
rs.open sql,odb,3,1
if not rs.eof then
%>