> Jim Gurfein wrote: >> Hi List, >> >> <Sorry for sending this again, but the list was having >> problems > >> >> All you gurus out there... I'm trying to find a way to >> select every nth >> record from a database that has 200,000 records. How >> would I go about >> setting up the SQL to select every 15th record ? >> >> Any and all help would be appreciated!
> 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 Oh duh... I didn't even think to ask... Did you mean for pagination, i.e. 1 2 3 4 5 next page Or did you literally mean 1 2 3 <- select this 4 5 6 <- and this 7 8 9 <- and this ?? Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
