We have previously used the dmUser object to import people from our
old system into FarCry.

We do allow users to change their EMAIL address (stored in dmProfile)
from our site - but simply locate the record with our own code and
perform an UPDATE statement on it (if it doesnt exist - bad luck).

HOWEVER......

A recent incident cause us to view the data in the dmProfile table and
we have found there are MANY duplicate dmProfile records in there -
but not for all clients.

There is code in the dmProfile object that checks to see if an entry
exists and if so sets a flag - otherwise creates one.

Now - for whatever reason this may have happened the code checks for
there to be EXACTLY one dmProfile record.  If (again - dunno how this
may have happened) there is MORE than one record - then the code just
keeps creating more.

The offending problem is in the getProfile.cfm under the dmProfile
object at line 32 (under version 2.0).

It checks for a RecordCount EQ 1.

If just should check for RecordCount (otherwise the ELSE will always
force a new one to be created).  If could also be RecordCount GE 1.

As I said - I dont know how the additional record may have been
created in the first place (this is something I have to track down
separately) but at least this change will ensure there aren't many
created.

Regards,
Gary

---
You are currently subscribed to farcry-dev as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to