Re: [CFCDev] How to detect changes at commit time?

[Nando]

I've done something similar with a "memento". Essentially you take a snapshot of your user bean - a structure of all instance variables at "instantiationComplete" - and then compare that to a memento at  "validationComplete". You'd just have to loop through the keys of one structure and compare it key by key to the other. If you've placed your instance variable in a structure of their own, for instance variables.instance.firstName, then you're all set to go. If you haven't, you may want to consider doing that so the memento is easy to capture. I hope that makes sense ... Mike Kear wrote: I have a user profile module that I'm working on, that has a LOT of fields in various tables - memberdetails, addresses, positions, educationlevels, specialinterestgroups, etc etc and I want the members to be able to maintain their own member profile on line.  I have beans and DAO cfcs to handle all the parameters.  So far so good.    But the administration office hasn't yet changed their system to use the online database for membership records, so I need to send them an email advising them that a member has changed their profile.   They can manually change their records to keep them in synch with the online records.   But if i sent an email saying "member X changed his profile and here's the new record ...."  they'll get a long page of data and have to wade through field by field looking for what's changed.   What would be far better if i can tell them what's changed.    There's my problem.  How to identify the fields that have changed?   Here's how i thought I'd do it, but is there an easier way?   I thought I'd create two identical user beans - User.cfc and user_existing.cfc,  collect the new values from the online form in user.cfc     then at the time of preparing the email,  go through all the fields comparing the two values, and put anything that doesnt match in red bold or something, using something like this:   <cfif user.getname() NEQ user_existing.getname()><span.style="color:red;font-weight:700;">#user.getname()#</span><cfelse>#user.getname()#</cfif>   but that looks like an AWFUL lot of code for a hundred fields or so.    Is there an easier way to do it? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org -- Aria Media Sagl CP 234 6934 Bioggio Switzerland www.aria-media.com