[transfer-dev] Re: Insert when update expected

2008-11-22 Thread Matt Quackenbush
I think you're misunderstanding how Transfer works. The snippet you've posted shows that the first thing you're doing is asking your Service for a bean with an ID of 0. I don't know what your Service layer is doing to grab the bean and return it, but presumably it is asking Transfer for a Client

[transfer-dev] Re: Global Decorators

2008-12-04 Thread Matt Quackenbush
Create a BaseTransferObjectDecorator that extends transfer.com.TransferDecorator. Then have your decorator extend BaseTransferObjectDecorator. HTH --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: Global Decorators

2008-12-04 Thread Matt Quackenbush
On Thu, Dec 4, 2008 at 1:19 PM, Matt Graf wrote: I don't think I am explaining myself very well lets see if I can explain it a little better Here is an example of where I tell transfer to use my decorator object name=widget_one table=widget_one decorator=model.decorators.widget_one now

[transfer-dev] Re: OneToMany foreign key as part of a compositeID?

2008-12-15 Thread Matt Quackenbush
I should clarify that my pseudocode assumes that you are creating everything in onApplicationStart(). --~--~-~--~~~---~--~~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

[transfer-dev] Re: updating value of foreign key to child object

2008-12-30 Thread Matt Quackenbush
It's early (for me), so I might be missing something, but I believe it would be questionType = transfer.get(QuestionType, 2); quiz.setQuestionType(questionType); transfer.save(quiz); On Tue, Dec 30, 2008 at 10:26 AM, Brian FitzGerald wrote: Hey all, I'm banging my head against the wall here

[transfer-dev] Re: easy management of many to many relationships

2009-01-08 Thread Matt Quackenbush
Doug, Here's what I do in essentially the exact same scenario, though it's User Permission instead of User Preference. This is from the User object. cffunction name=setPermissionsById hint=I set my permissions based upon the supplied ID list returntype=void output=no access=public

[transfer-dev] Re: Nullable Values - still don't get it

2009-01-11 Thread Matt Quackenbush
Jon, thanks for the info. I've not previously noticed that, and I'm not really sure why I have not noticed it, seeing as that behavior has obviously been around for a really long time now. (I looked back at a couple of my old decorators and they're using configure() to default the dates, so

[transfer-dev] Re: Date type is defaulting to today?

2009-03-23 Thread Matt Quackenbush
To expand a little bit on set{PropertyName}Null() when the property is a date, Transfer sets the value to the oldest date that CF will support: {ts '0100-01-01 00:00:00'}. Why this isn't done by default, I'm not really sure. It sure would make hellamore sense. :-)

[transfer-dev] Re: Link table with several FKs

2009-03-26 Thread Matt Quackenbush
ManyToMany, like any other type of relationship, is a relationship between only two tables. If you have more than one relationship that you're modeling in your object, you need to add the appropriate config node for each relationship. --~--~-~--~~~---~--~~ Before

[transfer-dev] Re: Link table with several FKs

2009-03-26 Thread Matt Quackenbush
Modeling is a funny thing, and like seemingly everything else in the computer world, there is more than one way to skin a cat. In other words, there are probably 8 or 10 different ways you could model things to get the desired result. My apologies, but in terms of a model, I have no idea what

[transfer-dev] Re: Where do you put your complex queries?

2009-03-31 Thread Matt Quackenbush
I have 100% of my database code extracted into a DAO, which handles all interaction with Transfer, as well as all custom queries. By doing this, should I ever change away from Transfer (God forbid), all of my changes will be made in a single place. None of my services or controllers or business

[transfer-dev] Re: Where do you put your complex queries?

2009-03-31 Thread Matt Quackenbush
Yes, sir, that is what I'm saying. That way anything and everything having to do with database interaction is in one place (though there are multiple DAOs - one per package). Single-record queries? Check. Aggregate queries? Check. Paged list queries? Check. Saves? Check. Deletes? Check.

[transfer-dev] Re: Websites going down

2009-05-06 Thread Matt Quackenbush
Weird man, the website is down. Is something wrong with it? ;-) --~--~-~--~~~---~--~~ 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

[transfer-dev] Re: manytoone relationships in lists

