Hi,

How can I make a search that checks from one field if it's prohibited (meaning that it will not show those posts) when I have like 3-4 different values on that field which I want to show

$fm = new FileMaker(FM_DB, FM_HOST, FM_USER, FM_PASSWD);

$findCommand =& $fm->newFindCommand('layout');

$findCommand->addFindCriterion('title', $title);

if ($format)

$findCommand->addFindCriterion('type', '=='. $format);



$findCommand->addFindCriterion('type2', $type2);

$findCommand->addFindCriterion('description', $description);

$findCommand->addFindCriterion('rights',$rights );

like this $findCommand->addFindCriterion('rights' , "!="$rightsNOT )



And I have a Compound search too where I need to implement this also.



It would be stupid if I need to put lots of rights, but if there is no better way so... 

$findCommand->addFindCriterion('rights',$rights2 );

$findCommand->addFindCriterion('rights',$rights3 );

$findCommand->addFindCriterion('rights',$rights4 );

no need to reply... I used compound and setOmit()

Edited May 21, 201015 yr by Guest