These functions don't appear in MSSQL7.0... the mod function is represented by '%' in the select as a function... so far, I'm not a real lot closer to answer this problem. Anyone know of a way to create some sort of on the fly Identity number (rowcount in cf) that would all this usage?
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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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