Not beta, alpha J
I’d be happy to help, but that takes
time. (And right now time costs me a lot of money.) So, I’ve not been
replying and hoping others chip in. Sorry!
Doug
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Kotek
Sent: Friday, April 14, 2006 11:50
AM
To: [email protected]
Subject: Re: [Reactor For CF]
Reactor Config File
If it's causing you this
much of a problem you may want to hold off on using Reactor for this project.
It is still a piece of beta software and everyone here working on it or
participating in the forums also has other responsibilities. It's one thing to ask
a relatively straighforward question, it's quite another to post dozens of
lines of XML and an ER diagram and ask what's wrong. For what its worth, I've
used Reactor with the alias and haven't had any problems.
One thing that may help would be if you could post the most simple example you
can create that demonstrates the problem.
Regards,
Brian
On 4/14/06, Brian
Billings <[EMAIL PROTECTED]>
wrote:
All,
Questions on my questions. Are we asking the wrong question or not
providing enough info?
We have been having the issue for over a month and posted 6 or 7
different posts and for what ever reason cannot get any help with it.
For ahile we could just not use the alias but we are to the point that
we have to have them to go forward and this issue with Reactor is hold
us back.
Is there something more we can do to get help with this?
On 4/10/06, Brian Billings <[EMAIL PROTECTED]>
wrote:
> Simeon and all,
> When I changed the XLM to what you provided and i'm getting this error
> when I run the code below:
>
> <cfset local.gateway =
variables.reactor.createGateway("ROLES") />
>
> First Attempt:
> <cfset local.query =
> local.gateway.createQuery
().join('ROLES','EVENT_ROLE','ER_').join('EVENT_ROLE','EVENTS','E_')
> />
>
> I also tried this and got a similar message:
> <cfset local.query =
local.gateway.createQuery().join('ROLES','EVENTS','E_') />
>
> Message Relationship Does Not Exist
> Detail The object 'EVENT_ROLE' does have have a relationship with an
> alias of 'EVENTS'.
> Extended Info
> Tag Context F:\MARC\Reactor\base\abstractMetadata.cfc (167)
>
>
> Here is what is in my file.
>
> <object name="EVENTS">
> <hasmany name="ROLES">
>
> <link
name="EVENT_ROLE" />
> </hasmany>
> </object>
>
> <object name="ROLES">
> <hasmany name="EVENTS">
>
> <link
name="EVENT_ROLE" />
> </hasmany>
> </object>
> <object name="EVENT_ROLE">
> <hasone name="EVENTS">
> <relate
from="EVENT_SK" to="EVENT_SK" />
> </hasone>
> <hasone name="ROLES">
>
> <relate
from="ROLE_SK" to="ROLE_SK" />
> </hasone>
> </object>
>
>
> Thanks for your help.
>
> On 4/10/06, Simeon Bateman <[EMAIL PROTECTED]>
wrote:
> >
> > Ignore that code in the other post. Gmail sent too early
:)
> >
> > Here is what I think that config would look like:
> >
> > <object name="EVENTS">
> > <hasmany name="ROLES">
> >
> > <link
name="EVENT_ROLE" />
> > </hasmany>
> > </object>
> >
> > <object name="ROLES">
> > <hasmany name="EVENTS">
> >
> > <link
name="EVENT_ROLE" />
> > </hasmany>
> > </object>
> > <object name="EVENT_ROLE">
> > <hasone name="EVENTS">
> > <relate
from="EVENT_SK" to="EVENT_SK" />
> > </hasone>
> > <hasone name="ROLES">
> >
> > <relate
from="ROLE_SK" to="ROLE_SK" />
> > </hasone>
> > </object>
> >
> >
> > Let me know if that makes sense. EVENTS haveMany ROLES;
ROLES haveMany EVENTS; and the to are linked by the EVENT_ROLE object.
> >
> > sim
> >
> >
> >
> > On 4/9/06, Simeon Bateman <[EMAIL PROTECTED]>
wrote:
> > >
> > > Looking at this closer here is what I would expect to
see. It appears that the EVENTS object need to have a
"hasMany" relations ship with ROLES. and then you would
link those via teh Event_ROLE table. I would expect the confif for
that to look like this.
> > >
> > >
> > > <object name="EVENTS">
> > >
> >
>
<hasmany name="EVENT_ROLE">
> > >
> >
>
<link name="EVENT_ROLE" />
> > >
> >
>
</hasmany>
> > >
> > > </object>
> > >
> > >
> > > <object name="ROLE">
> > >
> > > <hasMany name="EVENTS">
> > >
> > >
> > >
> > >
> > >
> > >
> > > </object>
> > >
> > >
> > >
<object name="EVENT_ROLE">
> > >
> >
>
<hasone name="EVENTS">
> > >
> >
>
<relate from="EVENT_SK" to="EVENT_SK" />
> > >
> >
>
</hasone>
> > >
> >
>
<hasone name="ROLES">
> > >
> >
>
<link name="ROLES" />
> > >
> >
>
</hasone>
> > >
> >
>
</object>
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 4/8/06, Brian Billings < [EMAIL PROTECTED]> wrote:
> > > >
> > > >
> > > >
> > > >
> > > > Yesterday I submitted a post about the problem I am having
with the alias in the reactor config file (which is still unresolved) and I
believe it was Simeon that brought up a possible issue with the way I am
linking objects in the cofig file.
> > > >
> > > >
> > > >
> > > > I have had a very hard time wrapping my head around how the
config file works and I honestly still don't understand it completely. My code
runs with all of the intricate joins so I don't think it is totally wrong.
> > > >
> > > >
> > > >
> > > > I have attached a gif of my database tables and the Reactor
file. I don't have all of the objects mapped yet (im basically mapping the
relationships as I need them).
> > > >
> > > >
> > > >
> > > > Before I go forward I would like to be sure that am I doing
this right? Like I mentioned, it works.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Summary of what I am doing:
> > > >
> > > > -Roles are defined (ROLES)
> > > >
> > > > -Applications are defined (APPLICATIONS)
> > > >
> > > > -Applications have events (APPLICATION_EVENT)
> > > >
> > > > -Events are assigned roles (EVENT_ROLE)
> > > >
> > > > -User are assigned roles via direct mapping (USER_ROLE) or
via group (GROUPS, GROUP_ROLE & GROUP_USER)
> > > >
> > > > -User must have one or more roles assigned to the event to
see the event
> > > >
> > > >
> > > >
> > > > <reactor>
> > > >
> > > > <config>
> > > >
> > >
>
<project value="MARC" />
> > > >
> > >
>
<dsn value="MARC" />
> > > >
> > >
>
<type value="mssql" />
> > > >
> > >
>
<mapping value="/core/model/Reactor" />
> > > >
> > >
>
<mode value="always" />
> > > >
> > > > </config>
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > <objects>
> > > >
> > > >
> > > >
> > > > <object
name="EVENTS">
> > > >
> > >
>
<hasmany name="EVENT_ROLE">
> > > >
> > >
>
<link name="EVENT_ROLE" />
> > > >
> > >
>
</hasmany>
> > > >
> > > > </object>
> > > >
> > > >
> > > >
> > > >
<object name="EVENT_ROLE">
> > > >
> > >
>
<hasone name="EVENTS">
> > > >
> > >
>
<relate from="EVENT_SK" to="EVENT_SK" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
<hasone name="ROLES">
> > > >
> > >
>
<link name="ROLES" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
>
<object name="GROUP_ROLE">
> > > >
> > >
>
<hasone name="GROUPS">
> > > >
> > >
>
<relate from="GROUP_SK" to="GROUP_SK" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
<hasone name="ROLES">
> > > >
> > >
>
<link name="ROLES" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > >
>
<object name="GROUPS">
> > > >
> > >
>
<hasmany name="GROUP_ROLE">
> > > >
> > >
>
<link name="GROUP_ROLE" />
> > > >
> > >
>
</hasmany>
> > > >
> > > >
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > >
>
<object name="USER_ROLE">
> > > >
> > >
>
<hasone name="USERS">
> > > >
> > >
>
<relate from="USER_SK" to="USER_SK" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
<hasone name="ROLES">
> > > >
> > >
>
<relate from="ROLE_SK" to="ROLE_SK" />
> > > >
> > >
>
</hasone>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > >
>
<object name="ROLES">
> > > >
> > >
>
<hasMany name="GROUP_ROLE">
> > > >
> > >
>
<relate from="ROLE_SK" to="ROLE_SK" />
> > > >
> > >
>
</hasMany>
> > > >
> > >
>
<hasMany name="EVENT_ROLE">
> > > >
> > >
>
<relate from="ROLE_SK" to="ROLE_SK" />
> > > >
> > >
>
</hasMany>
> > > >
> > >
>
<hasMany name="USER_ROLE">
> > > >
> > >
>
<relate from="ROLE_SK" to="ROLE_SK" />
> > > >
> > >
>
</hasMany>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > >
>
<object name="USERS">
> > > >
> > >
>
<hasMany name="USER_ROLE">
> > > >
> > >
>
<relate from="USER_SK" to="USER_SK" />
> > > >
> > >
>
</hasMany>
> > > >
> > >
>
<hasMany name="GROUP_USER">
> > > >
> > >
>
<relate from="USER_SK" to="USER_SK" />
> > > >
> > >
>
</hasMany>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > >
>
<object name="GROUP_USER">
> > > >
> > >
>
<hasOne name="GROUPS">
> > > >
> > >
>
<relate from="GROUP_SK" to="GROUP_SK" />
> > > >
> > >
>
</hasOne>
> > > >
> > >
>
</object>
> > > >
> > > >
> > > >
> > > > </objects>
> > > >
> > > > </reactor>
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- 
