I have done something very similar, and did it "at the form level", as
suggested by Barry:
1. Looped over existing user fields rather than formfields (as my form
fields typically have things like "btnUpdate", and unchecked checkboxes
disappear unless you add them in manually, etc)
2. Only emailed enough information to identify the record in question,
and then any changes, rather than the entire record
HTH
Aaron
Barry Beattie wrote:
trap it at the form level?
for each field in form
if (user_existing[field] NEQ form[field])
// different so add to the email
end if
next field
just a thought...
On 5/23/06, Mike Kear <[EMAIL PROTECTED]> 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
[email protected] 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/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] 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/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] 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/[email protected]
