#5830: Oracle - Timestamp field datatype issue
--------------------------+-------------------------------------------------
Reporter: jaydipdave | Owner: phishy
Type: Bug | Status: new
Priority: High | Milestone: 1.2.x.x
Component: Oracle | Version: RC2
Severity: Major | Keywords:
Php_version: n/a | Cake_version:
--------------------------+-------------------------------------------------
Hi Folks,
I found one more issue with "timstamp" datatype of oracle.
when i am using timestamp datatype for last_login field in oracle. The
generated query tries to store the data inform of string!
I have highlighted missing statment in dbo_oracle.php
{{{
switch($column) {
'''case 'timestamp': // MISSING STATEMENT'''
case 'date':
$data = date('Y-m-d H:i:s',
strtotime($data));
$data = "TO_DATE('$data', 'YYYY-MM-DD
HH24:MI:SS')";
break;
case 'integer' :
case 'float' :
case null :
if (is_numeric($data)) {
break;
}
default:
$data = str_replace("'", "''", $data);
$data = "'$data'";
break;
}
}}}
Have fun,
Thank You,
Jaydeep Dave
--
Ticket URL: <https://trac.cakephp.org/ticket/5830>
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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
