On 2/10/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > I have three tables: Users, NewsUsers (linking table), NewsCategories
> 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. What database engine are you using to run this, MSSQL, MySQL, Access or something else? The reason I ask is simple, some functions work in some engines and not on others. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231952 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
