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
