Hello Folks

I have a search engine on our site, I need to be able to record what users have searched on by entering there request into a database as well as displaying the results as usual for the user.

Im using II6 - ASP and MS SQL

Any help please getting me started ?

Thanks in advance

Donald

Which part are you having trouble with, storing something in the database, or showing the results of a search? And if you can do both, then there is no reason you can't do them both on the same page.

If you re-use a recordset object just be sure to close it properly inbetween uses:

' Close rs.
objRS.Close
Set objRS = Nothing

Hi, Ive got the search working fine - Its just figuring out the concept of posting the data into a db.....

Do you know of any examples anywhere ?

Donald

www.asp101.com/samples has some good, short database examples.