Please explain how you use SELECT TOP with
the second paragraph below.
best, paul
At 03:25 PM 8/3/00 +0100, you wrote:
>It's a lot quicker (and smoother) to use the SQL command TOP, i.e.;
>select top 50 *
>from myTable
>where myField='#myValue#'
>
>One way I handle this is to have a list of IDs that I pass from page to
>page, and then pass the start position, then build a smaller list of entries
>from this list for the 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.
