主题:  产品展示按特定要求排序怎么做?

jesron

职务:普通成员
等级:2
金币:1.0
发贴:393
注册:2001/1/27 0:06:31
#12002/10/3 16:39:01
看看这句有没有错:
<%
dim sorts
sorts ="desc"
if request("sorts")<>"" then
sorts=request("sorts")
end if
%>
<%
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_conn_STRING
rs.Source = "select * from products order by id "'&sorts&'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
%>

编辑历史:[这消息被jesron编辑过(编辑时间2002-10-03 16:40:20)]