Thanks to all for the answers.
I have a couple of basic questions though... In the FAQs, in the question on the differences of oneToMany and ManyToOne relationships, it says that the objects in both sides of the relation are visible to each other. My problem is that when generating a LIST of objects (Orders) with a ManyToOne relationship (with Users), I cannot access any information on the "ToOne" part of the relationship. i.e. When I get a list of Orders, I cannot access any info of the related User objects... Is this correct? Is this the way it's supposed to work? I guess what I need to do is: in the method called to get the list (dspOrders), use a TQL to retrieve the fields I need using the transfer.ListByQuery method... right? Thanks again for your help, Pedro. On May 29, 3:06 pm, Mark Mandel <[email protected]> wrote: > You have direct access to Transfer from within the Decorator: > > http://docs.transfer-orm.com/wiki/Writing_Decorators.cfm#Access_to_Tr... > > Mark > > > > On Fri, May 29, 2009 at 8:28 PM, pedrobl <[email protected]> wrote: > > > Could you please give me a few samples? How can I use TQL in the model > > classes? I checked the examples in coldbox and transfer, but none > > helped. > > > Thanks, > > > Pedro. > > > On May 28, 7:51 pm, Chris Peterson <[email protected]> wrote: > > > If you added the method in the decorator, but its saying the method does > > not > > > exist, be sure you are reloading / recreating your transfer factory, and > > as > > > a last resort be sure to delete all the auto-generated transfer files. > > > Sounds like its not being re-created, because you are on the right track > > > there with the decorator method. > > > > Chris Peterson > > > > On 5/28/09 1:30 PM, "pedrobl" <[email protected]> wrote: > > > > > This surely has been asked before but, unfortunately I can't find > > > > it... I'm developing an application with coldbox, spring and transfer. > > > > All in their current latest versions. > > > > > The data model is: table of Users, and a table of Orders. A user can > > > > have many orders. So the Orders table has a userId foreign key that > > > > relates it to the Users table. The transfer.xml configuration file is > > > > something like: > > > > > <package name="sp"> > > > > <object name="User" table="users" decorator="model.decorators.User"> > > > > <id name="userId" column="usr_id" type="numeric" generate="false" /> > > > > <property name="Username" type="string" nullable="false" > > > > column="usr_username" /> > > > > </object> > > > > <object name="Order" table="orders" > > > > decorator="nw.model.decorators.Order"> > > > > <id name="OrderId" column="ord_id" type="numeric" generate="false" /> > > > > <property name="Name" type="string" nullable="false" > > > > column="ord_name" /> > > > > <property name="UserId" type="numeric" nullable="false" > > > > column="ord_user_id" /> > > > > <manytoone name="OrdUser"> > > > > <link column="ord_user_id" to="sp.User" /> > > > > </manytoone> > > > > </object> > > > > </package> > > > > > And what I'd like to do is, when I get the list of orders using > > > > getTransfer().list("sp.Order"), I'd like to show the Username of the > > > > user related to each Order. What is the easiest way to accomplish > > > > this, please? > > > > > I've tried creating a getOrdUser method in the Order decorator, and > > > > trying to call it from the view "order.getOrdUser().getUsername()", > > > > but this returns an error stating that the method getOrdUser() doesn't > > > > exist... > > > > > Thanks in advance for your help! > > > > > Pedro. > > -- > E: [email protected] > W:www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
