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:231533 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
