Re: Efficiently finding elements with 0 has_many elements?

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

On 4/22/05, Michael Peters <mpeters@xxxxxxxxx.xxx> wrote:
> Sorry... don't know why I did though has_a even though you said
> has_many. But, yes it's still just a matter of finding the right SQL
> that would give you the rows for the Item that you want. Then you can
> use something like set_sql() to execute it and give you the objects you
> want. And if you need more power, you can get the db handle, create a
> statement handle, execute it and then pass it to sth_to_objects().

OK, so now that I realize that has_many doesn't give me this ability
directly, this just reduces to a SQL problem (not a Class::DBI
problem) in finding rows that join with nothing. Which I'm pretty sure
I knew how to do at some point. Thanks.

--dave

--=20
David Glasser | glasser@xxx.xxx | http://www.davidglasser.net/