<％@ LANGUAGE="VBSCRIPT" ％> <!--#include file="conn.asp" --> <％ ProductClass_2=request("ProductClass_2") set rs=server.createobject("adodb.recordset") sqltext="select * from Product" if request("Product_Name")<>"" then sqltext=sqltext &" where Product_Name like ％"& request("Product_Name") &"％ " else sqltext=sqltext &" where Product_Name like ％"& "" &"％ " end if if request("Product_Class")<>"" then sqltext=sqltext &" and Class_1 like ％"& request("Product_Class") &"％ " end if
