Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: Querying data with and & or when using DBIx::Class

by phildeman (Acolyte)
on Sep 17, 2013 at 12:44 UTC ( #1054430=note: print w/ replies, xml ) Need Help??


in reply to Re: Querying data with and & or when using DBIx::Class
in thread Querying data with and & or when using DBIx::Class

Thanks for the links. I actually used a sample script from the DBIx::Class::Manual::Cookbook:

-and => [ -or => [ color => 'Blue', color => 'Orange', ], ID => 1234 ]

and I got the following error:

DBIx::Class::ResultSet::search(): DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND => [ -OR => COLOR => BLUE, COLOR => ORANGE, , ID => 1234, ], ) )


Comment on Re^2: Querying data with and & or when using DBIx::Class

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (11)
As of 2014-08-21 18:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (141 votes), past polls