%
vkeyword=trim(SafeRequest("keyword",0))
if SafeRequest("sort",1)="" then
vsort=100
else
vsort=SafeRequest("sort",1)
end if
select case vsort
case 10
sql="select ec_tradeid,title,updatetime from ec_trade where sort<20"
case 11
sql="select ec_tradeid,title,updatetime from ec_trade where sort=11"
case 12
sql="select ec_tradeid,title,updatetime from ec_trade where sort=12"
case 13
sql="select ec_tradeid,title,updatetime from ec_trade where sort=13"
case 14
sql="select ec_tradeid,title,updatetime from ec_trade where sort=14"
case 15
sql="select ec_tradeid,title,updatetime from ec_trade where sort=15"
case 20
sql="select ec_tradeid,title,updatetime from ec_trade where sort>19 and sort<30"
case 30
sql="select ec_tradeid,title,updatetime from ec_trade where sort>29 and sort<40"
case 100
sql="select ec_tradeid,title,updatetime from ec_trade where sort>0"
end select
if trim(vkeyword)<>"" then
sql=sql + " and title LIKE '%" &vkeyword&"%'"
end if
sql=sql + " order by updatetime desc"
%>