Need to prefix the table name by the database in the protected field $_name
of your Zend_Db_Table_Abstract child class.



debussy007 wrote:
> 
> Hi,
> 
> I am using classes extending the Zend_Db_Table_Abstract class.
> The Zend_Db_Table_Abstract will use the default adapter to fetch data.
> 
> When I need to fetch data from one DB and then another, I don't know how
> to handle it. 
> I would have, according to the API, to change of adapter, which implies I
> need to connect to the same server again to use another database !
> 
> However it should be possible to query several database from on connection
> to the server.
> I would like to see a method which allows to switch default database.
> 
> So temporarly, I must create my own fetchAll, fetchRow, etc. just to
> prefix the queries with the appropriate DB (( it's quite arduous.
> 
> I hope I was clear.
> 
> Thank you for any tips !!
> 

-- 
View this message in context: 
http://www.nabble.com/Fetch-data-from-several-Databases-with-Zend_Db_Table_Abstract-tp22118827p22118975.html
Sent from the Zend Framework mailing list archive at Nabble.com.

Reply via email to