dynamically display the fields

[J P Singh]

Hi All

I have been given the task to create a search page to search on of the
tables in the sql database.

I have been asked that the user should be able to search any field(which I
have done) but he should also be able to customise the form to display or
hide any feilds in the results.

My table has about 20 feilds and different users wanting to you the search
page will like to see different set of fields.

Can anyone help me doing this please

thanks

 

[Dan Brussee]

In order to make the SQL less complex, I would always pull the same
result set back from the database and use ASP code to determine which
fields, and which order they should be displayed.

Come up with a way of specifying fields and order that you can parse
through one at a time and save it in the user's record in the database
for future use.

One last thing to consider, depending on what fields and what order
they want them, keep in mind that they will probably want to specify
sort order too.