2009-05-28 Thread Matt Quackenbush
If I am understanding the question correctly, I believe that a little bit of TQL (or plain ol' SQL) is in order. http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: multi-table query

2009-06-11 Thread Matt Quackenbush
With TQL you can do a readByQuery() which returns an object, or you can do listByQuery() which returns a record set. Take your pick. You cannot do transfer.get() and do custom joins. That will instead simply return a composed object. --~--~-~--~~~---~--~~ Before

[transfer-dev] Re: Event Handlers: Comparing Changes

2009-08-05 Thread Matt Quackenbush
Use a decorator. In it you can utilize a variety of techniques to track the old value and compare it with the new value. For example... 1) Create an ActionAfterNewTransferEvent observer, which calls a method on your decorator. I use configAfterNew() in mine. For an example of how to register

[transfer-dev] Re: Event Handlers: Comparing Changes

2009-08-05 Thread Matt Quackenbush
Wow. That sucks. I hit something (who knows what) and gmail sent the damn thing before I could finish it. My apologies. Let me try again. cffunction name=configAfterNew returntype=void cfscript setCurrentUserName(getUserName()); /cfscript /cffunction cffunction

[transfer-dev] Re: Event Handlers: Comparing Changes

2009-08-05 Thread Matt Quackenbush
I guess this is my day to send emails before they're finished or properly proofed. Let me try the damn code one more time. cffunction name=configAfterNew returntype=void cfscript setCurrentUserName(getUserName()); /cfscript /cffunction cffunction name=getCurrentUserName

[transfer-dev] Re: Event Handlers: Comparing Changes

2009-08-05 Thread Matt Quackenbush
First of all, just for the sake of pointing out what may or may not already be obvious, just because you use a decorator for one object certainly does not require you to use decorators for all objects. Secondly, in my personal opinion, the business object (decorator in this case) is exactly where

[transfer-dev] Re: Event Handlers: Comparing Changes

2009-08-06 Thread Matt Quackenbush
Elliott, To be clear, I only said that clone() should be used when editing an object. Consider this scenario... Step 1: User submits form with data to edit/update an object Step 2: Grab object from Transfer and populate with new data Step 3: Validation of new data fails Step 4: Skip the

[transfer-dev] Re: Retrieving an object based on a relationship value

2009-08-17 Thread Matt Quackenbush
Turn on debug output in your CFAdmin. It will show all queries that were run. --~--~-~--~~~---~--~~ 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

[transfer-dev] Re: manytomany... not quite

2009-09-02 Thread Matt Quackenbush
Can you post the relevant transfer.xml configs? I could be mistaken, but I think the issue is that you have an o2m on one side and an m2o on the other. AFAIK, that will not do the trick. --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: manytomany... not quite

2009-09-03 Thread Matt Quackenbush
Howdee :-) You're welcome. OK, so that is exactly what I thought you were doing. The reason that will not work is because the o2m generates methods on *both* objects in the relationship, and therefore generates the ID (PK/FK) in the SQL twice. Instead, create an m2o on *both* objects (instead

[transfer-dev] Re: manytomany... not quite

2009-09-03 Thread Matt Quackenbush
The only methods (for the relationship) that will be generated are the m2o ones. http://docs.transfer-orm.com/wiki/Generated_Methods.cfm#ManyToOne_Element So, any of the other o2m methods that have to do with getting at the child(ren)/parent will not be generated.

[transfer-dev] Re: manytomany... not quite

2009-09-03 Thread Matt Quackenbush
Schwet! I love it when a plan comes together. :-) --~--~-~--~~~---~--~~ 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: Lets get acquainted

2009-09-16 Thread Matt Quackenbush
This seems to be happening on *a lot* of google groups lists lately. That is, moderated users' posts still getting through. This is at least the fourth or fifth list (that I am on - I am sure there are many others) in the last couple of days that it has happened to. Apparently someone has found

[transfer-dev] Re: Lets get acquainted

2009-09-16 Thread Matt Quackenbush
Strangely enough, the very same posters are being stopped by the moderation on the ColdBox group. shrug --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: One-to-many problem

2009-09-26 Thread Matt Quackenbush
Add a dwcorator method that looks them up. Sent from my iPhone On Sep 26, 2009, at 8:20, Erik-Jan Jaquet ejjaq...@gmail.com wrote: Hi Mark, The manytoone relationship does work, but I need to know which tasks are assigned to a user. And with a many to one I just get the user methods in

[transfer-dev] Re: getDataSource. What Am I missing?

2009-09-30 Thread Matt Quackenbush
Have you tried getTransfer().getDatasource() ? --~--~-~--~~~---~--~~ 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

[transfer-dev] Re: problem with relationships

