it may be recordcount - 1 -- Sam
-----Original Message----- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:38 PM To: CF-Talk Subject: RE: Make last line of query available Will something with startrow and recordcount work? ex.. <cfoutput query="revquery" MAXROWS="1" STARTROW="#revquery.recordcount#"> <cfset last_value="#triptrav_seq#"> </cfoutput> -- Sam -----Original Message----- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2: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] ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
