I am trying to use the onetomany in Transfer but I am not sure I am
understanding it correctly here is my transfer config.
<object name="Client" table="clients"
decorator="model.decorators.client">
<id name="clientID" type="UUID"
generate="true"/>
<property name="clientName" type="string"
column="clientName" />
<property name="insOn" type="date"
column="insOn" />
<property name="insByfk" type="string"
column="insByfk" />
<property name="updOn" type="date"
column="updOn" />
<property name="updByfk" type="string"
column="updByfk" />
<property name="isActive" type="numeric"
column="isActive" />
<manytomany name="modules"
table="ClientModules">
<link column="clientIDFK"
to="client.Client"/>
<link column="moduleIDFK"
to="lookups.Modules"/>
<collection type="array">
<order property="ModuleName"/>
</collection>
</manytomany>
<onetomany name="AttendeeRoles">
<link to="client.AttendeeRoles"
column="clientIDFK"/>
<collection type="array">
<order property="attendeeRole"
order="asc"/>
</collection>
</onetomany>
</object>
<object name="AttendeeRoles" table="attendeeRoles"
decorator="model.decorators.AttendeeRoles">
<id name="attendeeRoleID" type="UUID"
generate="true" />
<property name="attendeeRole" type="string"
column="attendeeRole" /
>
<property name="isActive" type="numeric"
column="isActive" />
<property name="insByFk" type="string"
column="insByFk" />
<property name="insOn" type="date"
column="insOn" />
<property name="updByFk" type="string"
column="updByFk" />
<property name="updon" type="date"
column="updon" />
</object>
but now I can't do this.
local.tql="
from
client.AttendeeRoles as t1
join client.Client as t2
on t1.clientidfk = t2.clientid";
rc.query = rc.transfer.createQuery(local.tql);
rc.qAttendeeRoles = rc.transfer.listByQuery(rc.query);
here is the error I am getting
Application Execution Exception
Error Type: PropertyNotFoundException : [N/A]
Error Messages: The property that was searched for could not be found
The property 'clientidfk' could not be found in the object
'client.AttendeeRoles'
when I add the clientidfk to the attendeeroles I get this error
Error Type: Database : 42000
Error Messages: Error Executing Database Query.
Column 'clientIDFk' specified twice
INSERT INTO attendeeRoles
(clientIDFK,attendeeRole,isActive,insByFk,insOn,updByFk,updon,clientIDFK,attendeeRoleID)
VALUES ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) ,
(param 6) , (param 7) , (param 8) , (param 9) )
what am I doing wrong.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
