[FX.php List] Find record using 'date'

[Kevin Futter]

On 10/5/07 1:30 AM, "Roger Price" <rp272 at cam.ac.uk> wrote:

> Dan
>  
> I was a bit non-plussed by Gjermund's rather enigmatic comment "The formating
> of the date is essential " as it was not clear in which way - in the source or
> in the request or both - and how should the formatting be done?
>  
> I have pulled across the dates from my FMP database which seemed to arrive as
> 'dd/mm/yyyy' (which was how they had been entered) however when I send then in
> that format via an FX.php 'find' request with debug turned on it seems that
> they are being URL encoded. Could this be the problem?
>  
> Not having a solution I decided to 'find all' and manipulate the data with
> PHP. This didn't work as expected either and found that although I was
> entering 'dd/mm/yyyy' I was actually getting 'mm/dd/yyyy'.
>  
> Now I'm not sure what the problem is!
>  
> I have achieved my goal by 'brute force' with PHP but would still like to
> undersatnd how to craft a request in FX.php.
>  
> Dates do seem to be a bit of  a minefield.
>  
> kindest regards
>  
> Roger

Hi Roger,

We have a similar problem in that since upgrading to FMSA v8 for production
(which involved setting up an Xserve from scratch), our dates all come out
of the db in the US format, despite being entered into the database as
mm/dd/yyyy. For display purposes I just manipulate it with PHP, but I still
can¹t figure out why it¹s doing it, other than some mysterious server
setting (FM or OS X) that we neglected to configure at setup time.

Sorry I can¹t help, but I can at least sympathise!

Kevin

-- 
Kevin Futter
Webmaster, St. Bernard's College
http://www.sbc.melb.catholic.edu.au/


#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

This e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. The College does not guarantee that this e-mail is virus or error free.  The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this e-mail are not necessarily those of the College.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070510/e92d5bd8/attachment.html