Hmmm... can't get that to work. This is MySQL 5... can you verify it works?
I get an Error 500 from the browser. Rick > -----Original Message----- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2008 1:08 AM > To: CF-Talk > Subject: Re: Any way to make this query work like this? > > 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:308297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4