Mark, I am using the user's email address as their username, and am going to use the email/password combo for authentication. While one person may have multiple email address, no two people have the exact same email address.
If a user would like to create multiple accounts with multiple email addresses, that is there prerogative (a valid occasion of this happening is when a user opens an account for their business and another account for their personal affairs). -Aaron On 2/6/06, Mark Fuqua <[EMAIL PROTECTED]> wrote: > Just for thought...lots of people (including me) have multiple email > addresses and use them interchangeably. > > Maybe if the email address was also the user name that would reduce the > chance of people using multiple email addresses? > > -----Original Message----- > From: Aaron Roberson [mailto:[EMAIL PROTECTED] > Sent: Monday, February 06, 2006 7:36 PM > To: CF-Talk > Subject: Need Help Extending Components > > > Friends, > > I am creating a newsletter enrollment form on our company website and > would like to be able to create a new user for each newsletter > subscriber. To do this, I am trying to use the insert query from my > insertUser method within my user component to insert newsletter > subscribers into the user table. > > The user CFC contains an insertUser method that inserts basic > information such as First and Last names, email addresses and password > into one table, billing info into another table, shipping into > another, and extra forum related info into yet another table. > > The newsletter CFC will contain a method that will check for the > existance of a user in the USERS table by evaluating the email > address, insert a new user into the USERS table if a record does not > already exists, and insert the userID and newsletter ID into a linking > table that will join the USERS table and a NEWSLETTER table > (containing a list of seperate newsletters). > > MY AIM > Overall, there will be three ways a site visitor can create an > account; newsletter subscribers, forum users, and shopping cart > accounts. Instead of creating a new profile for each of these > purposes, I would like each visitor to have access to all three of > these features through one user account. That way, if a visitor > subscribes to our newsletters, and later want to create a shopping > cart account, they can update their existing profile with their > shipping and billing information. If they wanted to become a forum > poster, they could update their profile with their Yahoo! (or MSN or > Google, etc) Messenger account, Avatar, etc. etc. That would make it > so that their entire profile could be managed in a single account. > > Thanks in advance for your suggestions, > Aaron > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231538 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
