In fact cfqueryparam is the best solution, now I see your data is a string:
select p.street_number, p.street_name, p.city from properties p where p.city in (<cfqueryparam cfsqltype="cf_sql_varchar" value="#session.approved_cities#" list="true") On Mon, Jun 30, 2008 at 1:07 PM, James Holmes <[EMAIL PROTECTED]> wrote: > select p.street_number, p.street_name, p.city > from properties p > where p.city in (#session.approved_cities#) > > Although you should use cfqueryparam. > > On Mon, Jun 30, 2008 at 12:56 PM, Rick Faircloth > <[EMAIL PROTECTED]> wrote: >> Hi, all... >> >> Any way to make this kind of query work? >> >> <cfquery name="get_properties" datasource="c21ar"> >> >> select p.street_number, p.street_name, p.city >> from properties p >> where p.city exists in #session.approved_cities# >> >> </cfquery> >> >> Basically, I've got a list of "approved" cites. >> >> I want to query for cities in my db where the city name >> is in the list (session.approved_cities) >> >> I've "in" "exists in" "contained in", etc. >> >> ??? >> >> Thanks, >> >> Rick >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
