[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