Yes it worked...thanks all! -----Original Message----- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 10, 2008 11:01 AM To: CF-Talk Subject: Re: simple loop
> > <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:303100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4