Re: DBIx join problem

in reply to DBIx join problem

A couple thoughts:

Have you tested your sql statement with DBI and found that it worked (ie, how sure are you it's DBIx)
What errors were reported by DBIx when you attempted to prepare and/or execute the statement?

FWIW, I have no trouble joining tables and creating charts based off a select statement using DBIx.

Comment on Re: DBIx join problem

Replies are listed 'Best First'.
Re^2: DBIx join problem by jsmith2012 (Initiate) on Jul 30, 2009 at 22:22 UTC
below is the dbix query that i came up w/ from the documentation. The error i got was "No relationship DBIx::Class::ResultSet::count(): No such relationship image_folder". i have tested the sql and it works. `my $rs = $schema->resultset('ImageDescription')->search( { 'image_folder.name' => 'japan' }, { join => { 'image_folder' => 'image_folder'} } );` [download]	[reply] [d/l]

In Section Seekers of Perl Wisdom