You can access the query as a array as follows: First Record : #myquery.myfield[1]#, #myquery.myfield2[1]#, etc...
Last Record : #myquery.myfield[myquery.recordcount]#, etc... HTH, Jeff Garza ----- Original Message ----- From: "Thane Sherrington" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 9:01 AM 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
