Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Conditions global question

Dec 3, 2007, 7:16 AM

nir

User (396 posts)

Dec 3, 2007, 7:16 AM

Post #1 of 7

Shortcut

Conditions global question

Hi
I need to insert to 2 conditions in a global with an "OR" sing so just one condition is need, now it use the 2 conditions. Who can I do it?
$cond->add(Title => Like => "%$temp%");
$cond->add(Description => Like => "%$temp%");

Dec 3, 2007, 7:21 AM

Andy

Veteran / Moderator (18441 posts)

Dec 3, 2007, 7:21 AM

Post #2 of 7

Shortcut

Re: [nir] Conditions global question In reply to

Hi,

This should do it:

Code:
$cond->add(Title => Like => "%$temp%"); 
$cond->add(Description => Like => "%$temp%");  
$cond->bool('OR');

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 3, 2007, 7:45 AM

nir

User (396 posts)

Dec 3, 2007, 7:45 AM

Post #3 of 7

Shortcut

Re: [Andy] Conditions global question In reply to

Thanks Andy
I insert this code but form some reason the conditions are not work at all.
$cond->add(Title => Like => "%$ temp%" , 'isValidated','=','Yes');
$cond->add(Description => Like => "%$ temp%" , 'isValidated','=','Yes');
$cond->bool('OR');

Dec 3, 2007, 8:14 AM

Andy

Veteran / Moderator (18441 posts)

Dec 3, 2007, 8:14 AM

Post #4 of 7

Shortcut

Re: [nir] Conditions global question In reply to

Hi,

You probably need something like:

Code:
my $cond1 = new GT::SQL::Condition; 
my $cond2 = new GT::SQL::Condition; 

$cond1->add(Title => Like => "%$ temp%" , 'isValidated','=','Yes'); 
$cond1->bool('OR');  

$cond2->add(Description => Like => "%$ temp%" , 'isValidated','=','Yes'); 
$cond2->bool('OR');  

my $sth = $DB->table('Links')->select( $cond, $cond2 ) || die $GT::SQL::error

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 4, 2007, 2:23 AM

nir

User (396 posts)

Dec 4, 2007, 2:23 AM

Post #5 of 7

Shortcut

Re: [Andy] Conditions global question In reply to

Hi Andy
Thanks for your replay, for same reason the conditions are still not work. I change it to-
my $cond = new GT::SQL::Condition;
$cond->add(Title => Like => "%$temp%");
$cond->add(Description => Like => "%$temp%");
$cond->bool('OR');
and it work, thanks for give me a direction to solve it.

Dec 6, 2007, 2:28 AM

Wychwood

User (182 posts)

Dec 6, 2007, 2:28 AM

Post #6 of 7

Shortcut

Re: [Andy] Conditions global question In reply to

You can't just use "Like" without quotes!!

Dec 6, 2007, 2:37 AM

Andy

Veteran / Moderator (18441 posts)

Dec 6, 2007, 2:37 AM

Post #7 of 7

Shortcut

Re: [Wychwood] Conditions global question In reply to

Erm, nir's post above your's kinda defies your last statement :P

Code:
$cond->add(Title => Like => "%$temp%"); 
$cond->add(Description => Like => "%$temp%");

..and he says:

nir wrote:

and it work, thanks for give me a direction to solve it.

I was actually only pasting it from his code he showed anyway - I don't normally use that format for conditions - prefer ('field','cond','val').

Cheers

Andy (mod)
andy@ultranerds.co.uk