Your second selection concept was correct... eg :every third or 15th or 20th record
At 10:22 AM 9/1/2002 -0400, you wrote: > > 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
