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

DC dan.cynosure at dbmscan.com
Wed May 9 09:33:56 MDT 2007


yes, gjermund can be quite oracular sometimes.

so, um, what is left in the fmp field after the fx.php find is done?

dan

Roger Price had written:
> 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 <mailto:dan.cynosure at dbmscan.com>>
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org 
> <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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