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

[Bob Patin]

I was just thinking the same thing... he's not known for long  
discourses, are you Gjermund? :)


On May 9, 2007, at 10:33 AM, DC wrote:

> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list