[FX.php List] Query Question

[Alicia M. Cosenza]

Yeah I'm on FM 7.  It's not working for me.

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 Gjermund
Gusland Thorsen
Sent: Thursday, September 07, 2006 12:27 PM
To: FX.php Discussion List
Subject: Re: Re: [FX.php List] Query Question

Derrick, that worked with FMU 5.0 -> 6.0,
and did not work with FM7SA,
does it work again now in 8.5?

ggt667

On 9/7/06, Derrick Fogle <derrick at fogles.net> wrote:
> query->AddDBParam ('Event_Date', date("n/j/Y", $startDate) . "..." .
> date("n/j/Y", $endDate));
>
>
> On Sep 7, 2006, at 11:13 AM, Alicia M. Cosenza wrote:
>
> > Hello,
> >
> > I need to select from my from my database based on a date range
> >
> > ie. All events between the dates 9/2/2006 to 9/14/2006
> >
> > I am unsure on how to do this with FX PHP.
> >
> > I have tried...
> >
> > $query->AddDBParam ('Event_Date', date("n/j/Y", $startDate), 'gte');
> > $query->AddDBParam ('Event_Date', date("n/j/Y", $endDate), 'lte');
> >
> > but it is not returning all the events in between.  I read something
> > earlier about using the '...' between two dates finds all the dates
in
> > that range but I do not know how to format it to work with
AddDBParam.
> >
> > Thanks for any help,
> >
> > Alicia Cosenza
> >
> > PS. Yes, I'm new to FX.php.
> >
> >
> > _______________________________________________
> > 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