Can't you use Cold Fusion's startrow= and maxrows= to do the same thing?
<cfoutput query='myquery' startrow=51 maxrows=50>
P.S. I loved your comics, animations, film, and action figures :-)
At 10:17 AM 12/14/00 -0800, Todd McFarlin wrote:
>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
