Re: Reactor For CF Using relational tables

[Dave Shuck]

Please disregard.  I found my answer.  I swear it wasn't in the docs the first time I looked!

On 2/10/06, Dave Shuck < [EMAIL PROTECTED]> wrote:

It is truly embarrassing asking questions this basic on this list, but I am having a difficulty with something I know should be plainly obvious to me.  I have not seen an example of using a relational table and hasMany().  My first guess was that given the following:

User
UserId
UserName
Password

Role
RoleId
RoleDescription

UserRole
UserId
RoleId

That I could do something like the following:
        <object name="User">
      <hasMany name="Role">
        <link name="UserRole" />
      </hasMany>
    </object>

Or maybe:

        <object name="User">
      <hasMany name="Role">
        <link name="UserRole" />
        <relate from="UserId" to="RoleId" />
      </hasMany>
    </object>

It appears my guess was wrong.  I guess link isn't referring to a relation table. :)  Am I missing something obvious here?

Thanks in advance.

--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com

--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com