You can't use a foreign key as a property and in a relationship at the same time.
Please see the documentation. http://docs.transfer-orm.com/wiki/Transfer_Configuration_File.cfm#manytoone Mark On Thu, Aug 27, 2009 at 6:51 AM, Jim Rising <[email protected]> wrote: > *the relevant portion of my transfer config:* > > <package name="apiEventMap"> > <object name="ApiEventMap" table="apieventsmap" > decorator="workspace.svn_fiduciaryEdge.trunk.model.decorators.apiEventMap"> > <id name="id" column="id" type="numeric" generate="false" > /> > <property name="apiEventID" column="apiEventID" > type="numeric" nullable="false" /> > <property name="apiID" column="apiID" type="numeric" > nullable="false" /> > <manytoone name="apiEvents"> > <link to="apiEvent.ApiEvent" column="apiEventID" /> > </manytoone> > </object> > </package> > > *My manager save():* > > <cffunction name="saveApiEventMap" access="public" returntype="any"> > <cfargument name="apiEventMap" type="transfer.com.transferObject" > required="true"> > <cfset var saveApiEventMap = ""> > <cfset var apiEventMap = arguments.apiEventMap> > > <cfset saveApiEventMap = getTransfer().save(apiEventMap)> > <cfset saveApiEventMap = "true"> > > > <cfreturn saveApiEventMap /> > </cffunction> > > The error I'm getting: > > Message Column 'apiEventID' specified twice SQL INSERT INTO > apieventsmap(apiEventID,apiID,apiEventID) VALUES ( 9999 , 9999 , 0 ) > > Any ideas? > > Thanks! > > -- > Jim Rising > Serial Entrepreneur > Software Engineer > Web Developer > > "Knowledge work requires both autonomy and accountability." > > > > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ 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-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
