Hi,
I'm using 2 tables, the first one is called 'status' en the second is called 'history'. When you edit (for example) row 6 on the status list then a few values from row 6 have to be copied to the history table. The idea behind this is that you can keep track of the changes which have happened to row 6.
I've followed the ideas after reading this topic (making an audit log) http://www.asprunner.com/forums/index.php?showtopic=2292
A way of fixing my problem is by adding a 'timechange' field to the 'status' table. When you edit a page then the current datetime is added into that field. After that you can use the 'add records into another table' (table event). In there you make a query so it selects the row with the latest timechange value. (using an 'order by date dec, limit 1' value. The selected values from the result row then can be copied to the history table according to the information describben in the audit topic.
The problem is that I can't get the 'when edit a page, input the current datetime value' to work. It works when adding a page (using the now() function) but I can't seem to get it to work with the edit page. I'm also wondering if there's an easier solution to my problem.
Meanwhile, keep up the good work! I can't wait for the final version of v3 <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2472&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
