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. I can't see the problem. Help! Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4