Re: [CDBI] question about set_sql and iterators

Perrin Harkins <[email protected]> Wed, 18 Nov 2009 11:48:59 -0500
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
On Wed, Nov 18, 2009 at 11:34 AM, Edward J. Sabol
<[email protected]> wrote:
> I don't think you've really understood how object-relational mappers work.
> You defined the SQL using A->set_sql() and then used A->search_*().
> Therefore, you are going to get objects of class A.

As Ed says, there's no support in Class::DBI for fetching multiple
object classes with one query.  If you really need that, you should be
looking at Rose::DB::Object or DBIx::Class.

- Perrin