phildeman has asked for the wisdom of the Perl Monks concerning the following question:
I am using DBIx::Class and Catalyst. I need to perform a search using and & or. So, the SQL statement looks like this:
SELECT *
WHERE ID=1234 and (color='Blue' or color='Orange')
Order By ID
Any thoughts or suggestions?
Thanks.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Querying data with and & or when using DBIx::Class
by Your Mother (Archbishop) on Sep 17, 2013 at 03:01 UTC | |
by phildeman (Scribe) on Sep 17, 2013 at 13:09 UTC | |
by Your Mother (Archbishop) on Sep 17, 2013 at 14:31 UTC | |
by phildeman (Scribe) on Sep 17, 2013 at 20:31 UTC | |
by Your Mother (Archbishop) on Sep 17, 2013 at 20:48 UTC | |
by phildeman (Scribe) on Sep 17, 2013 at 20:35 UTC | |
Re: Querying data with and & or when using DBIx::Class
by McA (Priest) on Sep 17, 2013 at 00:09 UTC | |
by phildeman (Scribe) on Sep 17, 2013 at 12:44 UTC |
Back to
Seekers of Perl Wisdom