Let users sort table contents?

Hi

This is a better explanation of my last post.
I am trying to make an asp web page so that a table list of information
can be set, so the user can sort the table view to their own preference.
i.e.. if the table had 3 columns, name, town & country, the user could view
the list by alphabetical name ascending or alphabetical by town descending.

I have managed to get the table up and running, pulling data from
a remote server's database, but could do with a site maybe, that will
provide a tutorial on setting the above up.

I could not find anything in the DW help section on this?

Hope someone can point me in the right direction?

Many thanks

Craig.

Hi Craig,

You need to have a link on your page which lets the user modify the ORDER BY
part of the query:

i.e. SELECT * FROM Addresses ORDER BY TOWN

HTH

"Craig W" <craig (AT) happy100 (DOT) freeserve.co.uk> wrote

Hi

This is a better explanation of my last post.
I am trying to make an asp web page so that a table list of information
can be set, so the user can sort the table view to their own preference.
i.e.. if the table had 3 columns, name, town & country, the user could
view
the list by alphabetical name ascending or alphabetical by town
descending.

I have managed to get the table up and running, pulling data from
a remote server's database, but could do with a site maybe, that will
provide a tutorial on setting the above up.

I could not find anything in the DW help section on this?

Hope someone can point me in the right direction?

Many thanks

Craig.