I believe Trey wants to know if a particular variable/field has a value. A record can be returned with an empty field, which makes <cfif queryname.recordcount> evaluate to true even though the field/variable is empty.
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -----Original Message----- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:59 PM To: CF-Talk Subject: RE: if value exists, show it I thought the question was: <snip> I simply want to test to see if a variable has a value (eg text has been returned from a query) and if so, show it. </snip> ???? *********** REPLY SEPARATOR *********** On 6/3/02 at 3:44 PM Chris Lofback wrote: >Well, this only tells you if any records were returned, not if a >particular >field in a record is empty... > >Chris Lofback >Sr. Web Developer > >TRX Integration >28051 US 19 N., Ste. C >Clearwater, FL 33761 >www.trxi.com > > >-----Original Message----- >From: Terry [mailto:[EMAIL PROTECTED]] >Sent: Monday, June 03, 2002 3:43 PM >To: CF-Talk >Subject: Re: if value exists, show it > > >If you're wanting to know if it was returned from a query.. ><cfif queryname.recordcount> > #variable# ></cfif> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists