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
