Microsoft Cursor Engine error '80040e21'

[jn03]

Hi,

I got this error from an ASP page when trying to update a recordset
(here is how I opened it:

rs.Open cmd, , adOpenDynamic, adLockBatchOptimistic)

-----ERROR -----------
Microsoft Cursor Engine error '80040e21'

Multiple-step operation generated errors. Check each status value.

----------------

Here is the asp code:

rsDirUpdate.MoveFirst
rsDirUpdate.Fields.Item("telephone_type").Value = "" <-- ERROR RIGHT HERE

If I comment out this line, it works fine. In my database table the "telephone_type" is varchar(10).

Please help. Thanks.

 

[jn03]

Never mind, I found out what was wrong. It was the select statement, it didn't like the alias. I removed the alias and it works. Thanks for reading.
"select (bla...) as telephone_type