basic access asp search

[obaluba]

Hello,
I've got an access database, the results of which are produced on a webpage via asp.
What i would like to do is a basic search with a textbox where the user enters some criteria and if found the results appear.

The other thing i wanted to do was have a drop down box with certain criteria in it, ie; blue, red, green and when say red is selected it brings everything up in the database thats red!

are there any tutorials for this? Any quick solutions

thankyou very much in advance

 

[dellyjm]

For the textbox one.

first: get the value the user entered
Dim sUserVal

sUserVal = request("txtUserVal&quot

you need to second connect to db
Set conn = server.createobject("ADODB.COnnection&quot
Set rs = server.createobject("ADODB.Recordset&quot

conn.open CONN_STRING, USERID, PASSWORD
rs.open "Select * from DBTable where searchfield like %" & sUserVal & "%", conn

Dim sColor
sColor = request("cboColor&quot

do same select where fieldname = sCOlor

Hope this helps.


Delton.