I've set up a function (taken from the Adobe site) which concatenates address
fields and is suppose to return one nice address block...
i've placed the function on the report detail band and reference
report.Format_address(query.ADDR1, query.ADDR2, etc) ...all my address fields
in the Expression Builder.
when I try to run the report i get the following error message
Diagnostics:Invalid ColdFusion expression in report. If the expression is a
string, ensure that it is within quotes. Error:
#report.Format_Address("query.ADDR1","query.ADDR2")# is not a valid ColdFusion
expression. <br>The error occurred on line -1.
I've tried referencing the function name and variables with single quotes,
double quotes, with #, without # and still the same error message as above....
I've also made sure there is data in both address fields i am testing with and
still the same error.
What can I be doing wrong ??
Any suggestions would be greatly appreciated.....thank you very much....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
