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

2009-12-08 Thread Matthew
to NULL. Am I right? So to remove a m2m relationship you need to do this in old school SQL? And in order for the Transfer object in the cache to be aware of the deleted relationship you need to clear the 2 PK related objects from the cache? Cheers Matthew On Dec 8, 8:59 pm, Matthew matthewbchamb

[transfer-dev] Re: Relationship slowing page down / Transfer cache

2009-11-25 Thread Matthew
@Mark and @Brian; thanks very much for the help. It's a big help. I'm glad to be using the cache now because pages will be so much faster!!! Cheers Matthew On Nov 26, 12:07 pm, Mark Mandel mark.man...@gmail.com wrote: Or you could actually store Transfer itself in the Server scope.. that would

[transfer-dev] Relationship slowing page down / Transfer cache

2009-11-24 Thread Matthew
the object when the backend app updates it. Any ideas? Cheers Matthew -- 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

[transfer-dev] Re: Weird o2m behaviour on mulitple o2m with WHERE conditions

2009-10-05 Thread Matthew
, Matthew matthewbchamb...@gmail.com wrote: Hi Mark Any ideas on how I can achieve what I'm after? Perhaps I should use a decorator. So off the top of my head I'd retrieve all child objects (getContentTreeContentPanels) and then add a decorator method getPanelsByPosition(n). Within

[transfer-dev] How do you retrieve an object which has a compositeId instead of an Id?

2009-08-26 Thread Matthew
How do you retrieve an object which has a compositeId instead of an Id? --~--~-~--~~~---~--~~ 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

[transfer-dev] Re: How do you retrieve an object which has a compositeId instead of an Id?

2009-08-26 Thread Matthew
Don't worry, I've answered it myself by trial and error. ANSWER: You need to pass in a structure with keys matching the composite key names. On Aug 26, 7:18 pm, Matthew matthewbchamb...@gmail.com wrote: How do you retrieve an object which has a compositeId instead of an Id

[transfer-dev] Re: Is this a limitation of a Transfer m2m relationship?

2009-08-19 Thread Matthew
in a decorator configure method? I assume it will only be called once per object. I know the columns won't be saved when I call the save() method however various triggers on the database populate these fields anyway. Cheers Matthew On Jul 27, 11:59 am, Mark Mandel mark.man...@gmail.com wrote: You have

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

2009-08-17 Thread Matthew
Further to my last response; If I add my own join statement ON child.parentContentTreeId = parent.contentTreeId it throws this error The property 'parentTreeId' could not be found in the object 'Tree Cheers Matthew On Aug 18, 10:41 am, Matthew matthewbchamb...@gmail.com wrote: Hi Mark You

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

2009-08-17 Thread Matthew
You bloody ripper. Worked a treat!!! Thanks a million Mark. So this is how you get around the you can't have XXX as both a property and a relationship. On Aug 18, 10:49 am, Mark Mandel mark.man...@gmail.com wrote: Matthew, please see:http://docs.transfer-orm.com/wiki

[transfer-dev] Error when saving Column appears more than once in the result column list

2009-08-13 Thread Matthew
is causing the error however why I can not work out. The CFM is only dealing with the Order object so why on earth the SQL has 2xuserId due to the o2m I don't know. Cheers Matthew --~--~-~--~~~---~--~~ Before posting questions to the group please read: http

[transfer-dev] Re: Error when saving Column appears more than once in the result column list

2009-08-13 Thread Matthew
PM, Matthew matthewbchamb...@gmail.com wrote: Hi guys I'm getting the following error in my application Column name 'userId' appears more than once in the result column list. So I've prepared a simple sample which replicates the error: ***XML*** object name=user table=testUser

[transfer-dev] Re: CF9 and ORM

2009-07-27 Thread Matthew
@Mark: Thanks for letting us know where you stand - it's great to hear that Transfer won't be neglected. You've done a brilliant job in developing such a useful product. All the best for the future! Cheers Matthew On Jul 28, 7:31 am, Mark Mandel mark.man...@gmail.com wrote: James, Thanks

[transfer-dev] Re: Lazy loading issue?

2009-05-31 Thread Matthew
Cheers Matthew On May 29, 4:17 pm, Mark Mandel mark.man...@gmail.com wrote: I don't suppose the table you are pointing at for 'Orders' name is 'Order', or anything weird like that? Can we get the full error though? Mark On Fri, May 29, 2009 at 2:48 PM, Matthew matthewbchamb...@gmail.com

[transfer-dev] Re: Lazy loading issue?

2009-05-31 Thread Matthew
type=numeric / property name=totalPrice type=numeric / property name=deliveryName type=string / manytoone name=OrderUser link to=User column=userId / /manytoone /object Cheers Matthew On Jun 1, 9:52 am, Mark Mandel mark.man...@gmail.com wrote

[transfer-dev] Re: Lazy loading issue?

2009-05-31 Thread Matthew
\transfer\com\util\javaloader\JavaLoader.cfc | create (com.compoundtheory.dynamic.Memento) ] from C:\Program Files\Apache Group\Apache2\htdocs\transfer_v1-1\transfer\com\util\javaloader \JavaLoader.cfc Cheers Matthew On Jun 1, 10:56 am, Mark Mandel mark.man...@gmail.com wrote: You are right, doesn't

