Brainfart - Need Help

2002-05-21 Thread Chris Montgomery
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

RE: Brainfart - Need Help

2002-05-21 Thread Kevin Schmidt
, 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

Re: Brainfart - Need Help

2002-05-21 Thread Paul Giesenhagen
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

Re: Brainfart - Need Help

2002-05-21 Thread Jerry Johnson
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

RE: Brainfart - Need Help

2002-05-21 Thread Tony Gruen
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

RE: Brainfart - Need Help

2002-05-21 Thread Neil Clark - =TMM=
!! 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#

Re: Brainfart - Need Help

2002-05-21 Thread Chris Montgomery
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.