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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
