Re: Request: Support for __JOIN(c1.fkey c2)__

[prev] [thread] [next] [Date index for 2005/05/04]

>>>>> "sriha" == sriha  <sriha@xxxx.xxx> writes:

sriha> The __JOIN(c1 c2)__ placeholder is unpredictable if c1 has
sriha> multiple has_a relationships to c2.  CDBI simply picks the
sriha> first relationship it finds.  You should be able to explictly
sriha> specify which relationship to use.

And while you're in there dinkin' with that code, some support for
various joins in the FROM section would be nice too.

I'm slowly coming around to the notion that all joins should be listed
in FROM, reserving WHERE for strictly things that are reducing the
table set.  If I'm missing something, let me know.

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!