According to the MySQL manual, the ALTER TABLE command does not give back a return code, unless it fails. And looking at the query method for the Model and the DboSource files the return code may be undefined for the ALTER TABLE command or false upon error. Enjoy, John
On May 27, 11:35 am, Wang Suyun <[email protected]> wrote: > $alter_sql = "ALTER TABLE `users` ADD `approved` > TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `image` "; > > if($this->ModelName->query($alter_sql)){ > $message .= "The column 'approved' has been added to > 'users' table"; > } > > it seems that the return value of $$this->ModelName->query($alter_sql) > will not be true, even though it is actually run correctly in > database. > > any one can give me some guide? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
