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]
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
