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:
blah blah#Company#
(if the value of Company
, 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
You can't change the value of a query result (I think)
Try this instead:
#variables.company#
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Chris Montgomery" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2
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
Wouldn't it be...
#variables.company##Company#
?
Tony Gruen
-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:38 PM
To: CF-Talk
Subject: Brainfart - Need Help
Hello Cf-Talk,
I'm having a major brainfart here. After runni
!!
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:
#variables.company#
Hello Kevin,
Yeah, I'll probably do what you suggested below. There's just a lot of
possible blank fields from the query getting returned and I was
looking for a shortcut from having to type a bunch of cfif's for every
field output.
Also, thanks to all the others who responded, I appreciate it.
7 matches
Mail list logo