> is there any mechanism to do fancier table linking without resorting to
sql?
> for example: a.b_id links to b.id, but table b is a log, so it should be:
> where whatever and a.b_id = b.id and b.date >= all
>
YOu must specfiy the !Links parameter. See DBIx::Recordset docs "Working
with multiple tables", for example when you setup table a, you say
!Links =>
{
'-b' =>
{
'!Table' => 'b',
'!LinkedField' => 'id',
'!MainField' => 'street_id',
'date' => $all,
'*date' => '>=',
}
}
YOu can give any addtional conditions you like
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
