[FX.php List] Query Operator question

Alex Gates alex at gandrpublishing.com
Fri Dec 29 20:53:41 MST 2006


I'd like to perform a query and bring back only records that don't 
contain "Trashed" in a field called "Trashed."

I can think of two ways this could possibly work, but none of them 
worked for me.
You could add a DB Param that brings back only "" for Trashed -
like:
$lookup=new FX($serverIP,$webCompanionPort,'FMPro7');
$lookup->SetDBData('Web_Cookbook_Dev.fp7','RecipeList');
$lookup->SetDBPassword('xxxxxx','xxxxxx');
$lookup->AddDBParam('WebAccountNumber','"'.$WebAccountNumber.'"', 'eq');
$lookup->AddDBParam('Trashed', '""');
$lookup->AddSortParam('RecordID','descend');
$lookupResult=$lookup->FMFind();
$foundResult=$lookupResult['foundCount'];


or using a Query Operator

$lookup=new FX($serverIP,$webCompanionPort,'FMPro7');
$lookup->SetDBData('Web_Cookbook_Dev.fp7','RecipeList');
$lookup->SetDBPassword('xxxxxx','xxxxxx');
$lookup->AddDBParam('WebAccountNumber','"'.$WebAccountNumber.'"', 'eq');
$lookup->AddDBParam('Trashed', "Trashed", 'NEQ');
$lookup->AddSortParam('RecordID','descend');
$lookupResult=$lookup->FMFind();
$foundResult=$lookupResult['foundCount'];


I've had no luck with any of these...

Is my syntax correct?


More information about the FX.php_List mailing list