from sql, or once it has already been returned to cf? from sql: select min(whateverColumn) from foo where foo = foo
from cf: a bit trickier, however, I would start with query.recordCount as a number that will be important to you, and something that would help you. I know the query is returned as a structure, you could get the first position of the structure, and then the position of the structure that is equal to query.recordCount hthx ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:01 AM To: CF-Talk Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
