2 others work around: - create a view - select from a subquery instead quering directly to the table.
Hope this helps. MARTIN On 04/26/2010 01:05 PM, jharris wrote:
Okay, so I figured out why I can't reference the alias in the WHERE conditions: it's just a MySQL restriction. As for using virtual fields in conditions, I've come to the conclusion that the current version of Cake does not handle them. Hope this information is helpful to someone. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "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/cake-php?hl=en
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "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/cake-php?hl=en
