I Had this problem when I was creating a custom login for a client site (using Active Directory) and assumed it was something I introduced, ie, system thought it was a new account so created a profile.
There should only be one profile for a user so I dont think it is a good idea to check for one or more records (how would you know which was the correct profile record to use). I concidered having code that would blow away all the profile records if there were duplicates and then create a new one. But like I said, I thought I introduced the problem, so did not implement this. But since then I have seen it on another site (b220). Todate I have just gone into the database and delete duplicates manually. On Thu, 13 Jan 2005 11:22:45 +1000, Gary Menzel <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
