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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---