[transfer-dev] Re: Lazy loading issue?

2009-05-31 Thread Matthew
CORRECTION: I meant to say NOTE the final call to create() method in \transfer_v1-1\transfer\com\util\javaloader\JavaLoader.cfc. On Jun 1, 11:06 am, Matthew matthewbchamb...@gmail.com wrote: Hi Mark The follow was in the CF error diagnostics: Stack Trace: java.lang.StackOverflowError Type

[transfer-dev] Re: Lazy loading issue?

2009-05-31 Thread Matthew
Hi Mark Sorry I don't understand what is wrong with my FK's? Also, this sentence doesn't make sense: So maybe stick with an order knowing about a user, and a user could have infinite orders, and that could cause performance issues. Cheers Matthew On Jun 1, 11:18 am, Mark Mandel mark.man

[transfer-dev] Lazy loading issue?

2009-05-28 Thread Matthew
user.getOrdersArray() but get the error. I can call user.getUserId() and user.getFirstName() no problem. Setup: Transfer 1.1, CF 7 Cheers Matthew --~--~-~--~~~---~--~~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask

[transfer-dev] Filtering retrieval of manytomany objects

2009-05-21 Thread Matthew
the relationships via an admin system but when it is published to the user the promotions need to be filter based on their locale. Platform: Transfer 1.1, CF 7 Cheers Matthew --~--~-~--~~~---~--~~ Before posting questions to the group please read: http://groups.google.com

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

2009-03-31 Thread Matthew
it linked to the object? Cheers Matthew --~--~-~--~~~---~--~~ 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

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

2009-03-31 Thread Matthew
Hi Mark It makes sense to keep all Transfer usage within the DAO layer. So your saying your service calls a DAO and within your DAO you utilise Transfer for the simple queries and any method requiring a complex query you just write it straight into the DAO? Cheers Matthew On Apr 1, 10:01 am

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

2009-03-23 Thread Matthew
this property can be inserted into the database as NULL values.. I'll leave it up to you. Cheers Matthew On Mar 23, 4:39 pm, Mark Mandel mark.man...@gmail.com wrote: http://docs.transfer-orm.com/wiki/Default_Property_Values.cfm Mark On Mon, Mar 23, 2009 at 4:35 PM, Matthew matthewbchamb

[transfer-dev] Invalid Object Name?

2009-03-22 Thread Matthew
column=press_release_id type=numeric/ id property name=heading type=string/property /object CODE: **this works** cfdump var=#getTransfer().GetTransferMetaData ('PressRelease').getObjectName()# **this DOESN'T work ?!?!?** cfdump var=#getTransfer().list('PressRelease')# Cheers Matthew

[transfer-dev] Re: Invalid Object Name?

2009-03-22 Thread Matthew
No package. I have tried reloading Transfer, restarted CF but nothing worked. Cheers Matthew On Mar 23, 10:36 am, Mark Mandel mark.man...@gmail.com wrote: Is it in a package? Did you reset Transfer when you changed your config? Mark On Mon, Mar 23, 2009 at 10:33 AM, Matthew

[transfer-dev] Re: Invalid Object Name?

2009-03-22 Thread Matthew
Hi Mark The error I got was Invalid Object Name 'PressRelease'. Cheers Matthew On Mar 23, 11:10 am, Mark Mandel mark.man...@gmail.com wrote: Sorry, miserad what the error was... what was the exact error you got for next time? Mark On Mon, Mar 23, 2009 at 11:06 AM, Matthew matthewbchamb

[transfer-dev] Re: Saving the Secondary Key on a ManyToOne value?

2009-02-19 Thread Matthew
; don't get me wrong, I think Tranfer is great, it's probably just me not having worked out how to do what I want to do. You are right the setProductId doesn't make sense, I just put that in to try and describe what I'm trying to do. I was thinking along the lines of Paul's suggestion. Cheers Matthew

[transfer-dev] Re: Saving the Secondary Key on a ManyToOne value?

2009-02-19 Thread Matthew
Hi everyone, I just figured out what I was doing wrong. My code was similar to Pauls option 1 however instead of calling the getter I was calling the setter. It's all working - thanks Transfer! Cheers Matthew On Feb 20, 9:13 am, Matthew matthewbchamb...@gmail.com wrote: Hi everyone Thanks

[transfer-dev] Re: Saving the Secondary Key on a ManyToOne value?

2009-02-19 Thread Matthew
@Ezra: that makes complete sense. I solved it this morning as per my last reply. Thanks for confirming. Cheers Matthew On Feb 20, 10:31 am, Ezra Parker ezrapar...@gmail.com wrote: Hi Matthew, I think you misunderstood Paul's reply. You do not have to create a decorator to use the first

[transfer-dev] Saving the Secondary Key on a ManyToOne value?

2009-02-18 Thread Matthew
=Gallery id name=GalleryId column=galleryId type=numeric/id id name=TestField column=TestField type=string/id manytoone name=Product link column=ProductId to=Product/ /manytoone /object Cheers Matthew