Hi,
I'm porting the calendar module. When I was testing out the calendar
by adding an event on a particular date from a particular start time
to a particular end time (say, 11/09/01 from 01:00 to 02:00), when i
submit it, both the display start time and end time
always turn
out to be 00:00 to 00:00.
This is the query (from cal-item-postgresql.xql) that I suspect might
have went wrong:
select to_char(start_date, 'MM/DD/YYYY') as start_date,
to_char(start_date, 'HH24:MI') as start_time,
to_char(end_date, 'HH24:MI') as end_time,
coalesce(a. name, e.name) as name,
coalesce(e.description, a.description) as description
from acs_activities a,
acs_events e,
timespans s,
time_intervals t
where e.timespan_id = s.timespan_id
and s.interval_id = t.interval_id
and e.activity_id = a.activity_id
and e.event_id = :cal_item_id
I had been trying to find out what went wrong for a long time, will
anyone be able to help me on this issue?
