[thelist] sql filtering problem

dn at dittodesign.co.uk dn at dittodesign.co.uk
Tue Aug 27 10:44:01 CDT 2002


> WHERE Brand = '"&request.querystring("brand")&"' and Product_Type
> ='"&request.querystring("product_type")&"'

looks promising but there's no change. :-(

How do I do a response.write ?
<%
Response.Write "Variable value: " & Product_Type & "<P>"
%>

brings up nothing.

Darren


----- Original Message -----
From: "Matthias Ritzkowski" <Matt at grndwtr.com>
To: "Thelist (E-mail)" <thelist at lists.evolt.org>
Sent: Tuesday, August 27, 2002 4:11 PM
Subject: Re: [thelist] sql filtering problem


> 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
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !




More information about the thelist mailing list