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> *********** REPLY SEPARATOR *********** On 6/3/02 at 1:08 PM trey wrote: >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. There seem to be a few options >-- > ><cfif isdefined(#variable#)> > #variable# ></cfif> > >or > ><cfif len(#variable#) GT 0> > #variable# ></cfif> > >or > ><cfif #variable# IS ""> > #variable# ></cfif> > >Is one of these better than the others for dealing with text values? I >understand that IsDefined should be locked; I assume that is not the case >for the other two. > >TIA, >Trey > > > ______________________________________________________________________ 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