Michael,
There are a number of ways to get the next and prev records. Go to
http://www.webtricks.com. He wrote a pretty nice "browse records" peice of
code. If that won't work just do a search in the CF forums at
allaire.com. This should help you.
Brett
At 03:10 PM 11/17/00 -0800, you wrote:
>This is what I'm trying to get away from. This is just outputting a subset
>of my entire recordset.
>
>If I've got a query that returns 125,000 records and only display 25 of
>them, it's a waste of the servers resources.
>
>Michael
>
>"Shawn McGehee" <[EMAIL PROTECTED]> wrote in message
>015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
> > <cfoutput query="myquery" startrow="26" maxrows="25">
> > blah blah blah
> > ...
> > </cfoutput>
> >
> > --Shawn McGehee
> >
> > ----- Original Message -----
> > From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, November 17, 2000 2:16 PM
> > Subject: scaleability of <cfoutput maxrows=x>
> >
> >
> > > I'm working on an inventory management system for a small subset of out
> > > product database (only about 3k records compared to about 125k records).
> > > When returning the recordset, I want to break it up into bite sized
> > chunks.
> > > Only problem is, using <cfoutput query="myQuery" maxrows=25>, the query
>is
> > > still returning about 3k records and only displaying 25. If this thing
> > ever
> > > gets to the point where I need to keep track of the entire product list
> > > (125k records), this is going to bog down things.
> > >
> > > Is there a way in SQL to set a start row for a query? I know I can use
> > 'set
> > > rowcount 25' to only get 25 records, but I then need to start again at
>row
> > > 26.
> > >
> > > Am I looking in the wrong place? Is there a different way of getting x
> > > records and then next x records on the SQL side?
> > >
> > > Oh, and I can't persist the data in a array of structures or wddx packet
> > > because it is inventory that changes quickly and needs to be accurate on
> > the
> > > execution of the query.
> > >
> > > Michael
> > >
> > >
> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > > 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
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > 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
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
