[transfer-dev] Re: Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Jamie Krug
Thanks, guys :) I probably will dig around and see what it looks like, but not for a week or two. I'll share if I find anything interesting/ useful. Jamie On Nov 11, 5:58 pm, Jared Rypka-Hauer <[EMAIL PROTECTED]> wrote: > The smallest piece of String you can get will cost you 8 bits. Take a   >

[transfer-dev] Re: Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Jared Rypka-Hauer
The smallest piece of String you can get will cost you 8 bits. Take a byte outta that, eh? J On Nov 11, 2008, at 4:27 PM, Mark Mandel wrote: > > How long is a piece of String? ;) > > Mark > > On Wed, Nov 12, 2008 at 8:45 AM, Jamie Krug <[EMAIL PROTECTED]> > wrote: >> >> Okay, thanks, Mark.

[transfer-dev] Re: ManyToMany on a compositeid?

2008-11-11 Thread Mark Mandel
Don't know why this isn't going to the google group. Mark On Wed, Nov 12, 2008 at 9:50 AM, Mark Mandel <[EMAIL PROTECTED]> wrote: > Right - So, something like (very pseudo code): > > > > > > > > > > > > > > > > > > > > > > > > > > That's pretty much it.

[transfer-dev] Re: ManyToMany on a compositeid?

2008-11-11 Thread Mark Mandel
No I mean just the tables - This is looking like a basic manytomany setup, it it is just 2 foreign keys on your m2m table. Mark On Wed, Nov 12, 2008 at 8:56 AM, Kenneth Cummins <[EMAIL PROTECTED]> wrote: > > H... ASCII art might be tough. Maybe this will help: > >

[transfer-dev] Re: Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Mark Mandel
How long is a piece of String? ;) Mark On Wed, Nov 12, 2008 at 8:45 AM, Jamie Krug <[EMAIL PROTECTED]> wrote: > > Okay, thanks, Mark. I'll hold off for now, but if I have some time, I > may try to hack just a little further to get things working w/ > PostgreSQL 8.3. I'm just concerned that after

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

2008-11-11 Thread Jorge Loyo
Bob, Thank you for your comments. Would you please explain a little what code you have in your abstract and concrete gateways? --~--~-~--~~~---~--~~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-suppo

[transfer-dev] Re: ManyToMany on a compositeid?

2008-11-11 Thread Kenneth Cummins
H... ASCII art might be tough. Maybe this will help:

[transfer-dev] Re: Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Jamie Krug
Okay, thanks, Mark. I'll hold off for now, but if I have some time, I may try to hack just a little further to get things working w/ PostgreSQL 8.3. I'm just concerned that after I address the current error, I'll hit another, and then another... Not sure how long of a thread I'd be pulling! Can yo

[transfer-dev] Re: ManyToMany on a compositeid?

2008-11-11 Thread Mark Mandel
Ken - can you write this out in some more details (ASCII art maybe), I having trouble following what you are trying to do. Mark On Wed, Nov 12, 2008 at 5:57 AM, Ken Cummins <[EMAIL PROTECTED]> wrote: > > I may be doing this all wrong, since this is my first serious > application. So I welcome c

[transfer-dev] Re: Ordering relationship by more than one column

2008-11-11 Thread Mark Mandel
Currently no, but there is already a ticket: http://tracker.transfer-orm.com/issue.cfm?p=89977683-A728-9CD3-ABD9545A91734422&i=A942EECF-CEB6-F49A-46A0037A67D9DC2D Mark On Wed, Nov 12, 2008 at 4:05 AM, Matt <[EMAIL PROTECTED]> wrote: > > I have recently started working with Transfer and so far i

[transfer-dev] Re: Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Mark Mandel
There is an enhancement in the tracker to allow you to extend property definitions to use your own custom query params, with prefixes, suffixes, etc http://tracker.transfer-orm.com/issue.cfm?p=89977683-A728-9CD3-ABD9545A91734422&i=0DCDC600-91FC-A244-C3114EB37C2EDD1C It has yet to be implemented.

[transfer-dev] Re: Null default values

