Hi there Is there a way to prevent Cake from parsing the $order argument of a call to findAll? Example: $conditions = null; $fields = null; $order = '"Object__distance"::text::integer';
$model->findAll($conditions, $fields, $order); The resulting order by clause produced by Cake is ORDER BY "Employee__distance"::text::integer" Note the unnecessary (and unterminated) quotation mark at the end which messes up the SQL. I have tried prepending the order statement with a -! as this seems to prevent CakePHP from parsing the condition part of queries but this workaround does not help for the order part. I know that I can write the SQL statement manually and then use $model- >query() But I would rather use as much cake as possible. Thanks for any tips Claudia --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
