[FX.php List] Date range query

Anders Monsen andersm at alamark.com
Fri Jan 16 12:52:45 MST 2009


I'm trying to search for records using a date range, but after running  
the date through a function to change it from DD-MM-YYYY to MM/DD/YYYY  
(as returned from javascript calendar), the range echos to the screen  
like this:

WDate=1%2F1%2F2009...01%2F23%2F2009

This returns error 401, even though I know there are records in the  
range from 1/1/2009...1/23/2009

Do I need some special encoding prior to sending the query?

from: 1/1/2009
to: 01/23/2009

$fmReg->AddDBParam('WDate',$fromDate . '...' . $toDate);

Thanks,
Anders Monsen


More information about the FX.php_List mailing list