<%
strsearch=request.QueryString("action")
ProductsName=trim(request("ProductsName"))
if ProductsName="" then
ProductsName="输入产品名称"
end if
if strsearch="search" then
if ProductsName="输入产品名称" then
Sql="Select * from benming_ch_prod where show=1"
else
Sql="Select * from benming_ch_prod where show=1 and prodName like '%"&ProductsName&"%' "
sprodname=ProductsName
end if
else
Sql="Select * from benming_ch_prod where show=1"
end if
%>