<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
Paginating Record Sets In ColdFusion With One SQL Server Call
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:990.view
Date Posted:
Oct 11, 2007 at 9:03 AM
---- --------------------------------------------------------------------------------------- --->
DECLARE @id TABLE (
id INT,
row_number INT IDENTITY( 1, 1 )
);
DECLARE @row_count INT;
INSERT INTO @id
(
id
)(
SELECT
t.id
FROM
(
SELECT TOP 1000
b.id
FROM
blog_entry b
WHERE
CHARINDEX( 'ColdFusion', b.name ) > 0
ORDER BY
b.name ASC
) AS t
);
SET @row_count = (
SELECT
COUNT( * )
FROM
@id
);
SELECT
b.id,
b.name,
b.date_posted,
b.time_posted,
i.row_number,
( @row_count ) AS row_count
FROM
blog_entry b
INNER JOIN
@id i
ON
(
b.id = i.id
AND
i.row_number >=
AND
i.row_number <
)
ORDER BY
i.row_number ASC
;
ColdFusion / SQL Pagination Demo
Blog Entries
#qBlog.name#
Record #qBlog.row_number# of
#qBlog.row_count#