Crap, even my code had a typo; I missed a ">": where p.city in (<cfqueryparam cfsqltype="cf_sql_varchar" value="#session.approved_cities#" list="true">)
On Mon, Jun 30, 2008 at 9:17 PM, James Holmes <[EMAIL PROTECTED]> wrote: > Yes, you forgot the () around the cfqueryparam tag. Check my code again... > > On Mon, Jun 30, 2008 at 9:14 PM, Rick Faircloth > <[EMAIL PROTECTED]> wrote: >> Ok... it's a draw. I think you both replied simultaneously >> and with equal fervor! >> >> Now, back to the issue at hand! :o) >> >> The solution isn't working for me. (Even with CFQP) >> >> <cfquery name="get_properties" datasource="XXXX"> >> >> select p.street_number, p.street_name, p.city >> from properties p >> where p.city in <cfqueryparam cfsqltype="cf_sql_varchar" list="yes" >> value="#session.approved_cities#"> >> >> </cfquery> >> >> Anything wrong with the code (typo's, etc)? >> >> Any other ideas why it's not working? >> >> Rick >> >> >> >>> -----Original Message----- >>> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] >>> Sent: Monday, June 30, 2008 7:31 AM >>> To: CF-Talk >>> Subject: RE: Any way to make this query work like this? >>> >>> 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 >>> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
