[FX.php List] Query Question

[Gjermund Gusland Thorsen]

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
>