[daint]

Hello,

I'm getting the same error as a recent post "ADODB.Recordset error '800a0cc1' " but felt I should post my own request rather than hijack theirs.

I can add to the database and view the database through forms on my website, but when it comes to updating, it gives me an error

'Item cannot be found in the collection corresponding to the requested name or ordinal. '

The code in my Update example is

Set RS = oConn.Execute("UPDATE news SET desc='" & request("update_text") & "' Where id=" & id & ";")

the add command that works without error is

Set RS = oConn.Execute("Insert into news values (" & id & ", '" & t_Date & "', '" & request("update_title") & "', '" & request("update_text") & "', 'Yes')")

I have checked and double checked that there is a field called desc, when I update another field in the table it works fine. I had the same problem with another db, but made a new field, copied the data over and all seemed to work ok, but don't want to have to do this for every db I ever do.

The permissions are all set ok, desc is a memo field, but due to length, I'm unable to make it anything else (just in case this may be the problem)

Hope someone can help

Thanks

[koncept]

desc is a sort keyword you need to enclose it in [] to allow it to work

[digioz]

As "koncept" was saying, try using the following SQL String instead:

Set RS = oConn.Execute("UPDATE [news] SET [desc] = '" & request("update_text") & "' Where [id]=" & id & ";")