[FX.php List] Query Question

Jason LEWIS jasonlewis at weber.edu
Thu Sep 7 18:28:14 MDT 2006


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


More information about the FX.php_List mailing list