Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Submit Form data to 2 places

    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

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    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
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Posting to a database

    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

  4. #4
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    www.asp101.com/samples has some good, short database examples.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •