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]

Reply via email to