[transfer-dev] Re: cache enhancement

2009-06-02 Thread aurel
Ah... I didn't know this ticket tracking... thanks ;-) On 28 mai, 01:09, Mark Mandel mark.man...@gmail.com wrote: Already a ticket ;o)http://tracker.transfer-orm.com/issue.cfm?p=89977683-A728-9CD3-ABD954... Mark On Thu, May 28, 2009 at 2:18 AM, aurel adeleusi...@gmail.com wrote: Maybe

[transfer-dev] list by property

2009-06-02 Thread spiraldev
I am building a ColdBox/Transfer Application and I was wondering if there was a way to add a sub query into the select statement in the listByProperty method? I have already built a method in one of my services that contains the select statement with the sub query but I thought it would be nice

[transfer-dev] Re: list by property

2009-06-02 Thread Mark Mandel
Why not use TQL? Mark On Wed, Jun 3, 2009 at 7:43 AM, spiraldev spiral...@gmail.com wrote: I am building a ColdBox/Transfer Application and I was wondering if there was a way to add a sub query into the select statement in the listByProperty method? I have already built a method in one of

[transfer-dev] Update multiple records

2009-06-02 Thread stephend
Hi, Been using for transfer for awhile now but this is the first time I have had to update a group of records in a table. This is easy in straight SQL but how do you do it with transfer. eg. Update tableName set defaultRec = Y where user = x Thanks.

[transfer-dev] Re: Update multiple records

2009-06-02 Thread Bob Silverberg
You cannot do that with Transfer, not in the way you suggest anyway. Transfer works with objects, not table rows, so you'd have to ask Transfer to get each object, update its property and then ask Transfer to save the object. You could use one of the listXXX methods to get a query that contains

[transfer-dev] Re: Update multiple records

2009-06-02 Thread stephend
Hi Bob, Thanks for the reply, as it is a small list of records I have taken the route you suggested using listByQuery() and it works fine. Cheers Stephen On Jun 3, 10:27 am, Bob Silverberg bob.silverb...@gmail.com wrote: You cannot do that with Transfer, not in the way you suggest anyway.