By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,916 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,916 IT Pros & Developers. It's quick & easy.

dynamically display the fields

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
On Wed, 19 Nov 2003 16:17:17 -0000, "J P Singh" <noemail@asIhatespam>
wrote:
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


Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.