I have three tables: Users, NewsUsers (linking table), NewsCategories Users ==== userID (pk) userFirst userLast userEmail userPassword
NewsUsers ======== user_ID (fk) newscat_ID (fk) NewsCategories ============ newscatID (pk) newscatTitle How do I insert a new user in the user table, retrieve the newly created userID and insert it into the newsUsers linking table, and insert the newscatID into the newsUsers linking table as well? All of this will be done with CFC's and I'm not sure If I should have a seperate CFC for users and another for newsletters. Thanks for the Help! Aaron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231949 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
