I said this before you said that but I knew you were gonna say that so I was able to say this about that.
..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 2:00 AM To: CF-Talk Subject: Re: Any way to make this query work like this? Aye. I had replied before your followup :) On Sun, Jun 29, 2008 at 10:43 PM, James Holmes <[EMAIL PROTECTED]> wrote: > Agreed, hence my followup post. > > On Mon, Jun 30, 2008 at 1:10 PM, Charlie Griefer > <[EMAIL PROTECTED]> wrote: >> 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:308303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
