i want to sort some stuff by letter, and have them in different sections (a, b, c)
i can do this with multiple queries, but i would have to have 27 queries and i believe that will probably bog down the system.

I know there has to be a better way to do it, so if anyone can throw a bone my way, thanks in advance

-I am beyond the line of Morality and therefore, beyond caring.

Yikes, 27 recordsets...
Imagine just 10 people accessing this page at the same time...

Why don't you list all values with A on the main page and link the page to B-Z and when user clicks B it only returns B. You can use URL parameter like AlphaID=B and filter on that, when you setup the page you can give it a default of A so it lists A if no parameter is found.

Big sites almost always use this trick, it also helps cut down the tons of information on a single screen.

Imagine having over 10.000 records, would you rather show all 10.000 on one page and use Ankers to jump to them only to get complaints that if multiple users access the page at once not all records are returned and the links after P don't work or would you like a site that's responsive with only a few 100 records returned at a time. In either case, you also want to limit the amount displayed to about 50 records.

If you MUST have it all on one page then try looking at this tutorial and the accompanying extension:
www.basic-ultradev.com/exthelp/categoryanchorlinks/


With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services

yeah.. tha'ts what i though.. thanks.

-I am beyond the line of Morality and therefore, beyond caring.