[FX.php List] "Not Equal to" search

[Steve Winter]

Ancahal,

By default FX performs a logical AND search, so I would expect that you
would see a list of images for which; 
  MLSType1 = CRIS  AND  ListingCompany != NextHome, Inc.

Is that what you expected...??? In what way is the data you get back
wrong...?  what are you getting by comparison with what you would expect...?

Cheers
Steve

> Hello,
>   I am facing problem problem in retrieving resultset for the following
> query.The resultset I get is wrong.
>  
> <?
> include_once("/inetpub/wwwroot/FX7/FX.php");
> include_once("/inetpub/wwwroot/FX7/server_data.php");
> set_time_limit(0);
> $RecordIDArray=array();
> $i=0;
> $PhotoUpdate = new FX($serverIP, $webCompanionPort,'FMPro7');
> $PhotoUpdate->SetDBData("NextHome.fp7", "Web",10);
> $PhotoUpdate->AddDBParam('MLSType1','CRIS','eq'); 
> $PhotoUpdate->AddDBParam('ListingCompany','NextHome, Inc.','neq'); 
> $PhotoUpdateData = $PhotoUpdate->FMFind();
> echo "<b>Error::</b>".$PhotoUpdateData['errorCode']."<br>";
> if($PhotoUpdateData['foundCount']>0){
>  foreach($PhotoUpdateData['data'] as $key=>$value){
>   $RecordIDArray[$i]=$value['RecordID'][0];
>   echo "<b>Records ID::</b>".$value['RecordID'][0]."<br>";
>   $i++;
>  }
> }
> ?>
>  
> Looking forward to your guidance.
> Thanks and Regards,
> Anchal
> 
> Yahoo! India Matrimony: Find your life partneronline.