排序的问题

[anwell]

tiaojian="group by product.id,product.chuli,product.company_id,product.product_name,product.all_price,product.price,product.pice1,product.pice2,product.submitdate,product.jibie,product.hit,product.is_open"


if paixu<>"" then
select case paixu
case 1:
pai=" ORDER BY product.hit DESC "
case 2:
pai=" order by price DESC "
case 3:
pai=" order by price "
end select
else
pai=" order by product_name"
end if

======================

if tiaojian<>"" then
tiaojian=tiaojian&pai
else
tiaojian=pai
end if



我排出来的不是按后面的order的顺序，请问怎么修改一下才能按 order by 的为准啊？

[anwell]

??

[anwell]

???

[anwell]

????

[flying02]

晕~ASP版人气这么少