This seems like a simple thing to do, but I haven't been able to
figure out how to write the find conditions array to do it. Basically,
I want to run a query where I check whether one field in the record
equals another field in the same record. A simple illustration in SQL:
SELECT *
FROM users as User
WHERE User.id = User.parent_id
If you make a conditions array like:
$conditions = array('User.id' => 'User.parent_id');
cakePHP generates the SQL as
SELECT *
FROM users as User
WHERE User.id = 'User.parent_id'
and it fails on a data conversion error (sql fails trying to convert
the varchar value 'User.parent_id' to an int).
I couldn't find anything on this in the manual, but surely there's a
workaround using the cakePHP find conventions rather than resorting to
just writing the query right?
Thanks for any help you can provide.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
