Update failure...

[adamsoderqvist]

Hi everyone...

I've posted this before and got help, and at the time it seemed to work. But now the problem has reserected...

I get this error msg:

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found."

THE ROW IS THERE!

and the code is simple asp coding (which works properly with other records in the DB:

objRS("Data&quot = strData
objRS.Update.


what to do?

 

[FesterSXS]

is 'Data' a reserved fieldname perhaps?? I have had problems before when I tried using field names like 'Date' or 'Group'

However, I seem to remember that the error in those cases was a syntax error, not a 'row not found' error.

Just a thought

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[adamsoderqvist]

OK, thanx, but code example was just an example - not the actual code. And as I said, it works fine with the other posts in the database (I'm workin on a forum). It's just some of the posts that just wont work... any ideas?

 

[FesterSXS]

maybe there are invalid character being submitted in these posts? Try filtering out illegal characters before populating the database.
Tony

http://www.phoenix-paints.co.uk/portfolio

 

[adamsoderqvist]

thanx, again, but no. again.

the characters are normal numbers and letters.

Looks as I'm stranded...?