<％@ LANGUAGE=\"VBscr ipt\" ％>

<!--#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