not adding info to the database

Results 1 to 2 of 2

Thread: not adding info to the database

  1. #1
    twentythree Guest

    Default not adding info to the database

    I&#039m VERY new to ASP & SQL. Put it this way, I just started today. So i&#039m taking code and modifying it right now. But I have a database ready to go, my question is I have a page where the user inputes info( normal HTML file) that file goes to a file where it processes the info and adds it to the database.<BR><BR>It connects to the database BUT where do I tell it to connect to a specific table or do I need to do that??<BR><BR>The URL is http://www.virtual-fx.net/training/add.asp<BR><BR>I&#039m stumped and don&#039t know what to do. I really wanna learn ASP but I&#039ve looked at code for 8 hours and still can&#039t figure it out!<BR><BR>-- Amanda

  2. #2
    Join Date
    Dec 1969
    Posts
    2,238

    Default RE: not adding info to the database

    You need to set up an ADO Connection. Check out http://www.wrox.com for books on this subject.<BR><BR>I typical connection string would look like this..<BR><BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>Set oRS = Server.CreateObject("ADODB.Recordset")<BR>cn.Open "DSN=DB;UID=name;Password=password;"<BR>oRS.Active Connection = cn<BR><BR>&#039 then your code in here<BR><BR>&#039 then clean up<BR><BR>oRS.Close<BR>cn.Close<BR>Set oRS = Nothing<BR>Set cn = Nothing

Posting Permissions

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