I bumped my head against this one just this morning...:)

Is Company a field from a query?

If so, you cannot just set its value, you need to either QuerySetCell or create a temp 
scoped variable for the result

Jerry Johnson

>>> [EMAIL PROTECTED] 05/21/02 04:37PM >>>
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

Reply via email to