[FX.php List] Query Question

Andy Gaunt andy at fmpug.com
Fri Sep 8 15:33:36 MDT 2006


FMSA8.0v4

Date range searches such as '01/01/2006...09/08/2006'

Also using two variables such as $startDate .'...'.$endDate

Both work no problem at all

Andy Gaunt
Office: 321.206.3658
Mobile: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

2006 FileMaker Excellence Award Winner
Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of DC
Sent: Friday, September 08, 2006 5:26 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Query Question

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




More information about the FX.php_List mailing list