Hi,
I got a table scheme which can be shortened to this:
Person:
columns:
id: { type: integer(4), notnull: true, unique: true, primary:
true, autoincrement: true }
user_id: { type: integer(20) }
name: { type: string(100), notnull: true }
contract_id: { type: integer(4) }
relations:
Contract: { class: Contract, local: contract_id }
Contract:
columns:
id: { type: integer(4), notnull: true, unique: true, primary:
true, autoincrement: true }
organisation_id: { type: integer(4), notnull: true }
code: { type: string(3), notnull: true }
Organisation:
columns:
id: { type: integer(4), notnull: t rue, unique: true, primary:
true, autoincrement: true }
name: { type: string(100), notnull: true, unique: true }
I tried extending the query with an innerJoin:
$query = Doctrine::getTable('Person')->createQuery('p')->innerJoin('p.Contract
c');
$this->widgetSchema['dhb_area_id']->setOption('query',$query);
$this->widgetSchema['dhb_area_id']->setOption('method','getOrganisationId');
--> this leaves the select dropdown with empty strings
I was thinking about using table_method, but either way, how do I get
around the name conflict, ie. if I use 'getName', how can I choose
which table it comes from?
Thanks for any help,
Jochen
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" 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/symfony-users?hl=en
