Mart Stewart wrote:
>Try:
><cfquery name="name" datasource="datasource" maxrows="10">
>SELECT [FieldNames]
>FROM [TableName]
>ORDER BY [FieldName] DESC
></cfquery>
>HTH,
Going slightly OT now but this is one that has been niggling me for a long
time - is it possible in (simple) vanilla SQL (ANSI std) to specifiy the
number of records to be returned ?
Thanks,
Cam.
-----------------------------
Campbell Morton
Application Developer
Facilities Assist
www.facilitiesassist.com.au
-----------------------------
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
