UC知道ASP对排序问题，急，求教
来源：百度知道 编辑：UC知道 时间：2024/05/17 11:50:56
我想对产品进行排序，我现在写的是
<%
if request("id")><"" then
sql= "select * from product where id="&request("id")
rs.open sql,conn,1,1
else
sql= "select * from product where p_lb="&lb&" order by p_sort "
rs.open sql,conn,1,1
end if
if rs.recordcount>0 then
%><a href=# onclick=mClk_win("show-product.asp?id=<%=rs("id")%>","","750","550")><div align="center"><img border="0" src=<%=rs("picb")%> align="center" width="100" height="100" ></div></a><%
els
<%
if request("id")><"" then
sql= "select * from product where id="&request("id")
rs.open sql,conn,1,1
else
sql= "select * from product where p_lb="&lb&" order by p_sort "
rs.open sql,conn,1,1
end if
if rs.recordcount>0 then
%><a href=# onclick=mClk_win("show-product.asp?id=<%=rs("id")%>","","750","550")><div align="center"><img border="0" src=<%=rs("picb")%> align="center" width="100" height="100" ></div></a><%
els
好的发到http://post.baidu.com/f?kw=lizhonggeng
我的贴吧吧，这里有修改次数限制，怕给你说不清楚
p_lb是排序字段的话应该是order by p_lb啊你怎么事order by p_sort ??你能解释下吗，我给你改了改其它地方
<%
rs.close'如果你前面曾经打开过rs就要这句，否则删除即可
if request("id")<>"" then
sql= "select * from product where id="&request("id")
else
sql= "select * from product where p_lb="&lb&" order by p_sort "
end if
rs.open sql,conn,1,1
if rs.recordcount>0 then
%><a href=# onclick=mClk_win("show-product.asp?id=<%=rs("id")%>","","750","550")><div align="center"><img border="0" src=<%=rs("picb")%> align="center" width="100" height="100" ></div></a><%
els