found a fix! <cfquery name="getNEQnum" dbtype="query"> SELECT getZMA.Material FROM getZMA WHERE (1 = 1 <!--- Make sure the current record does NOT match any records in the B query.---> <cfloop query="getEQnum">AND getZMA.Material <> '#Material#'</cfloop>)
from: http://www.bennadel.com/index.cfm?dax=blog:1074.viewcode&index=1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
