#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 | Resolution:
Keywords: | Php_version: n/a
Cake_version: |
---------------------------+------------------------------------------------
Comment (by jaydipdave):
I am using following code to fetch the data:
Controller:
{{{
function admin_index() {
$this->setAdminArea();
$this->set('clients', $this->paginate('Client'));
Configure::write('debug', '2');
if($this->RequestHandler->isAjax()) {
$this->layout = 'ajax';
$this->viewPath = 'elements'.DS.'clients';
$this->render('paging');
}
}
}}}
view:
{{{
<td><?php echo $client['Client']['created']; ?></td>
<td><?php echo $client['Client']['modified'];?></td>
}}}
Note: I also tried with "$time->format('d/m/Y h:m:s', $value)"
Generated Query:
{{{
SELECT Client.id, Client.companyname, Client.contactpersonfirstname,
Client.contactpersonlastname, Client.contactnumber, Client.address1,
Client.address2, Client.city, Client.state, Client.country, Client.zip,
Client.phone, Client.fax, Client.email, Client.created, Client.modified,
Client.createdby, Client.modifedby, Clientuser.id, Clientuser.client_id,
Clientuser.username, Clientuser.password, Clientuser.securityquestion1,
Clientuser.answer1, Clientuser.securityquestion2, Clientuser.answer2,
Clientuser.securityquestion3, Clientuser.answer3,
Clientuser.securityquestion4, Clientuser.answer4,
Clientuser.securityquestion5, Clientuser.answer5, Clientuser.lastlogin,
Clientuser.remark, Clientuser.status, Clientuser.url FROM clients Client
LEFT JOIN clientusers Clientuser ON (Clientuser.client_id = Client.id)
WHERE 1 = 1 ORDER BY modified desc
}}}
--
Ticket URL: <https://trac.cakephp.org/ticket/5830#comment:5>
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
-~----------~----~----~----~------~----~------~--~---
