Hello, This is my first foray into the world of Reactor. I've been using it for about a month, and all has mostly been well, but I've come to the point where I need to implement a basic link table relationship like so (first the SQL 2000 table schema descriptions and then the reactor.xml excerpts):
tblUser ____ intItemID nvcFirstName nvcLastName ... more fields... tblRole ------ intRoleID nvcRoleTitle nvcRoleDescription ... more fields ... tblUserRole ------ intUserRoleID (my PK for the link table) intUserItemID (my FK back to tblUser.intItemID) intRoleID (my FK back to tblRole.intRoleID) There is a fourth table, tblItems, which accounts for the ropey naming conventions here, and it's just something my company uses that I can't get around (essentially a User is an Item, as are a lot of things, so tblUser.intItemID FK's back to tblItems.intItemID rather than having an auto-incrementing PK of its own). -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
