Nice, that worked. Thanks!
On Sep 15, 5:56 pm, brian <[email protected]> wrote:
> Try:
>
> $conditions = array('User.id = User.parent_id');
>
> On Tue, Sep 15, 2009 at 5:51 PM, George <[email protected]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
