[transfer-dev] NOOBE Question...

2008-10-21 Thread Jorge Loyo
This is my second day playing with transfer and I have a small sample app with Mach-II, ColdSpring and transfer working together. I have a few questions though: 1) Unless I plan to have custom DAO or Gateway methods, I no longer need to create these CFCs myself, am I correct? 2) Are decorators

[transfer-dev] Re: Performance Question

2008-10-27 Thread Jorge Loyo
in development beat the crap out of anything I could do anyway. J On Oct 27, 2008, at 11:47 AM, Jorge Loyo wrote: What is the difference in performance between having my own DAOs, Gateways (with joins) and Beans and having transfer handle that part of my application?? Has anyone done any

[transfer-dev] [NOT] IN Statement

2008-11-10 Thread Jorge Loyo
Is there a method in transfer to get a query from IN or NOT IN? Something like: listByPropertyMapList(product.product, params) where params is a structure that contains a list of values for a column... name=test1,test2?? --~--~-~--~~~---~--~~ Before posting

[transfer-dev] Re: [NOT] IN Statement

2008-11-10 Thread Jorge Loyo
Chris, Thank you. you can do listByQuery( TQL ) and pass in a TQL statement object I guess I was trying to see if there was a way to have transfer handle all basic/common query transactions (Like, In, Not In, etc.) without having to resort to creating additional code or perhaps additional

[transfer-dev] Re: Unless there is custom SQL/TQL, should a DAO/Gateway CFC be created?

2008-11-11 Thread Jorge Loyo
(most cases) I am assuming this would drastically increase the application load time as well.. Is my assumption correct? So thank you again, and yeah... the transition is slow, but I know in the long run it'll payoff. -- Jorge Loyo --~--~-~--~~~---~--~~ Before

[transfer-dev] transfer.Update error

2009-01-19 Thread Jorge Loyo
I am trying to use the Transfer.update() method to update the isLoggedIn column of a user record, but one of the columns is an auto number and cannot be updated... Is there a way to go about this?? Thank you. --~--~-~--~~~---~--~~ Before posting questions to the

[transfer-dev] Re: transfer.Update error

2009-01-19 Thread Jorge Loyo
Awesome, thank you sir... I added the following: refresh-insert=true ignore-insert=true ignore-update=true On Jan 19, 4:45 pm, Mark Mandel mark.man...@gmail.com wrote: You can also do a refresh-update=true as well. Mark On Tue, Jan 20, 2009 at 8:37 AM, Matt Quackenbush

[transfer-dev] [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '.'

2009-01-20 Thread Jorge Loyo
I got version 1.1 This is the SQL generated: select user.userId, user.first_name, user.last_name, user.email, user.password, user.dt_last_login, user.ip_last_login, user.is_logged_in, user.is_active, user.user_id FROM _tbl_user user WHERE user.user_id IS NOT NULL The error trace includes the

[transfer-dev] HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Jorge Loyo
I have a situation... Any assistance will be greatly appreciated. These are my tables: 1) tblAward(awardId,award) 2) tblActor(actorId,name) 3) tblDirector(directorId,name) 4) tblEntityAward(fk_award,fk_parent,year_awarded) In #4, the fk_parent is the primary key in either tblActor or

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Jorge Loyo
Would this make sense?? package name=award object name=award table=tblAward id name=awardId type=numeric / property name=award type=string column=award / /object object name=PerformerAward table=tblEntityAward compositeid manytoone name=Award /

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Jorge Loyo
Thank you Sean, I noticed that you didn't declare the association table, even when there is a composite key. And you use the year_awarded to order by array by. How do you display the year_awarded? Is it included in the collection? --~--~-~--~~~---~--~~ Before

[transfer-dev] Re: Can transfer return a query with joined columns

2009-01-27 Thread Jorge Loyo
Again Thank you Brian... Can't get clearer than that :) --~--~-~--~~~---~--~~ 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

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-28 Thread Jorge Loyo
so you could create an EntityAward object and have Actor and Director each have a onetomany relationship to it. Then in EntityAward have a manytoone relation to Award. Awesome, Thank you. --~--~-~--~~~---~--~~ Before posting questions to the group please

[transfer-dev] Element QOBJECT.TRANSFER_COMPOSITEID is undefined in ARGUMENTS

2009-02-03 Thread Jorge Loyo
I get the error: Element QOBJECT.TRANSFER_COMPOSITEID is undefined in ARGUMENTS everytime I try to do a simple getProduct() :::My Transfer.xml::: package name=product object name=product table=_tbl_product id name=product_id type=numeric / property name=name type=string