Charlie! You did it!!! Dahnke! ¡Gracias! Thank you! Thank you! Thank you!!!
It's taken me all day to get this right. Thank goodness, I'm self-employed or I'd be looking for a new place to sit down to work. Dave > -----Original Message----- > From: Charlie Griefer [mailto:[email protected]] > Sent: Monday, April 06, 2009 1:13 PM > To: cf-talk > Subject: Re: Finding values not in a list > > > > On Mon, Apr 6, 2009 at 11:02 AM, Dave Long > <[email protected]> wrote: > > > > So far, I am unable to find any other syntax for comparing > the second > > query results to the list. Can anyone advise me? > > look into the valueList() function for getting a > comma-delimited list of values from a query column. > > Your IN values need to be enclosed in parentheses: > > AND MLS_Number NOT IN (#valueList(GetRecord.MLS_number)#) > > ... and you'll also want to cfqueryparam that: > > AND MLS_Number NOT IN (<cfqueryparam > value="#valueList(GetRecord.MLS_number)#" > cfsqltype="cf_sql_integer" list="true" />) > > -- > I have failed as much as I have succeeded. But I love my > life. I love my wife. And I wish you my kind of success. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
