Re: DBIx join problem

[jrsimmon]

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.

[jsmith2012]

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'} }
);