Hi folks, I am trying to pull records that are not in a pre set list of ids generated from a query and I'm not having any luck with getting this worked out thus far. What I have is: <cfquery name="testlist" datasource="myds"> SELECT * from temp_votes WHERE voter_id = 19 </cfquery>
<cfset ThisList = ValueList(testlist.packet_id, ",")> <cfoutput>#ThisList#</cfoutput> output is fine here but this bombs out with: Complex object types cannot be converted to simple values <cfquery name="getNewList" datasource="myds"> SELECT * FROM review_packets WHERE id NOT IN(#ThisList#) </cfquery> <cfoutput>#getNewList#</cfoutput> is what I'm trying to do here even possible? If so can someone shed some light here for me please? TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4558 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
