> alright, i'm trying to create a "previous/next" statement so that
> my query only grabs 6 records at a time.
How about using a cursor and submitting the ID of the last record processed
as a parameter to the stored procedure? Then just loop through the results
until you hit the ID passed to the procedure and return the next 6 rows.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www.hallofsports.com
.. . . where the legends live on
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
