Hi all, i have a web form that collects student related data and there are about 30 text, check and drop down boxes all together in it . i want to keep a log on who has updated what. is there an easy way of doing this? i dont want to go through each web form element and compare its value with the persisted one.

thanks in advance -shane

I'm not sure I understand exactly what you are trying to track...? Do you just mean you need to detect which fields have changed, or that you want to record in the database who made changes to particular records/fields...?

If you could expand a bit more we may be able to offer some more assistance.

Matt

MTrinder wrote:

I'm not sure I understand exactly what you are trying to track...? Do you just mean you need to detect which fields have changed, or that you want to record in the database who made changes to particular records/fields...?

If you could expand a bit more we may be able to offer some more assistance.

Matt

Hi, i want to audit the changes. i have an audit table that keeps the userid, dateofchange, and changedetails. Say the secretary has updated students last name from Flock to Flick. in my audit table i want her id in userid field, date time for the update and in details: Mrs. xyz changed last name from Flock to Flick.

i dont want to go through the entire form and compare students firstname, lastname, birthdate etc with whatever resides in db to create my change details.

could there be an easy way to accomplish this? hope its clear this time. thanks

-shane

Much clearer, thanks. LLBLGen has built in support for Auditing as you describe - have a look at the documentation at http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_auditing.htm

Let us know if you have any more specific questions.

Matt