XP is just a number | |
PerlMonks |
Re^2: Querying data with and & or when using DBIx::Classby phildeman (Scribe) |
on Sep 17, 2013 at 12:44 UTC ( [id://1054430]=note: print w/replies, xml ) | Need Help?? |
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, ], ) )
In Section
Seekers of Perl Wisdom
|
|