Scope your variable. #Company# in the query is different from company set using <cfset> one is in the variables scope the other is in the scope of the query.
Why not do this: <cfif company neq ""> Blah Blah <cfelse> #company# </cfif> -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 3:38 PM To: CF-Talk Subject: Brainfart - Need Help Hello Cf-Talk, I'm having a major brainfart here. After running a query I need to output a list of order info. If a field is blank, I want to output a default value instead of just showing a blank. Within the query output block, this works: <cfif Not Len(company)>blah blah<cfelse>#Company#</cfif> (if the value of Company returned by the query is blank, "blah blah" gets displayed) But if I do this, it doesn't work: <cfif not len(Company)><cfset Company = "blah blah"></cfif> #Company# (no "blah blah" if the returned Company field is blank) What am I not seeing here? I know it's gotta be something blatantly simple, but I'm having one of those senior moments. :) TIA. -- Chris Montgomery [EMAIL PROTECTED] Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
