[FX.php List] Date range query

Anders Monsen andersm at alamark.com
Fri Jan 16 13:38:00 MST 2009


Thanks. I had tried urlencode. Now it seems to work right.

--
Anders


On Jan 16, 2009, at 2:03 PM, Gareth Evans wrote:

> 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
>
> _______________________________________________
> 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