2009-10-01 Thread Matt Quackenbush
You cannot have the m2m as well as an o2m with the same table. Additionally, the m2m's other properties will not be recognized in the m2m relationship. Based upon my quick glance at the code, i would suggest utilizing an m2o for each, and then using decorator methods to gain the additional

[transfer-dev] Re: problem with relationships

2009-10-01 Thread Matt Quackenbush
Nope. I mean m2o. With an o2m, Transfer places methods on both objects. You can only do a o2m with one relationship, and then you cannot use that object in another relationship. So, use an m2o on both objects along with some decorator methods, and you will be able to accomplish your goals.

[transfer-dev] Re: problem with relationships

2009-10-01 Thread Matt Quackenbush
I have not had time to take a thorough look through your config files, but after a quick glance I think you'll actually have something like this: http://www.pastebin.ca/1588561 --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: problem with relationships

2009-10-01 Thread Matt Quackenbush
Oh, and as for decorator methods, you would simply need to add methods to your applications decorator with which to retrieve its associated applications_users. --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: removemanytoone and cascadeDelete

2009-10-14 Thread Matt Quackenbush
Transfer does not allow you to have two different objects with an o2m like you are describing. Can you please show us the relevant XML from your transfer.xml file? --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: removemanytoone and cascadeDelete

2009-10-15 Thread Matt Quackenbush
Ok, first of all, just to reiterate, you cannot use an o2m on two objects like that. You will need to use m2o and then add decorator methods to fill in the missing methods that you need. Secondly, you will want to call removeCountry() on the object, and not removemanytooneCountry(). Hopefully

Re: [transfer-dev] Re: Removing / breaking relationships not working

2009-12-08 Thread Matt Quackenbush
You would remove the relationship (e.g. foo.removeParentBar()), and then delete the item that you want to delete (e.g. transfer.delete(foo)). HTH -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You

Re: [transfer-dev] Re: Removing / breaking relationships not working

2009-12-08 Thread Matt Quackenbush
Or you could, of course, skip the removeParentBar() and cut right to the chase e... delete. :D On Tue, Dec 8, 2009 at 2:23 PM, Mark Mandel mark.man...@gmail.com wrote: What's wrong with Transfer.delete(myPagePanel) ? Mark -- Before posting questions to the group please read:

Re: [transfer-dev] Re: CF9 performance boost?

2010-02-04 Thread Matt Quackenbush
Aaahhh. A man after my own heart. :-) On Thu, Feb 4, 2010 at 3:45 PM, Jamie Krug wrote: or find me at the bar :) -- 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

Re: [transfer-dev] Railo Transfer AutoWire Problem

2010-02-12 Thread Matt Quackenbush
FWIW, Luis was using the name CachBox long before Isaac's project appeared. As far as I know Luis intends to still use the name since a) he has been using it for years, and b) it fits in with the naming convention of all the other ColdBox-based libraries. There is only one _real_ CacheBox, and it

Re: [transfer-dev] View the underlying SQL

2011-03-18 Thread Matt Quackenbush
To see the queries in ACF, turn on debugging output. I don't know for sure, but I assume that Railo would be the same. That said, I am not mistaken, Transfer is not officially supported on Railo. Transfer uses a number of things under the hood which are ACF specific. Additionally, Transfer

Re: [transfer-dev] View the underlying SQL

2011-03-18 Thread Matt Quackenbush
Wow @ that SQL. NULL as name 3 different times?? Definitely seems a bit odd, and most certainly ambiguous. I'd be curious to see what that exact same query looks like under ACF. My bet is it doesn't have NULL as name more than once. ;-) -- Before posting questions to the group please read:

Re: [transfer-dev] Re: Automatically passing values from parent to child on DB retrieval

2011-06-24 Thread Matt Quackenbush
new in that context more or less means newly minted by the Transfer factory. It does not relate specifically to persistence. HTH On Fri, Jun 24, 2011 at 6:12 PM, Clarkee21 clarke...@gmail.com wrote: Hi Jason, Spot on with the scenario. In my case I'm dealing with a Finance object that

Re: [transfer-dev] Updated Transfer repository on Github

2014-07-13 Thread Matt Quackenbush
Nice work, Brian. While I no longer use Transfer myself, I know there are folks - aside from you, even (heh) - out there who still are. I love the spirit of open source software! On Jul 13, 2014 11:39 AM, Brian G brian-goo...@vfive.com wrote: Since I was deep in the guts of Transfer this week