[horde] Dual tables for turba

Chuck Hagenbuch chuck at horde.org
Thu Jun 7 22:45:52 UTC 2007

Quoting Mikal & Suzi Romein <romein8 at bigpond.com>:

> I am trying to get the turba address book to use my tables for its  
> data source. The Turba sources.php file says that it can be done and  
> I have the following setting.
>  'params' => array_merge($conf['sql'],
>                          array('table' => 'pwr_cards LEFT JOIN  
> 'pwr_cards_address ON 'pwr_cards.CardRecordID =  
> 'pwr_cards_address.CardRecordID',
>                                'filter' => pwr_cards.'IsInactive = 0')),
> However when adding a new record the system says error adding the  
> new contact, DB error:syntax error.
> My question is what is the correct way to specify multiple tables  
> for turba? Can it be done? I am using mysql 5. If I use a single  
> table, and remove the references to fields in the second table, in  
> the above example it works fine.

Yeah, it can't be done currently. Well, perhaps you could do the join  
in the filter instead of in the table name - definitely won't work in  
the table name.


More information about the horde mailing list