>Hi All,
>
>I am getting an error with the following code, can any one advice me what is wrong in this code, the error I get on line "rstGuestBook.AddNew"
>the aim of this code is, will add a new record to my GuestBook.mdb File.
>
>this is the code:
>
>Set myConn = Server.CreateObject("ADODB.Connection")
>myConn.Open "2bs-GuestBook"
>mySql = "SELECT * FROM GuestBook"
>Set rstGuestBook = myConn.Execute(mySql)
>
>rstGuestBook.AddNew
>
>rstGuestBook("Nmae") = Request.Form("txtName")
>rstGuestBook("Email") = Request.Form("txtEmail")
>rstGuestBook("Company") = Request.Form("txtCompany")
>rstGuestBook("Url") = Request.Form("txtUrl")
>rstGuestBook("Comment") = Request.Form("txtComment")
>
>rstGuestBook.Update
>
>rstGuestBook.Close
>Set rstGuestBook = Nothing
>
>myConn.Close
>Set myConn = Nothing
>
>Response.Redirect("guest_book_Thanks.html")
>
>
>BR
Where's your connection string ?
On a design point of view:
You should not open a recordset to add a new record. It waste precious ressources for no good reasons.
You should open you Connection and execute an INSERT query or open a Connection, create a Command object and call a store procedure.