composite keys on many-to-many relationships

2011-08-10 Thread Glyn Jackson
Hi, Just trying to understand this issues, maybe I have missed something I created a many-to-many relationship in ORM (see below). When I add an account to a scape i.e. addAccount(account) the second time I add the 'same' account to the scape I 'should' get an error because of the

Re: composite keys on many-to-many relationships

2011-08-10 Thread Andrew Scott
Is this being mapped to an already existing database? What are you ormsettings in application.cfc And you are right, unless you are mapping to an existing DB where the realtionships and constraints are already setup, then you would assume that you can't. However I am guessing you have ORM setup

Re: composite keys on many-to-many relationships

2011-08-10 Thread Glyn Jackson
thanks i have posted in the orm group as suggested and asked for a little more help understanding what I did wrong. link here: http://groups.google.com/group/cf-orm-dev/browse_thread/thread/bb644ecbe4da3214 ~| Order the

RE: composite keys on many-to-many relationships

2011-08-10 Thread Andrew Scott
] Sent: Thursday, 11 August 2011 12:13 AM To: cf-talk Subject: Re: composite keys on many-to-many relationships thanks i have posted in the orm group as suggested and asked for a little more help understanding what I did wrong. link here: http://groups.google.com/group/cf-orm- dev