RE: ORDER and LIMIT dilemma

2001-07-06 Thread Don Read
On 06-Jul-01 Tom Beidler wrote: > I have a dealer database with 3000+ records and I'm building a manager to > sift through the items. > > Currently I ORDER and LIMIT by name so I can come up with names that begin > with "A" and LIMIT the returns to 25, and then click to see the next 25 > names b

ORDER and LIMIT dilemma

2001-07-06 Thread Tom Beidler
I have a dealer database with 3000+ records and I'm building a manager to sift through the items. Currently I ORDER and LIMIT by name so I can come up with names that begin with "A" and LIMIT the returns to 25, and then click to see the next 25 names beginning with "A" etc. Now here's where I'm