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
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