[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