[Zope] Friday the 13th and date range search :-)

[Josef Meile]

I've already solved it. See my last reply.

Thanks anyway.

----- Original Message ----- 
From: "Lennart Regebro" <lennart@torped.se>
To: "Josef Meile" <jmeile@hotmail.com>; <zope@zope.org>
Sent: Tuesday, September 17, 2002 4:12 PM
Subject: Re: [Zope] Friday the 13th and date range search :-)


> Which version of Zope are you running?
> 
> ----- Original Message -----
> From: "Josef Meile" <jmeile@hotmail.com>
> To: <zope@zope.org>
> Sent: Thursday, September 12, 2002 3:37 PM
> Subject: [Zope] Friday the 13th and date range search :-)
> 
> 
> > Hi,
> > I'm doing a date range search on a Catalog and I'm getting
> > results that don't match the range. Before today, it had worked
> > perfectly, but when I introduce dates between the 12th and
> > 15th September it fails. Is it related with friday the 13th? :-)
> >
> > This is my code:
> >
> > id: searchInCatalog
> > Parameter List: date1, date2
> >
> > catalog=context.Catalog
> > return catalog(
> >          {
> >            'meta_type'       : 'EvDocDate',
> >            'event_date'      : [date1,date2],
> >            'event_date_usage': 'range:min:max',
> >            'sort_on'         : 'event_date',
> >          }
> >        )
> >
> >
> > I called it so:
> >
> > <dtml-let date1="'2002/09/12 8'" asDate1="_.DateTime(date1)"
> >           date2="'2002/09/12 13'" asDate2="_.DateTime(date2)"
> >           results="searchInCatalog(asDate1,asDate2)">
> >   from: <dtml-var asDate1> til: <dtml-var asDate2>
> >
> >   <dtml-in results>
> >     <dtml-let myObj="_['sequence-item']">
> >       <dtml-var "myObj.event_date">    <dtml-var
> > expr="(asDate1<=myObj.event_date) and (myObj.event_date<=asDate2)">
> >     </dtml-let>
> >   </dtml-in>
> > </dtml-let>
> >
> > And it prints:
> >
> > from: 2002/09/12 08:00:00 GMT+2 til: 2002/09/12 13:00:00 GMT+2
> >
> >                 2002/09/16 07:00:00 GMT+2    0
> >                 2002/09/16 07:00:00 GMT+2    0
> >                 2002/09/16 09:00:00 GMT+2    0
> >                 2002/09/16 09:00:00 GMT+2    0
> >                 2002/09/16 10:00:00 GMT+2    0
> >                 2002/09/16 10:00:00 GMT+2    0
> >                 2002/09/16 11:00:00 GMT+2    0
> >                 2002/09/16 11:00:00 GMT+2    0
> >                 2002/09/16 12:00:00 GMT+2    0
> >                 2002/09/16 12:00:00 GMT+2    0
> >
> > If you see the expresion "(asDate1<=myObj.event_date) and
> > (myObj.event_date<=asDate2)"
> > is allways false, then why is the catalog retuning this values? Does
> anybody
> > knows how to solve
> > it?
> >
> > Thanks in advanced,
> > Josef
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
>