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

[Jonathan Schwartz]

Bob,

Hmmm.. that's odd.

One has to assume that there are records that fit the original dates, right?

Have you looked at the url with Debug and also echo'd errorCode and 
foundCount for clues?

J

At 12:33 PM -0600 1/29/08, Bob Patin wrote:
>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
>
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-381-1852