[FX.php List] Query Question

[Dale Bengston]

I have a solution that was started on v7 FMSA, finished on v8FMSA and  
deployed live on v8 FMSA. It uses ... in date ranges no problem.

Dale

On Sep 8, 2006, at 4:25 PM, DC wrote:

> Me too. Can anyone using the latest FMSA7 or 8 confirm that date  
> ranges specified by the dot dot dot range string work?
>
> That is, without doing the funky workaround proffered by ggt earlier?
>
> best,
> dan
>
> Derrick Fogle had written:
>> OK, since I haven't run across this myself yet, I'd like to ask  
>> the  list for some clarification on this issue. I'm under the  
>> impression  that there really is a glitch in the FM7SA XML query  
>> that keeps date  range searches like "9/8/2006...9/10/2006" from  
>> working correctly.  But I don't understand what difference these  
>> two approaches make the  FMP's XML query:
>> This works? -
>>> $dateRange = date("n/j/Y", $startDate) . '...' . date("n/j/Y",
>>> $endDate);
>>> $query->AddDBParam ('Event_Date', $dateRange);
>> This doesn't work? -
>>> $query->AddDBParam ('Event_Date', date("n/j/Y", $startDate) .   
>>> '...' . date("n/j/Y",  $endDate));
>> Sorry, that just doesn't make a lot of sense. By the time the  
>> data  gets submitted to FM7SA's XML interface, the string should  
>> be exactly  the same one way or the other. Did one of the FM7SA  
>> updates fix the  XML query bug? Or is there something in FX.php  
>> that mangles the  concatenation embedded in the AddDBParam  
>> statement vs. the pre- concatenated text presented in a single  
>> variable?
>> Someone please help me understand.
>> Thanks,
>> On Sep 8, 2006, at 9:36 AM, Alicia M. Cosenza wrote:
>>> Hello,
>>>
>>> As it turns out I had a small php error when I made the $eventrange
>>> statement and it was causing the error.  So it does work.  Sorry   
>>> for the
>>> confusion.
>>>
>>> Thanks for the help,
>>>
>>> Alicia Cosenza
>>>
>>> -----Original Message-----
>>> From: fx.php_list-bounces at mail.iviking.org
>>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jason  
>>> LEWIS
>>> Sent: Thursday, September 07, 2006 8:28 PM
>>> To: FX.php Discussion List
>>> Subject: Re: [FX.php List] Query Question
>>>
>>> I am currently on FMP4.  The date range search on this version works
>>> with three periods or two periods.  I don't have FM7SA to test,  
>>> but is
>>> this a possibility?
>>>
>>> Jason
>>>
>>>>>> Chris Hansen <chris at iViking.org> 09/07/2006 2:58 PM >>>
>>>
>>> Hello,
>>>
>>> Actually, you should be able to you the syntax that you'd use in
>>> FileMaker, too:
>>>
>>> $dateRange = date("n/j/Y", $startDate) . '...' . date("n/j/Y",
>>> $endDate);
>>> $query->AddDBParam ('Event_Date', $dateRange);
>>>
>>> Note that there are other work-arounds, but my guess is that this
>>> syntax would be faster.  HTH
>>>
>>> --Chris Hansen
>>>    FileMaker 7 Certified Developer
>>>    Creator of FX.php
>>>    "The best way from FileMaker to the Web."
>>>    www.iViking.org
>>>
>>>
>>> On Sep 7, 2006, at 2:27 PM, Gjermund Gusland Thorsen wrote:
>>>
>>>> The work around I know of for FileMaker 7 and up is to have two
>>>
>>> fields
>>>
>>>> with the same dates in them.
>>>> Do not make a calculation field, make sure you enter the same date
>>>
>>> in
>>>
>>>> each field instead.
>>>>
>>>> $query->AddDBParam ('Event_Date', date("n/j/Y", $startDate),  
>>>> 'gte');
>>>> $query->AddDBParam ('Event_DateStupidWorkAroundField', date("n/j/ 
>>>> Y",
>>>> $endDate), 'lte');
>>>>
>>>> This is due to a limitation in the FileMaker XML query.
>>>>
>>>> ggt667
>>>>
>>>> On 9/7/06, Alicia M. Cosenza <aliciamc at dso.ufl.edu> wrote:
>>>>
>>>>> Yeah I appreciate it.
>>>>>
>>>>> Alicia Cosenza
>>>>>
>>>>> -----Original Message-----
>>>>> From: fx.php_list-bounces at mail.iviking.org
>>>>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Derrick
>>>
>>>
>>>>> Fogle
>>>>> Sent: Thursday, September 07, 2006 12:38 PM
>>>>> To: FX.php Discussion List
>>>>> Subject: Re: [FX.php List] Query Question
>>>>>
>>>>> Yeah, sorry, just a quick attempt to help without knowing which
>>>>> version you're on. Maybe Gjermund can help you.
>>>>>
>>>>> On Sep 7, 2006, at 11:35 AM, Alicia M. Cosenza wrote:
>>>>>
>>>>>> Yeah I'm on FM 7.  It's not working for me.
>>>>>
>>>>>
>>>>>
>>>>> Derrick Fogle
>>>>> derrick at fogles.net
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>> _______________________________________________
>>> 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
>> Derrick Fogle
>> derrick at fogles.net
>> _______________________________________________
>> 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