|
Mailing Lists
|
Home / Groups / ColdFusion Talk (CF-Talk)
Cool feature I didn't know aboutMost of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson |
May 21, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||