Karl,
The problem is the pound signs in the second part (DE("cc=""#myCClist#""")).
According to the Help on iif, pound signs cause the value to be filled in
right away. DE does not delay this. So in your case, when the variable
doesn't exist, it's trying to fill it in, and it never executes the test for
existence. Unfortunately, I don't know a way to make this work using just
iif (without cfif). You could use one of the following:
<CFIF IsDefined("myCClist") AND myCClist IS NOT "">
cc="#myCClist#"
</CFIF>
or
<CFIF IsDefined("myCClist")>
#iif(myCClist IS NOT "",DE("cc=""#myCClist#"""),DE(""))#
</CFIF>
The top one works because CF is smart enough to not check the second
condition if the first is not met (there is no point, since it's an AND).
~ Amy ~
-----Original Message-----
From: A. Karl Zarudny [mailto:[EMAIL PROTECTED]]
Sent: May 23, 2002 11:32 AM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] iif error
Hi everybody.
Any insight as to why
#iif(IsDefined("myCClist") AND myCClist IS NOT "", DE("cc=""#myCClist#"""),
DE(""))#
would be returning the following error?
An error occurred while evaluating the expression:
#iif(IsDefined("myCClist") AND myCClist IS NOT "", DE("cc=""#myCClist#"""),
DE(""))#
Error near line 280, column 3.
------------------------------------------------------------------------
Error resolving parameter MYCCLIST
ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:
1. You have misspelled the parameter name, or
2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or
CFTABLE tag.
The error occurred while processing an element with a general identifier of
(#iif(IsDefined("myCClist") AND myCClist IS NOT "", DE("cc=""#myCClist#"""),
DE(""))#), occupying document position...
Is there a better way for me to do the same thing? This piece of code as I'm
sure you can guess, is going within a cfmail tag. myCClist is cfset and does
not result from a query. But regardless my thinking is that iif'ing with
"IsDefined" is checking for myCClist's existence and it having values.... OR
am I once again falling victim to sleep deprivation?
Thanks,
Karl
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "A. Karl Zarudny"
<[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Lauritzen, Amy [Ontario]" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
