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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

