Return last record only 1

[varnix]

I have a query that I run on the history of a particular item.

The query of course returns all of the records in the history for that item.

In this one area I only need the last record.

Other than using a cfloop to get the data, is there an easier method of doing this, say via the query?

 

[webmigit]

<cfoutput>#QueryName.Fieldname[queryname.recordcount]#</cfoutput>

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[varnix]

webmigit - that's something that they never covered in any of my CF classes!

That worked perfectly!

Thanks again!

 

[webmigit]

Glad.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.