On Thu, Nov 23, 2006 at 12:07:07PM +0100, Cameron Yule wrote:
> Hi. I'm attempting to return a result set which filters Pages by their
> active state and their start/end date. Whilst the code I have at the
> moment is doing this without problem, some of the Page items may not
> have an end date set and I can't see a way of conditionally doing the
> query so these are not excluded.
>
[..]
> The problem being that I can't figure out how to do the equivalent of:
>
> search_end_date:( IS NULL OR >= #{Time.now.strftime("%Y%m%d")}
> )",
indexing some special value like 99999999 for the end_date of records
not having an end data could to the trick.
Jens
--
webit! Gesellschaft für neue Medien mbH www.webit.de
Dipl.-Wirtschaftsingenieur Jens Krämer [EMAIL PROTECTED]
Schnorrstraße 76 Tel +49 351 46766 0
D-01069 Dresden Fax +49 351 46766 66
_______________________________________________
Ferret-talk mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/ferret-talk
