Gossamer Forum
Quote Reply
Problem with NOT IN
Hi,

Hi,

little Problem:

my $count = $DB->table('CatLinks','Links')->count( GT::SQL::Condition->new( 'statistik','=','1', Status => 'IN' => [$CFG->{http_bad}], 'CategoryID', 'IN', \@ids) );

runs perfect

but

my $count = $DB->table('CatLinks','Links')->count( GT::SQL::Condition->new( 'statistik','=','1', Status => 'NOT IN' => [$CFG->{http_bad}], 'CategoryID', 'IN', \@ids) );

runs not, syntax error, what is the correct syntax from 'NOT IN' ???

Many thanks

Jupp