ADODB.Recordset (0x800A0CB3)
i cannot store anything to my database, what am i doing wrong, please help
my code:
<%@ LANGUAGE="VBSCRIPT" %>
<html>
<head><title>Confirmation </title></head>
<body bgcolor ="black">
<%
set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("members.mdb") & " ; "
set rs=db.execute("SELECT * FROM tblmembers")
rs.AddNew
rs.Fields("Name")= "sebastians"
rs.UpdateBatch
rs.MoveFirst
Response.Write rs("Name")
%>
</body>
</html>
