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