#5800: dbo_oracle driver : insertion statement missing ---------------------------------------+------------------------------------ Reporter: pluriels | Owner: phishy Type: Bug | Status: new Priority: Low | Milestone: 1.2.x.x Component: Oracle | Version: RC2 Severity: Normal | Resolution: Keywords: oracle, driver, insert | Php_version: PHP 5 Cake_version: | ---------------------------------------+------------------------------------ Comment (by jaydipdave):
Hi Pluriels, As per new nightmare release on 25th November, 2008. I don't think we require "renderStatement" function in dbo_oracle.php. We are already having the same function in dbo_source.php. {{{ function renderStatement($type, $data) { extract($data); $aliases = null; switch (strtolower($type)) { case 'select': return "SELECT {$fields} FROM {$table} {$alias} {$joins} {$conditions} {$group} {$order} {$limit}"; break; case 'create': return "INSERT INTO {$table} ({$fields}) VALUES ({$values})"; break; case 'update': if (!empty($alias)) { $aliases = "{$this->alias}{$alias} {$joins} "; } return "UPDATE {$table} {$aliases}SET {$fields} {$conditions}"; break; case 'delete': if (!empty($alias)) { $aliases = "{$this->alias}{$alias} {$joins} "; } return "DELETE {$alias} FROM {$table} {$aliases}{$conditions}"; break; case 'schema': foreach (array('columns', 'indexes') as $var) { if (is_array(${$var})) { ${$var} = "\t" . join(",\n\t", array_filter(${$var})); } } if (trim($indexes) != '') { $columns .= ','; } return "CREATE TABLE {$table} (\n{$columns}{$indexes});"; break; case 'alter': break; } } }}} I was facing the same problem, I commented out the dbo_oracle.php's renderStatement and the application started working. CackePHP with oracle is bit buggy, but we all will solve it out. Thank You, Jaydeep Dave -- Ticket URL: <https://trac.cakephp.org/ticket/5800#comment:1> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---