Re: trivial (?) question about joins

[prev] [thread] [next] [Date index for 2004/12/30]

On Wed, 2004-12-29 at 21:38 +0100, hubert depesz lubaczewski wrote:
> everything works, but now i'd like to search for all stowary with have
> czy_pobrano NULL *and* their respective sprzedaze's zakonczone_kiedy is
> also null.

You need to use set_sql() to add a custom constructor (with hand-written
SQL) to Paczki::stowary.  Read the section of the docs about "Ima::DBI
Queries" for some examples.

> i also checked wiki, and tried first code from
> http://www.class-dbi.com/cgi-bin/wiki/index.cgi?UsingJoins
> but, it also didn't work (i got errors about bad bindings - probably i
> just missed something obvious, but i just can't seem to find it.

That's the right idea.  If you post the code you tried, we can probably
help you fix it.

- Perrin