New to asp and databases any help is greatly apreciated!
Im having problems adding records to my database.
Am i way off? can you edit the code quick. Any good simple tutorials for adding records to a sql database
heres a link to my form.asp and confirm.asp
http://flexo.wisc-online.com/form.asp
http://flexo.wisc-online.com/confirm.asp

[code language="asp"]
  <%
DIM objRS, objConn
objConn = "Driver={SQL Server}; server=myserver;Database=mydatabase; UID=myid; PWD=mypw"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "tbltest", objConn
objRS.AddNew
objRS("Email") = Request.Form("Email")
objRS("FirstName") = Request.Form("FirstName")
objRS("LastName") = Request.Form("LastName")
objRS("Comments") = Request.Form("Comments")
objRS("DateContacted") = Date()
objRS.Update
%>
<p>
<%
DIM strFirstName
strFirstName = Request.Form("FirstName")
%>,<br>
</p>
<%
objRS.Close
Set objRS = Nothing
objCONN.Close
Set objCONN = Nothing
%>
[/code]

sorry, this forum is for asp.net not classic asp.