[kronolith] Kronolith2.0.5 + oracle 10g

samer khalil samerk1 at gmail.com
Sun Nov 20 23:52:40 PST 2005


I know, there is no event_id in the querry, allthough the event ID (the
serial) shows in calendar_id field ! while calendar_id should point to the
username.
 Please correct me if i am rong.
Does anyone have a Kronolith 2.0.5 working fine with Oracle 10g ?
 thanks Samer

 On 11/19/05, Chuck Hagenbuch <chuck at horde.org> wrote:
>
> Quoting samer khalil <samerk1 at gmail.com>:
>
> > SELECT event_id, event_uid, event_description, event_location,
> event_status,
> > event_attendees, event_keywords, event_title, event_category,
> > event_recurtype, event_recurenddate, event_recurinterval,
> event_recurdays,
> > event_start, event_end, event_alarm, event_modified, event_exceptions,
> > event_creator_id FROM kronolith_events
> > WHERE
> > calendar_id = '02b026cb5f21d43b4ade38a2ecb5c3f7'
> > and ((event_end > '2005-10-30 00:00:00'
> > AND event_start < '2005-12-0500:00:00')
> > OR (event_recurenddate >= '2005-10-30 00:00:00'
> > AND event_start <= '2005-12-05 00:00:00'
> > AND event_recurtype <> 0))
> >
> > The begining of the clause condition should be "where event_id='.....'
> and
> > calendar_id shoulb be equal to the user.
> > Also the event_id '02b026cb5f21d43b4ade38a2ecb5c3f7' doesn't exist in my
> > database!
>
> There is no event_id in the query WHERE at all. You mean calendar_id?
>
> -chuck
>
> --
> "So we're talking near-sonic speeds for a vegetable."
> Reasons to go to the Punkin Chunkin World Championships
> --
> Kronolith mailing list - Join the hunt:
> http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>



--
Samer Khalil
Unix System administrator


More information about the kronolith mailing list