> > <CFloop query="get"> > <CFQUERY name="check" datasource="spice"> > Select * from spice > where serialnumber = '#trim(get.serialnumber)#' > </cfquery> > > <CFIF get.recordcount eq 1> > <CFoutput>#trim(check.serialnumber)# -- > #trim(get.serialnumber)#<br></CFOUTPUT> > <cfelse>NO MATCH - <cfoutput>#get.recordcount#</cfoutput><br> > </CFIF> > </cfloop>
Yep, <CFIF get.recordcount eq 1> should be <CFIF CHECK.recordcount eq 1>. Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4