I am having a problem with the following code with mySQL. I normally write
with Access and do not get this problem, is there something that I am doing
wrong?

The error is as follows -

ADODB.Recordset.1 error '80004005'
Recordset is read-only

I am trying to update one field using the following code -


<%
Dim rsOutOrders
Dim rsOutOrders_numRows

Set rsOutOrders = Server.CreateObject("ADODB.Recordset")
rsOutOrders.ActiveConnection = MM_cStringname_STRING
rsOutOrders.Source = "SELECT * FROM orderdetails WHERE complete = '" +
Replace(rsOutOrders__MMColParam, "'", "''") + "' ORDER BY dateordered ASC"
rsOutOrders.CursorType = 0
rsOutOrders.CursorLocation = 2
rsOutOrders.LockType = 2
rsOutOrders.Open()

rsOutOrders_numRows = 0
%>

<%
rsOutOrders("complete") = "Yes"
rsOutOrders.Update
%>

Any help would be welcomed!
Thanks in advance...