[FX.php List] Query Question

Gjermund Gusland Thorsen ggt667 at gmail.com
Thu Sep 7 14:27:20 MDT 2006


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
>


More information about the FX.php_List mailing list