Error "Operation must use an updateable query" in ASP Page ?

  • Thread starter Thread starter ontarianlarka
  • Start date Start date
O

ontarianlarka

Guest
I try to Use Insertion Query in Classic ASP. But it result in the above error. I use ADO. Folowing is the Code for that

<%

response.expires=-1


set conn=Server.CreateObject("ADODB.Connection")
conn.Mode=3
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/Ajax/dbo.mdb"


sql="INSERT INTO message (user_name,message) values ('Request.Form(username)','Request.Form(message)')"

on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write(err.description)
else
Response.Write("<h3>" & recaffected & " record added</h3>")
end if
conn.close





%>

The operating System I use is Windows XP.Wait for you people.
 
instead of using this sql="INSERT INTO message (user_name,message) values ('Request.Form(username)','Request.Form(...


use
set rs = Server.CreateObject("ADODB.Recordset")

rs.addnew
rs("user_name") = Request.form("username")
rs("message") = Request.form("message")
rs.update


i have experienced that many times.. the above codes solved my problems.
 
Back
Top