Thanks for your suggestions. Raw queries for multiplae datbase is working fine $this->query("select * from caketoodoo.tasks as t2, test.stores as t1 where t2.id = t1.id");
But my database name is depends on user input. How can I set $useDbConfig variable value. Like I made a module Task and controller TasksController. Suppose I get database name from URL and set $this->Task->useDbConfig = 'multiple'; (here , multiple is datbase name) that is already configure in datbase.php var $multiple = array( 'driver' => 'mysql', 'persistent' => false, 'host' => 'localhost', 'login' => 'root', 'password' => '', 'database' => 'caketoodoo', 'prefix' => '', ); then it show error Database table tasks for model Task was not found. because task module not getting value of useDbConfig. Please tell me how can I set useDbConfig value from controller or is there any other way to pass datbase name for module. Thanks On Sep 22, 9:17 pm, Rick <[EMAIL PROTECTED]> wrote: > Anotherdatabasereally isn't an option as I said this is an existing > MySql instance. > > Yeah, I could do raw queries but I wanted to taste the cakey goodness. > > Rick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---