something like arrayMax(myQuery[myColumn]) should do the trick.
--
Timothy Heald
Web Portfolio Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319
The opinions expressed here do not necessarily reflect those of the U.S.
Department of State or any affiliated organization(s). Nor have these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
-----Original Message-----
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:49 PM
To: CF-Talk
Subject: queryNew / array functions
"Coldfusion queries are essentially arrays with named columns. You
therefore
can use any of the array functions with queries" -CFMX WACK
How would I use say ArrayMax() to get the largest value in a specified
column
of a query I created using queryNew.
I think my brain left work at lunch today
-seth
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- queryNew / array functions Turetsky, Seth
- Re: queryNew / array functions Heald, Tim
- Re: queryNew / array functions Deanna Schneider
- RE: queryNew / array functions Turetsky, Seth