[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