Creating audit functionality using ASP

[jmartmem]

Greetings,

I'm looking for suggestions about creating audit functionality for ASP pages.

The ASP page I want to audit is an Update Record Form, which contains a number of fields, such as text boxes and menus. Ideally, I want to know how to create an audit tool that tracks and records the changes of any form fields with their old and new values using an ASP web page

Whatever advice or tutorials you have or can direct me to would be greatly appreciated.

Regards,

- JM

[jeffstl]

Greetings,

I'm looking for suggestions about creating audit functionality for ASP pages.

The ASP page I want to audit is an Update Record Form, which contains a number of fields, such as text boxes and menus. Ideally, I want to know how to create an audit tool that tracks and records the changes of any form fields with their old and new values using an ASP web page

Whatever advice or tutorials you have or can direct me to would be greatly appreciated.

Regards,

- JM

From the way you worded this question I am assuming you are talking about tracking the actual data entered into these fields for a particular record.

If that is the case you need to have your database be modeled to store historical records.

This means you would need to have a flag column in your database that marks a record as "historical ". Then whenever a record is updated using this form you mentioned, you would have to first update the old record marking it historical, then insert a new record.

This can lead to complications and other various changes in your system depending on how many tables this form is related to. You may also want a "Last User Updated" field and Last Date Updated field in your database to log the user who made the changes if you don't have one already.

I can help if needed but the main starting point will be to create a new column in your database for flagging records as historical ones. Also if I read your question right.

[jhardman]

I can help if needed but the main starting point will be to create a new column in your database for flagging records as historical ones. Also if I read your question right.

...or a column that lists version number, always assuming the highest number is the most recent.

Jared