Hi Kevin, Opps yeah that was a typo.
Ok ok back to the iterator and record I cannot get this one working. I
can see what is going to happen but I cannot get it to work.
Concentrating on the pets shouldn't I be able do:
<cfset reactor = CreateObject("Component",
"reactor.reactorFactory").init(expandPath("/config/reactor.xml")) />
<cfset pet = reactor.createRecord("pets") />
<cfset pet.setpetid(1) />
<cfset pet.load() />
<cfdump var="#pet.getPet_breedRecord()#">
At the moment when I try this I can't call the record.
Here's the pets xml again
<objects name="pets" alias="pets">
<hasOne name="pet_breed">
<relate from="pet_breed_id" to="pet_breed_id" />
</hasOne>
</objects>
At the moment when I try the above I get
The method 'getPet_breedRecord' could not be found in component
/Users/andyjarrett/Sites/www1/petrescue/model/data/Record/petsRecordmysql.cfc.
Check to ensure that the method is defined, and that it is spelled correctly.
My table looks like this
pets
---------------------------------------------------
pet_id varchar(35) PK
pet_name varchar(255)
pet_breed_id int FK to pet_breed.pet_breed_id
pet_breed
---------------------------------------------------
pet_breed_id int PK
animal varchar(255)
breed varchar(255)
Any help appreciated.
Andy
On 26/03/07, Kevin Roche <[EMAIL PROTECTED]> wrote:
Andy,
Shouldn't it be:
<objects name="pet_breed" alias="pet_breed">
<hasMany name="pets">
<relate from="pet_breed_id" to="pet_breed_id" />
</hasMany>
</objects>
so each breed has many pets?
Kevin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Shuck
Sent: 26 March 2007 00:41
To: [email protected]
Subject: Re: [Reactor for CF] Iterator
Andy and iterator is only in play when you have a hasMany relationship. You
can get a handle on your pet_breed with:
<cfset pet = reactor.createRecord("pets").load(petid=1) />
Then see breed like this:
<cfdump var="#pet.getpet_breed()#">
~Dave
On 3/25/07, Andy Jarrett <[EMAIL PROTECTED] > wrote:
> Hi there,
>
> I cannot seem to get the "iterator" functions to work but cannot see
> what I'm doing wrong either. Below is my Reactor File
>
> <objects name="pets" alias="pets">
> <hasOne name="pet_breed">
> <relate from="pet_breed_id" to=pet_breed_id" />
> </hasOne>
> </objects>
>
> <objects name="pet_breed" alias="pet_breed">
> <hasOne name="pets">
> <relate from="pet_breed_id" to="pet_breed_id" />
> </hasOne>
> </objects>
>
> The code
> <cfset reactor = CreateObject("Component",
>
"reactor.reactorFactory").init(expandPath("/config/reactor.xml"))
/>
> <cfset pet = reactor.createRecord("pets") />
> <cfset pet.setpetid(1) />
> <cfset pet.load() />
> <cfdump var="#pet#">
>
> I've set up the foreign keys from the Pets table on the pet_breed_id
> column as well. Doesn't matter what I do there is no Iterator
> available on pet_breed_id.
>
> Any ideas on where I am going wrong?
>
> Cheers, Andy
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
> Reactor for ColdFusion Mailing List
> [email protected]
> Archives at:
http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
>
>
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
Where's your Spot?
www.instantspot.com
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
--
www.andyjarrett.co.uk
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
