Hi veepee,
I am having the exact same problem. have you ever found a solution?

On Saturday, February 27, 2010 4:46:12 PM UTC+2, veepee wrote:
>
> Hi All,
>
> I am new to cakePHP and I've tried googling for this topic but to no
> avail. I need to create a database table from controller. May i know
> is it possible to insert into the newly created table, i.e. in this
> example, the customer table using model?
>
>  $this->Q->query("CREATE TABLE customer
>                       (First_Name char(50),
>                       Last_Name char(50),
>                       Address char(50) default 'Unknown',
>                       City char(50) default 'Mumbai',
>                       Country char(25),
>                       Birth_Date date)");
>         }
>  $this->loadModel('Customer');
>  $this->Customers->saveAll(data);
>
> I've tried it but this does not work. May I know if there are any
> alternatives besides creating another insert statement using
>
> $this->Q->query("INSERT INTO customer...");
>
>

-- 
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].
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.


Reply via email to