Reactor should automatically pick up the owner when the database is abstracted. This, the schema (which is akin to the owner) should automatically be added into the query.
Have you tried defining the object without the schema in your Reactor.xml? Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 24, 2006 11:10 AM To: [email protected] Subject: RE: [Reactor for CF] dot notated table access I modified reactor to accept an owner name per table object in the xml file. As an example: <object name="ADDRESS" alias="ADDRESS" owner="WASTE"> <hasOne name="ZIPCODE"> <relate from="ZIPCODE_ID" to="ID" /> </hasOne> </object> Notice the owner="waste" on the object tag. That specifies which schema since this is oracle. I added that in because I had one project that used 3 different schemas. Sounds like you want more then just to specify the owner though huh? Nate http://blog.advantageitservices.com/ Coldfusion and Reactor Blog -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Chiverton Sent: Thursday, August 24, 2006 7:33 AM To: [email protected] Subject: Re: [Reactor for CF] dot notated table access On Thursday 24 August 2006 15:07, Matt Williams wrote: > > Secondly - there is no way you can make the change in the files Reactor > > places within your project ? > > The only way to make it work with the customizable files would be to > completely override the query (and all queries that had dot-notated > tables), which would pretty much defeat the purpose of Reactor. Ahh right - I thought this was for calling one particular stored proc. -- Tom Chiverton Helping to simultaneously consolidate industry-wide meta-services **************************************************** This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
