RE: mssql pagination

2008-01-03 Thread Dan G. Switzer, II
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-Talk Subject: mssql pagination I

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 40? It's

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?

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

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

RE: mssql pagination

2008-01-02 Thread Adam Churvis
] Sent: Wednesday, January 02, 2008 6:01 PM To: CF-Talk Subject: mssql pagination 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

RE: mssql pagination

2008-01-02 Thread Adam Churvis
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 ~| Adobe® ColdFusion® 8 software 8 is the most