displaying the last 5 records

[thnguyen]

Hi,

I want to display the last 5 or 10 records, for example a table with 50 records but i just want to get and display the last 5 records of the 50 records. any suggestions?

[simontux]

One way that I can think of is to get the total recordcount

<cfset totcount = #query.RecordCount#>

<cfset startrow = #totcount# - 10>

<cfoutput query="query" startrow="#startrow#">

There is probably another way of doing it, but this is the first thing that
came to mind.

[Bill Marcus]

<cfquery datasource="MYDSN" name="MYQUERY" maxrows="5">

Make sure you specifiy the DESC tag in your SQL to list the most recent.

Bill

"simontux" <simon@tumeki.co.nz> wrote in message
news:d5t24i$l82$1@forums.macromedia.com...

> One way that I can think of is to get the total recordcount
>
> <cfset totcount = #query.RecordCount#>
>
> <cfset startrow = #totcount# - 10>
>
> <cfoutput query="query" startrow="#startrow#">
>
> There is probably another way of doing it, but this is the first thing
> that
> came to mind.
>