This topic is locked

MYSQL TIMESTAMP

8/10/2006 6:11:07 PM
ASPRunnerPro General questions
K
KingDean author

every table that i have in my database has a strange error.
I can insert records into the table without any error.
i can update a record without any error.
when i click Edit, and then Save - no changes - i get the following

              • -
                Microsoft Cursor Engine error '80040e38'
                Row cannot be located for updating. Some values may have been changed since it was last read.
                /Contacts/issues_edit.asp, line 723












                • -
                  this corresponds to the following line in issues_edit
                  end if
                  rs.Update
                  LINE 723 - - - - - - - - message="<div class=message><<< " & "Record updated" & " >>></div>"

                  ' AfterEdit Event

                  DoEvent "Call AfterEdit()"

                  else

                  rs.CancelUpdate

                  end if
                  THE LINE 723 IS MARKED.
                  I think that i can get around this by having a timestamp field that everytime a record is opened for edit that a time field is updated
                  i can't make that work though. HELP I NEED THIS BAD.















J
Jane 8/11/2006

Hi,
please show me your connection string.

You can post it here or send to [email=support@xlinesoft.com]support@xlinesoft.com[/email].

Connection string is in the include/dbconnection.asp file.