Multiple connections

2010-05-25 Thread Maury
Staff, I have a database that has a table that contains the data for several other connections to the database. When I have a SQL script (example: ALTER TABLE ...) I want to run for all other databases. I would read the main database and I would connect to other databases to run the script. How c

Re: multiple connections

2007-08-23 Thread Feris Thia
On 8/23/07, Chris Hartjes <[EMAIL PROTECTED]> wrote: > > Yes. And also need different condition for each one. Is that possible ? > > > > Well, how would you do this if you weren't using CakePHP. I think > that will answer your question. I would loop for each row of first query and query the oth

Re: multiple connections

2007-08-23 Thread Chris Hartjes
On 8/23/07, Feris Thia <[EMAIL PROTECTED]> wrote: > > On 8/23/07, Dinh <[EMAIL PROTECTED]> wrote: > > I think that I dont really understand what you means. You want to join the > > tables at the different database server engines, dont you? > > > > Yes. And also need different condition for each on

Re: multiple connections

2007-08-23 Thread Feris Thia
On 8/23/07, Dinh <[EMAIL PROTECTED]> wrote: > I think that I dont really understand what you means. You want to join the > tables at the different database server engines, dont you? > Yes. And also need different condition for each one. Is that possible ? Regards, Feris --~--~-~--~

Re: multiple connections

2007-08-23 Thread Dinh
I think that I dont really understand what you means. You want to join the tables at the different database server engines, dont you? On 8/23/07, Feris Thia <[EMAIL PROTECTED]> wrote: > > > On 8/23/07, Grant Cox <[EMAIL PROTECTED]> wrote: > > > > $conditions=>array('OR' => array('Sales.id'=>'123',

Re: multiple connections

2007-08-23 Thread Feris Thia
On 8/23/07, Grant Cox <[EMAIL PROTECTED]> wrote: > > $conditions=>array('OR' => array('Sales.id'=>'123', > 'Customer.sales_id'=>'123') ); > > will use a boolean OR rather than AND. > > Hi Grant, I understand the OR condition, but that is not the situation I want. What I need is to have the 'Cust

Re: multiple connections

2007-08-22 Thread Grant Cox
$conditions=>array('OR' => array('Sales.id'=>'123', 'Customer.sales_id'=>'123') ); will use a boolean OR rather than AND. On Aug 23, 3:35 am, "Feris Thia" <[EMAIL PROTECTED]> wrote: > Hi All, > > I have 2 models => Sales (in MySQL server) and Customer (in SQL > Server) and I have "hasOne" assoc

multiple connections

2007-08-22 Thread Feris Thia
Hi All, I have 2 models => Sales (in MySQL server) and Customer (in SQL Server) and I have "hasOne" association with them. It's working fine with pagination except when I need to add condition for both models. With just one condition it is working fine, eg : $conditions=> array('Sales.id'=>'12