RE: Finding the 'page' number of a record, or its position in resultset

Can't you just keep track of which page you are on, and multiply by 20 (except for the last page)? I must be missing something. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From:

Re: Finding the 'page' number of a record, or its position in resultset

Jerry Schwartz jschwartz at the-infoshop.com writes: Can't you just keep track of which page you are on, and multiply by 20 (except for the last page)? I must be missing something. Regards, Hi Jerry, The problem is that the page isn't necessarily known at the time we need to find out its

RE: Finding the 'page' number of a record, or its position in resultset

I'm still confused, are you saying that you want to know what page a team would be on if you did a listing? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: news [mailto:[EMAIL

Re: Finding the 'page' number of a record, or its position in resultset

Jerry Schwartz jschwartz at the-infoshop.com writes: I'm still confused, are you saying that you want to know what page a team would be on if you did a listing? Regards, Yes, given a query (e.g. SELECT ... FROM teams ORDER BY score DESC, errors) which we usually add a LIMIT clause to for