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:321360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
