[FX.php List] Search parameters aren't quite working with FMSA7...

[Jim Bowser]

I need help.  It has been suggested that the reason my "AddDBParam" isn't
working with date- and number-formatted fields is because I have to tell the
FX.php instance that you want to use FM7 XML-grammar.

 I had already changed the FX.php document in the FX folder to read:

 ...
class FX 
 { 
 // These are the basic database variables.
 var $dataServer = "";
 var $dataServerType = 'FMPro7';
 var $dataPort; 
...

If I hadn't changed this line from 'FMPro 5/6' to 'FMPro7' my code wouldn't
work at all. To be sure, I also tried to set it in the code on my web page
like so: 

 <?php 
 $coldate = date('m/d/Y');
 $search_result = new FX($serverIP,$webCompanionPort,'FMPro7');
 $search_result->SetDBData('My_Database','My_Layout', $banner_qty);
 $search_result->SetDBPassword('xxx','xxx');
 $search_result->AddDBParam('Banner_Column','Yes');
 $search_result->AddDBParam("Banner_Page",$banner_page);
 $search_result->AddDBParam("Banner_Expire_Date",$coldate,'gt');
 $search_result->AddSortParam("Banner_Expire_Date","ascend");
 $bannerlist = $search_result->FMFind();
 foreach ($bannerlist['data'] as $recordKey =>$recordData) { ?>

 ...and so on.  No errors occur, but no records are found either. However,
when I search using a "Current"/"Expired" calculation field based the
"Banner_Expire_Date" date field, it works fine. It is also interesting to
note that the AddSortParam works just fine with the same date-formatted
field.

 Is there somewhere else I'm supposed to tell the FX.php instance that I
wish to use FM7 XML-grammar? If you could indicate how and where, that would
be GREAT! I just don't see it.

 Thanks again!


Jim Bowser
Network Manager
Shoreline Creations Ltd.
Publisher of:
  GROUP TOUR MAGAZINE
  STUDENT GROUP TOUR MAGAZINE

616-393-2077 x120
800-767-3489 x120
jim at grouptour.com
www.grouptour.com