[thelist] ASP: object read only?

Casey Crookston casey at thecrookstons.com
Fri Jul 11 15:53:09 CDT 2003


Thank you Tab.

My new code is pasted below as per your suggestion.  I now get the following
error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/boser/manage/content/text_submit.asp, line 16


<!-- #INCLUDE FILE="../adovbs.inc" -->

<%

Dim Connect, Query, text_id, text

text_id = request("text_id")

block = request("block")

Set Connect = Server.CreateObject("ADODB.Connection")

Connect.Open "boser_db"

Query = "UPDATE texts SET block = '"&block&"' WHERE text_id="&text_id

Connect.Execute Query 'This is line 16

Connect.Close

%>



More information about the thelist mailing list