Sorry forgot to mention I am using MySQL5 here. > 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:4559 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
