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

[Bob Patin]

On May 9, 2007, at 10:30 AM, Roger Price 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
>
>
> ----- Original Message -----
> From: "DC" <dan.cynosure at dbmscan.com>
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Sent: Wednesday, May 09, 2007 3:35 PM
> Subject: Re: [FX.php List] Find record using 'date'
>
> > did you try typing this by hand: "1/12/2006...24/12/2006"
> >
> > what is left in the fmp field after the PHP find request is done? do
> > "refind" command-R to see what FX.php sent to  FMP.
> >
> > dan
> >
> >
> > Gjermund Gusland Thorsen had written:
> >> The formating of the date is essential.
> >>
> >> ggt667
> >>
> >> On 5/9/07, Roger Price <rp272 at cam.ac.uk> wrote:
> >>>
> >>>
> >>> Just when I thought I was getting the hang of this...
> >>>
> >>> I have an FMP date field 'dd/mm/yyyy' and want to do a find  
> between a
> >>> range
> >>> of dates. It works when in native Filemaker but I get a zero  
> 'foundcount'
> >>> when I use FX.php.
> >>>
> >>> Is there some trick to this?
> >>>
> >>> TIA
> >>>
> >>> Roger
> >>> _______________________________________________
> >>> 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
> >>
> > _______________________________________________
> > 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070509/41033e3c/attachment.html