Is there any way to check if this operation return any error or it's successful?



>Set myConn = Server.CreateObject("ADODB.Connection")
>myConn.ConnectionString = "Your connection string here"
>myConn.Open
>mySql = "Your INSERT here"
>myConn.Execute(mySql)
>myConn.Close
>
>
>
>
>
>>Guy,
>>Thank you for your email....
>>
>>You main that instead of opening the record set, I'll build the INSERT statment with the fields values in "mySql" and EXCUTE it, Correct ?
>>
>>BR
>>
>>
>>>>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.