Hello guys,
I'm using $ajax->observeField in order to retrieve how many
appointments are settled for a certain day, so my controllers action
is:
function byDay ()
{
$this->RequestHandler->setAjax($this);
if(!empty($this->data))
$date = $this->data['Appoinment']['date'];
else
$date = date('Y-m-d');
$this->set('appointments', $this->Appointment->findCount('WHERE
Appointment.date ="' . $date . '"'));
}
$date is passed via the observeField in my view, I get current date by
default:
<?php echo $html->input('Appoinment/date', array('value' => date('Y-m-
d'))) ?>
<?php echo $ajax->observeField('AppointmentDate', array('url'=>'/
appointments/byDay', 'frecuency' => 2, 'update' => 'appointments')) ?>
Here's everything works but the query I'm getting from cake is:
SELECT * FROM Appointments WHERE [Appointment].[date] LIKE
'%2007-06-18%'
And what I really need is a = statament:
SELECT * FROM Appointments WHERE [Appointment].[date] = '2007-06-18'
How can I change this behaviour ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
