|
|
<%=title%>
<%
num=conn.execute("select count(post_id) from product where "&where_dir)(0)
pagenum=(num-1)\NumPerPage+1
page=CheckNum(Request.QueryString("page"))
if page-1<0 then page=1
if page-pagenum>0 then page=pagenum
num_now=NumPerPage
if page-pagenum=0 then num_now=num-NumPerPage*(pagenum-1)
set rs=conn.execute("select * from (select top "&num_now&" * from product where (post_order <= (select max(post_order) from (select top "&NumPerPage*Page&" post_order from product where "&where_dir&" order by post_order) as temp)) and "&where_dir&" order by post_order desc) order by post_order")
while not rs.eof
path_name=conn.execute("select path_name from product_dir where dir_id="&rs("dir_id"))(0)
call ShowList
rs.movenext
wend
set rs=nothing
%>
<%Sub ShowList%>
-
<%End Sub%>
|
|