现在是:sql="select goodscode,goodsname,market_price,price,smallpic,rebate from goods where shieldflag=0 and typeid="+wyao.checkString(Request("typeid"),"") +" order by updatetime desc" 中typeid取不到值
set rscount=server.CreateObject ("ADODB.Recordset")
set rs=server.CreateObject ("ADODB.Recordset")
set wyao=server.CreateObject ("wyao.para")
set rs01=server.CreateObject ("ADODB.Recordset")
sql="select count(*) num from goods where shieldflag=0 and typeid="+wyao.checkString(Request("typeid"),"")+""
set rscount=cn.execute (sql)
Response.Write rscount
sql="select goodscode,goodsname,market_price,price,smallpic,rebate from goods where shieldflag=0 and typeid="+wyao.checkString(Request("typeid"),"") +" order by updatetime desc"
Response.Write sql
rs01.Open sql,cn,1,1
totalcount=rs01.RecordCount
sql="select id,typename from goodstype where fid<>0"
set rs=cn.execute (sql)