You can't change the value of a query result (I think) Try this instead:
<cfif Not Len(company)><cfset variables.company = query.company><cfelse><cfset variables.company = "blah blah"> #variables.company# Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Chris Montgomery" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 3:37 PM 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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
