Dynamic Sorting of table with search

X

xx75vulcan

I have a page that contains a Search form which queries a database,
which
works. But I would also like to add a sorting feature to the table
columns.

Ex: When someone clicks on one of the Columns it will sort it either
ASC or
DESC I've tried the examples that I've found here & the internet, and
it's like (either one or the other) I can't get both of them to work
(Search form & Sorting on the results table)

How do I allow columns to be sorted (when clicked on) if that same
column is also a searchable through a search field?

Any ideas anyone.
 
S

Stefan B Rusynko

Or w/o using the DBRW see
http://www.asp101.com/samples/db_sort.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Database Results Column Sorting
| http://home.att.net/~codelibrary/FrontPage/drwsort.htm
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| | >I have a page that contains a Search form which queries a database,
| > which
| > works. But I would also like to add a sorting feature to the table
| > columns.
| >
| > Ex: When someone clicks on one of the Columns it will sort it either
| > ASC or
| > DESC I've tried the examples that I've found here & the internet, and
| > it's like (either one or the other) I can't get both of them to work
| > (Search form & Sorting on the results table)
| >
| > How do I allow columns to be sorted (when clicked on) if that same
| > column is also a searchable through a search field?
| >
| > Any ideas anyone.
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
List all tables, including document structure 0
Automation of scanned file storage based on content 0
DRW: Dynamic Sorting of Table w/ Search form 1
Excel does not accept text format! 0
Insert Index into a Table 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Can I save a sql statement generated by a search form? 1

Top