Can anyone tell me if it is possible to use the 'substring' keyword in Model->findAll() I'm trying to do this but I keep getting the mysql error "you have an error in yoru sql near...blah..blah) The query I'm using is below.
$data = $this->find(array('campaign_id as id'=> $id,'substring(upload_date,1, 10)'=>'2008-01-31'), array('imp','clicks','ctr','cpc','cost','pos','conv','conv_rate','cost_per_conv')) If can't then what should I use Model->query() ? thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---