[thelist] sql filtering problem

Matthias Ritzkowski Matt at grndwtr.com
Tue Aug 27 10:13:01 CDT 2002


try this sql string, do a response.write to see what it spits out.
test that string against the db, if it works there, it will work on the asp
page.
Good luck!

strSQL = "SELECT Brand_Logo, Brand_Logo_sml, ID, Product_Type, Brand, Model,
Reference_No, Colour, image, Retail_Price, Delivery_Charge
FROM kitchen_appliance
WHERE Brand = '"&request.querystring("brand")&"' and Product_Type
='"&request.querystring("product_type")&"'"

 Regards
Matthias Ritzkowski



More information about the thelist mailing list