Create a search form to look up a table?? Please Help :(

[Guest_imported]

I would liek to create a search form with only one box (lets call it, "Enter number&quot. From here, the user will enter a number, and the form will look to a table and output the corresponding recordset. Any suggestions on how to do this? Thansk in advance!!

 

[twcman]

You would use ASP or ColdFusion or some other dynamic database application. I am partial to CF myself.

But no matter what you use you need to "connect" to the database, query a table base on the "search" parameter and then display the recordset.

CF it is pretty straight forward, about 15 lines of code to do a basic display of results.
The only dumb questions are the ones that are never asked

 

[NHorley]

Hi

I would use an ASP page (as I don't know CF). It's quite easy to set up insert your database connection and put in the following SQL:
SELECT * FROM Table name WHERE Field_Name='::Field_Name::'

This will produce the text box in a form for you with the database results appearing underneath it.

hope this helps!