Simon Roby a écrit :
> I've just noticed that the doSelectJoin*() methods generated by Propel
> in my project don't actually do proper joins but instead do a simple
> "WHERE x.id = y.id" to link tables together. I'd like to be explained
> why it was coded like this, as this behavior sounds completely wrong
> and incorrect to me, since all rows with a foreign key field set to
> NULL (ie. rows not linked) are discarded from the query. Shouldn't
> there be a LEFT JOIN here? Or am I missing something here?
I don't know why it's coded like this but you can write your own
doSelectJoin*() functions (with left join inside).
You can also try to pass a criteria with a leftjoin as a parameter for
doSelectJoin*() functions. (not sure it overrides the 'normal' join, not
sure propel is able to hydrate correctly the joined objects if foreign
key is at NULL).
:-)
Nicolas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
