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:308293
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
