Treat it as a structure. revquery.rev[revquery.recordcount] should do it
~bgl ------------------------------------------------------ Brian Ledwith "Stupefying...prodigious...asinine..." --Mac Wellman Learning Express, LLC. www.learnatest.com / www.learningexpressonline.com 900 Broadway NY NY office: 212.995.2566 x150 facsimile: 212.995.5512 mobile: 917.957.9166 ------------------------------------------------------ -----Original Message----- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 5:32 PM To: CF-Talk Subject: Re: Make last line of query available Help, I know this is probably a silly question but I can not find how to point at the last record in this query. I would like to make the last value for triptrav_seq,value is currently 41456 for this query, available for use. Is there a method to point to the last record of an ordered query and make the variable triptrav_seq available???? I would appreciate any input you can give. <CFQUERY NAME="revquery" datasource="#application.issrtd#"> SELECT rev, triptrav_seq, rownum FROM rtd_triptrav WHERE rtd_trip_id = '#trip_id#' Order by rtd_triptrav.rev </CFQUERY> A 1 40777 A 2 40778 A 3 40779 A 4 41456 Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
