<cfset role = Reactor.createRecord('SECMAIN_SECROLE') />
<cfset role.setRoleID('0012345') />
<cfset role.load() />
<cfset emps = role.getSecmainIterator().getQuery() />
<cfdump var="#emps#">
also, are you sure all of the primary keys are set up correctly, etc?
On 5/12/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
doesn't seem to get it. This returns one record when I know there are
mulitple in the DB.
> <cfset role = Reactor.createRecord('SECROLES') />
> <cfset role.setsecRole_ID('1') />
> <cfset role.load() />
> <cfset emps = role.getSecmainIterator().getQuery() />
> <cfdump var="#emps#">
I thought this should return all records in secmain with
secrole.secrole_id = 1. Looking at the generated SQL I found that
reactors SQL is joining on emplid, not secrole_id.
"RRTPP"."SECMAIN" "SECMAIN"
INNER JOIN "RRTPP"."SECMAIN_SECROLE" "SECMAIN_SECROLE"
ON "SECMAIN"."EMPLID" = "SECMAIN_SECROLE"."EMPLID"
How to get the join on secrole.secrole_id instead?
DK
On 5/11/06, Brian Kotek <[EMAIL PROTECTED]> wrote:
> You should be able to go through using the reverse relationship, something
> like this:
>
> <cfset role = Reactor.createRecord('SECROLES') />
> <cfset role.setRoleID('0012345') />
> <cfset role.load() />
> <cfset emps = role.getSecmainIterator ().getQuery() />
> <cfdump var="#emps#">
>
> Not sure about the saving though.
>
>
> On 5/11/06, Douglas Knudsen <[EMAIL PROTECTED] > wrote:
> >
> any advice? Or URL to some?
>
> thanks!
> DK
>
> On 5/9/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> > ok, I'm trying to work with three tables using Reactor and the link
> > configuration. I'm looking over the sample Scratch app and its just
> > not sinking in. (There is a getProductQuery() call in there that I
> > just can't find when I try this at home)
> >
> > Say the tables are
> >
> > SECMAIN:
> > emplid VARCHAR PK
> > isactive NUMBER (using Oracle, no bool, so 1/0 here)
> >
> > SECROLE:
> > secrole_id NUMBER PK
> > role VARCHAR
> >
> > SECMAIN_SECROLE: a relation table
> > emplid VARCHAR
> > secrole_id NUMBER
> >
> > I know there are other ways to do this, but this is similar to the
> > product/invoice examples that I'm readin over.
> >
> > Now my reactor.xml has
> >
> > <objects>
> > <object name="SECMAIN">
> > <hasMany name="SECROLE">
> > <link
> name="SECMAIN_SECROLE" />
> > </hasMany>
> >
> > </object>
> >
> > <object name="SECROLE">
> > <hasMany name="SECMAIN" >
> > <link
> name="SECMAIN_SECROLE" />
> > </hasMany>
> > </object>
> >
> > <object name="SECMAIN_SECROLE">
> > <hasOne name="SECMAIN">
> > <relate from="emplid"
> to="emplid"/>
> > </hasOne>
> > <hasOne name="SECROLE">
> > <relate from="secrole_id"
> to="secrole_id"/>
> > </hasOne>
> > </object>
> >
> > </objects>
> >
> >
> > Now, this looks right, is it?
> >
> > I can get all roles for an emplid
> > <cfset sec = Reactor.createRecord ('SECMAIN') />
> > <cfset sec.setEmplid('0012345') />
> > <cfset sec.load() />
> > <cfset roles = sec.getSecroleIterator().getQuery() />
> > <cfdump var="#roles#">
> >
> > kewl.
> >
> > now, how to get all employees in a secrole?
> > How to go about adding a new 'entry' which involves inserts into two
> > tables? Do I have to perform a .save() on both the secmain object and
> > the secmain_secrole objects? I don't see something like
> > secmainobject.setSecRoleRecord().
> >
> >
> >
> > --
> > Douglas Knudsen
> > http://www.cubicleman.com
> > this is my signature, like it?
> >
>
>
> --
> Douglas Knudsen
> http://www.cubicleman.com
> this is my signature, like it?
>
>
>
> -- 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/
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-- 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/
