[thelist] Column Links for Sorting

[John Meyer]

Check out 4guysfromrolla.com

They have some code that does exactly what you want.

At 11:48 PM 6/17/2001 -0400, you wrote:
>I have an access database I want to create a hyperlink on each column
>heading, so that when any column heading is clicked on, the query will
>return the same table but sorted by the column clicked.
>
>sql = "select qb.name, " -
>              "qb.passatt, " _
>              "qb.passyards, " -
>              "qb.passint " -
>       "FROM qb " _;"
>
>If I just script- "Sort by qb.name " _;" then the table shows sorted by
>player name.
>How can I write a query so that hyperlinks exist on each column heading to
>sort the table by a particular column??
>
>Thanks
>
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !

John Meyer
john_meyer at geocities.com
Programmer


If we didn't have Microsoft, we'd have to blame ourselves for all of our 
programs crashing