HELP! Insert Query Error
I receive the following error with my insert query...
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/email_process.asp, line 19
the code in question follows....
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open strConnectionString
Set blogData = Server.CreateObject("ADODB.Recordset")
strSQL = "INSERT INTO list(Email) VALUES('" & Request.Form("email") & "');"
Response.Write strSQL
blogData.Open strSQL, cnn
blogData.Close
%>
Anyone know why i recieve that error?
|
