> First time using this tool and I struggle with something > easy. I have added a field to the report. Based on the > content of the field, it should show different text. Here's > the expression: > > iif([query.feedesc] = "COMMERCIAL", "COMMERCIAL > BEACH",iif([query.feedesc]="GOVERNMENT","GOVERNMENT OWNED > BEACH",""),"") > > I keep getting an error: > If the expression is a string, ensure that it is within > quotes. Error: iif([query.feedesc] = "COMMERCIAL", > "COMMERCIAL > BEACH",iif([query.feedesc]="GOVERNMENT","GOVERNMENT OWNED > BEACH",""),"") is not a valid ColdFusion expression.
The 2nd and 3rd arguments for Iif are treated as executable CF expressions, not literal strings. If you want literal strings, you'll need to wrap them in the DE function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4