Re: [RDBO] one-to-many with wrong count

[Uwe Voelker]

... and this gives an DBI error:

my %query = (
             'prices.region' => 'DE',
            );
my %rose  = (object_class    => 'Product',
             require_objects => [qw(prices)],
             with_objects    => [qw(category)],
             clauses         => [],
             query           => [%query],
            );

my $products = Rose::DB::Object::Manager->get_objects(%rose);





The error occurs with 0.075 and the cvs version.


Bye, Uwe

DBD::mysql::st execute failed: Unknown column 't2.product_id' in 'where clause' at /home/uwe/tmp/cvs/rose/modules/Rose-DB-Object/lib/Rose/DB/Object/Manager.pm line 813. get_objects() - DBD::mysql::st execute failed: Unknown column 't2.product_id' in 'where clause' at /home/uwe/tmp/cvs/rose/modules/Rose-DB-Object/lib/Rose/DB/Object/Manager.pm line 813. at /home/uwe/tmp/cvs/rose/modules/Rose-DB-Object/lib/Rose/DB/Object/Manager.pm line 1354 Rose::DB::Object::Manager::get_objects('Rose::DB::Object::Manager', 'clauses', 'ARRAY(0x89960a4)', 'require_objects', 'ARRAY(0x8151cd4)', 'object_class', 'Product', 'query', 'ARRAY(0x89960f8)', ...) called at /home/uwe/proj/rose/example/one-to-many.pl line 43

one-to-many.pl
Description: Perl program