[Reactor for CF] digging deeper into tables... possibly a config issue?

[Doug Arthur]

Hi, I'm having trouble digging down into my tables from reactor.

 

Here's my table model in it's proper hierarchy:

detail

detail_id - PK

 

charge

chage_id - PK

detail_id

 

sentence

sentence_id - PK

charge_id

 

disposition

disposition_id - PK

charge_id

 

There can be many charges to a single detail record. There can be many sentences to a single charge record. There can be many dispositions to a single charge record. The sentence/disposition tables do not relate up to detail, but rather through charge table they do.

 

Now, my problem is that I can do createRecord('detail').getchargeiterator(), but how do i go further and get sentenceiterator()??????

 

Here's my config of the objects

 

  <object name="detail">
   <hasMany name="charge">
    <relate from="detail_id" to="detail_id" />
   </hasMany>
  </object>
  
  <object name="charge">
   <hasMany name="disposition">
    <relate from="charge_id" to="charge_id" />
   </hasMany>
   <hasMany name="sentence">
    <relate from="charge_id" to="charge_id" />
   </hasMany>
   <hasOne name="detail">
    <relate from="detail_id" to="detail_id" />
   </hasOne>
  </object>
  
  <object name="disposition">
   <hasOne name="charge">
    <relate from="charge_id" to="charge_id" />
   </hasOne>
  </object>
  
  <object name="sentence">
   <hasOne name="charge">
    <relate from="charge_id" to="charge_id" />
   </hasOne>
  </object>
 

 

Thanks!

- Doug

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --