Hi, I am using SQL Server 2005 in my app and I was wondering if reactor has a built in offset method in it.
In SQL Server, offset is not defined as it is in mysql, this makes pagination hard. The principle of doing pagination with SQL server is not too difficult. You just have a ROW_NUMBER() field attached to the rest of the query and fake the offset that way. Any ideas are greatly welcomed. Thank you, Roland -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
