[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