Create a search form using ASP

[DavidArchibald]

I want to create a search form using ASP which can be customised (we need to add some Javascript to the page displaying the results).

The web is managed by FrontPage 2000 and the server is Windows 2000/IIS5.

What's the best way to achieve a simple but effective search form that allows us to tweak the code?

Help appreciated - especially pointing me to the sites where it's all in black and white ...

Cheers

 

[Bastien]

Hi david,

you could try using sql scripts / queries against a database
table that will contain some type of ID towards the information that you are looking for...

then just report the results of the search and let the user choose the specific data that they are after...

step 1. create a form that contains the items to be searched for - ClientID, product ID, Dates etc, whatever the fields you feel needed to conduct the search.

setp 2. - dynamically create the query using "select * from table_name where" and then using If...Then statement ro build the query to match the input parameters.

step . - display the resulting recordet back to the user and let them then choose the item needed...

hope this helps

Bastien