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
Subject Author Views Date
Post Problem with NOT IN jupp 1207 Jun 14, 2004, 10:20 PM