Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^2: DBIx::Class : match integer-cols having specific bits set

by bliako (Prior)
on Sep 29, 2020 at 05:44 UTC ( #11122319=note: print w/replies, xml ) Need Help??


in reply to Re: DBIx::Class : match integer-cols having specific bits set
in thread DBIx::Class : match integer-cols having specific bits set

Brother 1nickt thanks for the hint and the pointers to SQL::Abstract which helped me to put together the literal SQL queries below:

my %where = ( '(roles &2) => \'(roles &4)', );

and

my %where = ( 0 => {'<' => \"(roles & 4)"}, );

or

my %where = ( '(roles & 4)' => {'>' => '0'}, );

bw, bliako

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (2)
As of 2020-12-06 01:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (65 votes). Check out past polls.

    Notices?