In reading through this thread, it appears as though one of your lists (not
clear whether it's the short or long list) is sourced from database, and the
other not. But if you've got one list of key column values in a CF List var,
then you should be able to query the database to pull out everything NOT IN
that list. Something like:
<cfquery name="UniqueRecords" datasource="MyDatasource">
SELECT DISTINCT SomeColumn
FROM SomeTable
WHERE SomeColumn NOT IN (<cfqueryparam cfsqltype="cf_sql_varchar"
list="yes" value="#OtherList#">)
</cfquery>
Then ValueList the column from that result, append your other list, and you
should have your comprehensive list, with no dupes:
<cfset ComprehensiveList = "#ValueList(UniqueRecords.SomeColumn)#,#OtherList#">
-Christopher
> I'm checking to be sure there are any duplicates between the two lists
> ...
> [other content and sample code clipped]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
