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.