Zend_DB_Table

General discussion forum for the Zend Server

Zend_DB_Table

Postby 8g0phsk1bn_dlppl23a5 on Mon Feb 11, 2013 7:39 am

Hi,

I am trying to frame a query in Zend where-in i have to fetch data from 2 Databases.

something like this
$select->from($this)->setIntegrityCheck(false)->join(array(
'bay_types' => 'bay_types'
), "bay_types.bay_type_id = dealer_bays.bay_type_id", array(
'bay_type_code'
))->where('dealer_id=?', $dealerId)->where("is_active = 'A'")->order("bay_type_id")->order("bay_name")->order("created_date");

Now, here table bay_types is in one schema say "A" and dealer_bays is in other schema say "B".
I have a config.ini which has details of default schema "A". Value of DB "B" is something i am dynamically fetching and appending to table names.
But this doesnot seem to work.


Can
8g0phsk1bn_dlppl23a5
 
Posts: 2
Joined: Mon Feb 11, 2013 7:31 am

Return to Zend Server

Who is online

Users browsing this forum: Google [Bot] and 9 guests