Due to the double evaluation nature of IIF, you have to double escape text
results in IIF. For example:
IIF(1 eq 1, 'one', 'not one')
What you see there is single quotes around double quotes. This can also be
done with the DE() function, but that's a waste in my mind.
http://www.fusionauthority.com/Techniques/Article.cfm/ArticleID:2531
I am using the CF report builder and having a tough time with a
conditional statement.
What I want to achieve is a field on the report that says either C or
FFS
What I want this to say is... If #query.capdate is before January 1,
1900, show FFS, otherwise show C
How do I make this work on the field in the report writer? I have tried
four billion things and keep getting an error saying that C is not a
valid variable name!
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it
from your system.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
Thank You,
Viahealth
**
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226249
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54