IIf() - Mix literal with variable evaluation

2006-01-09 Thread Jim McAtee
I always run into this, and I've probably come across a solution, but forgotten it. In an IIf() I can easily return the value of a varible by surrounding it in quotes, or return a literal by using DE(), but how to use both? What would be the correct syntax to use in the first argument to

Re: IIf() - Mix literal with variable evaluation

2006-01-09 Thread Zaphod Beeblebrox
cfset a = loc.address IIf(Len(loc.city), DE(, #loc.city#) , DE()) On 1/9/06, Jim McAtee [EMAIL PROTECTED] wrote: I always run into this, and I've probably come across a solution, but forgotten it. In an IIf() I can easily return the value of a varible by surrounding it in quotes, or return a