[thelist] SQL problem

[Jay Blanchard]

[snip]
which works fine and displays all the results. However, I don't know if this
is an Access issue, but instead of showing the results as
1 2 3 4 5 6 7 8 9 10 11 etc
it shows them as
11 10 1 2 3 4 5 6 7 8 9
which is why I want to order them properly.
[/snip]

This can all be done in SQL, then displayed via ASP. Post the table
structure and let's have a go at that.

Jay

***********************************************************
* Texas PHP Developers Conf  Spring 2003                  *
* T Bar M Resort & Conference Center                      *
* New Braunfels, Texas                                    *
* San Antonio Area PHP Developers Group                   *
* Interested? Contact jay.blanchard at niicommunications.com *
***********************************************************