Yeah, rowcount is the issue. SQL Server has no rowcount functionality unfortunately. A temporary table is probably the most used way around the problem. http://www.faqs.org/faqs/databases/sybase-faq/part14/ About midway down on the page, it tell you how do get a rowcount. This is for Sybase, but SQL Server syntax should be the same.
If you are planning on doing this query often, it might make sense to cache all twenty thousand records in CF, and use the rowcount property. -- jon mailto:[EMAIL PROTECTED] Sunday, September 1, 2002, 8:45:13 PM, you wrote: JG> These functions don't appear in MSSQL7.0... the mod function is represented JG> by '%' in the select as a function... so far, I'm not a real lot closer to JG> answer this problem. Anyone know of a way to create some sort of on the fly JG> Identity number (rowcount in cf) that would all this usage? JG> At 05:03 PM 9/1/2002 +0200, you wrote: >>Jesse Houwing wrote: >> > >> > In MySQL, PostgreSQL and such: >> > >> > SELECT * FROM table LIMIT startrow, numberofrows >> > >> > so the 15000th item en the 15 following it would be: >> > >> > SELECT * FROM table LIMIT 15000, 15 >> >>Deprecated syntax for PostgreSQL. Use LIMIT ... OFFSET ... instead. >> >>SELECT * FROM table LIMIT 15 OFFSET 15000 >> >>Jochem >> >> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
