[FX.php List] Date range query

Gareth Evans gareth.evans at schawk.com
Fri Jan 16 13:03:17 MST 2009


http://ca2.php.net/manual/en/function.urldecode.php

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

-- 
GARETH EVANS


> From: Anders Monsen <andersm at alamark.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Fri, 16 Jan 2009 13:52:45 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: [FX.php List] Date range query
> 
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list