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
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
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
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
Jonathon,
Here's a stored procedure you can use in MSSQL 2k for pagination:
http://blog.pengoworks.com/index.cfm/2006/6/19/MSSQL-2k-Stored-Procedure-for
-Pagination
It doesn't use #temp tables and it will only return the pages of data you're
after. I've used it on tables with several millions of
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
It's easy in SQL 2005, and very scalable for large rowsets:
WITH PagedResultSet AS (
SELECT
ROW_NUMBER() OVER(ORDER BY LastName ASC, FirstName ASC) AS
RowNumber,
UserID,
Email,
LastName,
FirstName
FROM
7 matches
Mail list logo