Never use a variable name more than once.. Try and use a system; e.g.
stXXXXX for a Structure rsXXXXX for a Query Result arXXXXX for an Array etc... these are just examples not erm in Stone. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 21:42 To: CF-Talk Subject: Re: Brainfart - Need Help 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
