Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: DBIx join problem

by jrsimmon (Hermit)
on Jul 30, 2009 at 18:43 UTC ( [id://784700]=note: print w/replies, xml ) Need Help??


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.

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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://784700]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2025-02-07 14:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Which URL do you most often use to access this site?












    Results (94 votes). Check out past polls.