[FX.php List] Query failing mysteriously...

Bob Patin bob at patin.com
Tue Jan 29 11:33:59 MST 2008


I've got a query that has the following parameters:

userid = numeric (I don't think this is the problem)

date range = something like

$range = "12/01/2007...01/28/2008";

Here's my query code:

//GET LOG
$log=new FX($serverIP,$webCompanionPort);
$log->SetDBData('xxxx.fp7','log','All');
$log->SetDBPassword('xxxx','xxxx');
$log->AddSortParam('model_name');
$log->AddSortParam('comp_name');
$log->AddDBParam('d_access',$range);
$log ->AddDBParam('-lop', 'or');
$logResult=$log->FMFind();

When I run this page, I get no results with the date range above...

Shouldn't this find records properly? If I change the date range to

"01/01/2008...01/28/2008"

it works properly...

Thanks,

Bob




More information about the FX.php_List mailing list