On Sun, Jun 29, 2008 at 10: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.
without the cfqueryparam would probably need to throw a listQualify() around session.approved_cities to enclose each list element in single quotes. -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
