Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Exclude from Select?

May 14, 2004, 4:17 AM

sangiro

Enthusiast (524 posts)

May 14, 2004, 4:17 AM

Post #1 of 5

Shortcut

Exclude from Select?

This is a typical select statement that you see in a lot of globals which will select all links that are new and validated:

$sth = $search_db->select ( { isNew => 'Yes', isValidated => 'Yes' });

How do I tweak this to select all links that are validated but exclude only those that are new?

Safe swoops
Sangiro

May 14, 2004, 4:59 AM

Payooo

User (424 posts)

May 14, 2004, 4:59 AM

Post #2 of 5

Shortcut

Re: [sangiro] Exclude from Select? In reply to

Maybe isNew => 'No', isValidated => 'Yes'

Last edited by:

Payooo: May 14, 2004, 5:00 AM

May 14, 2004, 5:04 AM

Andy

Veteran / Moderator (18441 posts)

May 14, 2004, 5:04 AM

Post #3 of 5

Shortcut

Re: [sangiro] Exclude from Select? In reply to

Yeah, Payoo is on the right track;

Code:
$sth = $search_db->select ( { isNew => 'No', isValidated => 'Yes' }) || return $GT::SQL::error;

Cheers

Andy (mod)
andy@ultranerds.co.uk

May 14, 2004, 6:57 AM

sangiro

Enthusiast (524 posts)

May 14, 2004, 6:57 AM

Post #4 of 5

Shortcut

Re: [Payooo] Exclude from Select? In reply to

Quote:

Maybe isNew => 'No', isValidated => 'Yes'

Yup - I understand that I can do that, but I'm specifically looking for the "not equal to" equivalent of =>

Safe swoops
Sangiro

May 14, 2004, 7:19 AM

Andy

Veteran / Moderator (18441 posts)

May 14, 2004, 7:19 AM

Post #5 of 5

Shortcut

Re: [sangiro] Exclude from Select? In reply to

You would need to do it via GT::SQL::Condition then...

my $cond = GT::SQL::Condition->new('Field','NOT LIKE','Yes','Field2','=','foo');
$table->select($cond) || return $GT::SQL::error;

The above should do the trick :)

Cheers

Andy (mod)
andy@ultranerds.co.uk