At 01:41 AM 8/20/2000 -0400, you wrote:
>Assuming you have a counter in the table, order the results by that counter
>reversed (using order by colname desc). Then, in the CFQUERY tag itself, set
>the maxrows to 10.
This works with MS SQL 7
<CFQUERY name="" datasource="">
SELECT Top 10 uniquecolumnid From table
ORDER BY uniquecolumnid desc
</CFQUERY>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
