<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
