求助:一个关于查询的问题,请教!
dim sqlstr
sqlstr="select * from products where"
if request.form("pinz")<>"" then
sqlstr=sqlstr&" (wbpinzdb = '"&request.form("pinz")&"') and"
if request.form("keywords")<>"" then
sqlstr=sqlstr&" (wbproductnamedb like '%"&request.form("keywords")&"%' and)"
if right(sqlstr,5)="where" then sqlstr=left(sqlstr,clng(len(sqlstr))-5)
if right(sqlstr,3)="and" then sqlstr=left(sqlstr,clng(len(sqlstr))-3)
sqlstr=sqlstr&" order by Id desc"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.open sqlstr,conn,1,1
请指教?狂郁闷!