2008-11-11 Thread Mark Mandel
On Wed, Nov 12, 2008 at 12:03 AM, Kevin Roche <[EMAIL PROTECTED]> wrote: > > Hi, > > Thanks for answering my questions yesterday. > > Those problems are fixed now and I have new ones :-( > > I have some tables with dates on and I want to leave them in some cases set > to Null. When I instantia

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

2008-11-11 Thread Bob Silverberg
As usual, I agree with most of what Jared is saying, but I just wanted to provide another perspective. It is true that you can use TQL/SQL in your Decorators and Services, and this will save you from creating an extra cfc, and an extra layer in your model, but I tend to put those into a Gateway.

[transfer-dev] ManyToMany on a compositeid?

2008-11-11 Thread Ken Cummins
I may be doing this all wrong, since this is my first serious application. So I welcome comments and critiques... I'm building the ubiquitous shopping cart. I'm building it because it needs some special functionality that's not easily hacked onto existing packages. Anyway, I figured I'd start

[transfer-dev] Re: Difficulty understanding ORM<->SQL<->"old school db hacking" connections...

2008-11-11 Thread Ken Cummins
Thanks! My head was throbbing yesterday, and was not functioning properly... That's got one problem solved, but I think I may have a deeper, architectural issue, which I'll bring up in a new post. Thanks again! Ken On Nov 10, 5:15 pm, "Mark Mandel" <[EMAIL PROTECTED]> wrote: > You should prob

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

2008-11-11 Thread Jared Rypka-Hauer
Keep in mind that Transfer has it's own variety of CFCs that it loads up, but it features things like an uber-cool caching mechanism, so overall your app should indeed load faster and run better using Transfer. Another nifty thing that comes with Transfer is the JavaLoader that you can use

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

2008-11-11 Thread Jorge Loyo
J, "We're pretty much working with the philosophy that Transfer is a parallel to the DAO/Gateway concept" This is what I was thinking because as of now, in my current application I have over 160 CFCs (Gateways/DAOs) that could be eliminated if I can use Transfer to replace that functionality (mo

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

2008-11-11 Thread Jared Rypka-Hauer
Hey dude... Yeah, my original message was about 3x longer than the one I actually sent in... but a big part of it was focused on the fact that in the current project I'm on we're doing just that: treating Transfer as though it were a replacement for a "traditional persistence layer". Deco

[transfer-dev] Ordering relationship by more than one column

2008-11-11 Thread Matt
I have recently started working with Transfer and so far it has been great. The more I learn, the more useful I find it. My question has to do with ordering relationships between tables. Is there a way to order by more than one column? I tried adding a second order element but that resulted in

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

2008-11-11 Thread Jorge Loyo
J, Thank you for your response... Let me ask you, unless I need any custom SQL/TQL, is it really necessary to create the DAO and/or Gateway CFCs? or would calling transfer methods like listByPropertyMap or readByPropertyMap directly from the service be ok? Thank you in advance. -- Jorge Loyo -

[transfer-dev] Errors with PostgreSQL 8.3 UUID data type and Transfer 1.1

2008-11-11 Thread Jamie Krug
Sorry in advance for a lengthy one... Using the UUID data type in PostgreSQL 8.3 (http://www.postgresql.org/ docs/8.3/interactive/datatype-uuid.html) is problematic with cfqueryparam. There is no explicit cfsqltype, and using cf_sql_varchar will cause the following error when attempting a query l

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

2008-11-11 Thread Jared Rypka-Hauer
Jorge, If you're going to use Transfer instead of raw SQL, you're going to need to do the following: 1) Add TransferFactory to your ColdSpring config. 2) Add Transfer to your ColdSpring config using factory-bean and factory-method. 3) Add getters and setters to your DAO and Gateway objects t

[transfer-dev] Null default values

2008-11-11 Thread Kevin Roche
Hi, Thanks for answering my questions yesterday. Those problems are fixed now and I have new ones :-( I have some tables with dates on and I want to leave them in some cases set to Null. When I instantiate a new object Transfer set the dates to today and I really want them set to null. I h