<% on error resume next sort_id=request("sort_id") nsort_id=request("nsort_id") nnsort_id=request("nnsort_id") s4=request("s4") s5=request("s5") s6=request("s6") s4z1=request("s4z1") s4z2=request("s4z2") key=request("key") sql_text="select * from cp where " if sort_id="" then sql_text=sql_text n1="产品目录" else set rsn1=server.CreateObject("adodb.recordset") rsn1.open"select * from sort where sort_id="&sort_id,cn,1,3 n1=rsn1("sort_name") sql_name="sort_id ="&sort_id&" "+"and" sql_text=sql_text+sql_name end if if nsort_id="" then sql_text=sql_text else set rsn2=server.CreateObject("adodb.recordset") rsn2.open"select * from nsort where nsort_id="&nsort_id,cn,1,3 n2=rsn2("nsort_name") sql_name=" nsort_id="&nsort_id&" "+ "and" sql_text=sql_text+sql_name end if if nnsort_id="" then sql_text=sql_text else set rsn3=server.CreateObject("adodb.recordset") rsn3.open"select * from nnsort where nnsort_id="&nnsort_id,cn,1,3 n3=rsn3("nnsort_name") sql_name=" nnsort_id="&nnsort_id&" "+"and" sql_text=sql_text+sql_name end if if s5="" then sql_text=sql_text else n1="新品推荐" sql_name=" s5='"&s5&"' "+ "and" sql_text=sql_text+sql_name end if if key="" then sql_text=sql_text else sql_name=" s1 like '%"&key&"%' or es1 like '%"&key&"%' "+ "and" sql_text=sql_text+sql_name n1="搜索结果" end if sql_text1=sql_text+" leixing='产品'"+" order by px_id desc,id desc" sql_text2=sql_text+" leixing='配件'"+" order by px_id desc,id desc" set rscp1=server.CreateObject("adodb.recordset") rscp1.open sql_text1,cn,1,3 set rscp2=server.CreateObject("adodb.recordset") rscp2.open sql_text2,cn,1,3 %> <% call gsxmnrok(1) %>
<%if request("leixing")<>"产品" then%>
<%end if%>