Forum OpenACS Development: Re: Multiday event support in OpenACS Calendar Application

Collapse
13: Re: Multiday event support in OpenACS Calendar Application (response to 12)
Posted by Emmanuelle Raffenne on 07/03/08 10:41 AM
oh I see, I missed that, sorry.

The query to retrieve events needs to be rewritten to get not only the events starting or ending in the day, but also, as you said, those that are in between. You can use the OVERLAPS operator to check that:

select (event_start_date,event_end_date) OVERLAPS (view_start_date,view_end_date);

See http://www.postgresql.org/docs/8.2/static/functions-datetime.html for more info.

Collapse
14: Re: Multiday event support in OpenACS Calendar Application (response to 13)
Posted by Poonam Gandhi on 07/03/08 12:35 PM
Hey thanks a ton !
It seems to be working. I would change all the queries to get the expected result. The only overhead would be validating "end date" against "start date"

Thanks again :)

Thanks and Regards,
Poonam