prod_listcategory.asp

网上购物系统

<!--#include file=Conn.asp -->
<!--#include file=include/MyRequest.asp -->
<!--#include file="Sub.asp"-->
<!--#include file=include/Pages.asp-->
<%
cid=my_request("cid",1)

'	调出商品类别名称
sql="select prod_class_name from prod_Class where cid="&cid
set rs=conn.execute (sql)
prod_class_name=rs(0)
rs.close
set rs=nothing

'	参数设置表中相关参数调出
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select top 1 root_option_NumsPerRow,root_option_WidthSPic,root_option_HeighSPic,root_option_RowsPerPage from root_option"
rs.open sql,conn,1,1
root_option_NumsPerRow   =rs(0)
root_option_WidthSPic    =rs(1)
root_option_HeighSPic    =rs(2)
root_option_RowsPerPage  =rs(3)
rs.close
set rs=nothing

if root_option_WidthSPic="" then root_option_WidthSPic=80
if root_option_HeighSPic="" then root_option_HeighSPic=80

NumsPerPage=root_option_NumsPerRow*root_option_RowsPerPage
if NumsPerPage="" then NumsPerPage=20
if NumsPerPage="0" then NumsPerPage=20
if root_option_NumsPerRow="" then root_option_NumsPerRow=5

Call Header(prod_class_name,prod_class_name)
call prod_ListCategory(cid,root_option_NumsPerRow,NumsPerPage)
Footer
%>