You can use the max rows in the cfquery or run a cfloop over the query
> ** Original Subject: RE: ORACLE and SQL
> ** Original Sender: "Todd McFarlin" <[EMAIL PROTECTED]>
> ** Original Date: Thu, 14 Dec 2000 14:21:44 -0500
> ** Original Message follows...
>
> Greetings,
>
> Being an Oracle person, I'm having a difficult time trying to make a
> CFQuery work correctly in SQL.
>
> The Problem: I have a database with thousands of rows. I need to select only
> 50 rows per query. The start row and end row need to be variables. Now,
> Oracle has a function called RowNum. In the Where part of a query, it allows
> the selection of certain rows from the table between two set
> paramaters...something like select rows >=50 and <=100. This yields 50 rows
> returned.
>
> My Question: Is there a similar function in SQL, or how is this
> accomplished?
>
> My thanks,
>
>
> Todd McFarlin
> Celosis, Inc.
> [EMAIL PROTECTED]
> (510) 814-3078
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
