Where: NOT IN

Hi,

on https://www.chronoengine.com/faqs/72-ccv5/5215-how-do-i-build-a-where-statement-in-ccv5.html there is a Example like this:

> return array( 'model_id.column !=' => 'value' );

when I write this syntax, he brings me an error message that he does not know the table. for example, in my case, he write this in the sql-code "... WHERE `Benutzer_eot`.`id !=` IN ('130' .... etc" = Unknown column 'Benutzer_eot.id !=' in 'where clause'

i write this in the conditions in a db reader: <? return array('Benutzer_eot.id !=' => $_benutzer, 'ZT_Benutzer_eot.status' => 1); ?>
$_benutzer is an array.

what am I doing wrong

Hi Brani,

I suggest that you follow the Complex Query example further down the FAQ,

And you will need to convert $_benutzer into a quoted, comma separated string to use it in an NOT IN statement.

Bob