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] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
