Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Change condition in code-fragment

Gossamer Threads

Home : Products : Gossamer Links : Development, Plugins and Globals :

Change condition in code-fragment

May 19, 2005, 2:52 AM

Coyu

User (100 posts)

May 19, 2005, 2:52 AM

Post #1 of 2

Shortcut

Change condition in code-fragment

Hi to all...

we have this fragment of code:

Code:
if($db->count({ Email => $args->{Email}, KS =>'500'})){ 
...

Can anybody tell me, how the syntax should be, if we change the condition into:

IF KS eq "400" OR "500"

Thanks in advance!

Corc

May 19, 2005, 3:19 AM

Andy

Veteran / Moderator (18441 posts)

May 19, 2005, 3:19 AM

Post #2 of 2

Shortcut

Re: [Coyu] Change condition in code-fragment In reply to

Hi,

You'd probably need to use GT::SQL::Condition. Something like;

Code:
my $cond = GT::SQL::Condition->new('KS','=','500','KS','=','400'); 
$cond->bool('OR'); 
if($db->count({ Email => $args->{Email} }, $cond)){

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676