RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
That will definitely help my footing as well! Arguably even more than my fringe case that I couldn't work around. ;) Thanks, Jochem! Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

Re: mssql pagination

2008-01-03 Thread Jochem van Dieten
Jonathon Stierman wrote: > As for 2000 being out of date, I hear you there -- I'll have to push to get > the budget for it. At least now I have some leverage (a problem that can't > easily be fixed otherwise). How about "mainstream support ends this year"? http://support.microsoft.com/lifecycle/s

RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
Thanks Dan, Adam, and Eric! I haven't played around with stored procedures much, so this will give me a chance to give them a whirl. As for 2000 being out of date, I hear you there -- I'll have to push to get the budget for it. At least now I have some leverage (a problem that can't easily be

Re: mssql pagination

2008-01-03 Thread Jim Wright
On 1/2/08, Jonathon Stierman <[EMAIL PROTECTED]> wrote: > You can see in the "All Samples" section that records 20-30 should be: [147, > 148, 149, 150, 63, 36, 40, 382, 383, 384]. > But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382, 383, > 384, 440]. > What happened to record 4

RE: mssql pagination

2008-01-03 Thread Dan G. Switzer, II
ith several millions of records and had great success with it. Also, in SQL Server 2005 you can solve this problem with Common Table Expressions (CTE) -Dan >-Original Message- >From: Jonathon Stierman [mailto:[EMAIL PROTECTED] >Sent: Wednesday, January 02, 2008 6:01 PM >To: CF

RE: mssql pagination

2008-01-02 Thread Adam Churvis
Churvis President Productivity Enhancement > -Original Message- > From: Adam Churvis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 02, 2008 7:38 PM > To: CF-Talk > Subject: RE: mssql pagination > ~| Ad

RE: mssql pagination

2008-01-02 Thread Adam Churvis
in memory for a number of reasons. Hope this helps. Respectfully, Adam Phillip Churvis President Productivity Enhancement > -Original Message- > From: Jonathon Stierman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 02, 2008 6:01 PM > To: CF-Talk > Subject: mssql p

mssql pagination

2008-01-02 Thread Jonathon Stierman
I can't imagine I'm the first person to try to do something like this, so hopefully you guys can give me some insight! I know this isn't strictly CF-related -- but I'm hoping some of you have tried to do something like this in the past. I'm trying to produce a paginated list of records. The quer