[kronolith] configuring kronolith for use w/ sql
Dan Wilson
dan@acucore.com
Thu, 15 Nov 2001 11:36:43 -0700
Quoting Chuck Hagenbuch <chuck@horde.org>:
> Quoting Liam Hoekenga <liamr@umich.edu>:
>
> > > SELECT DISTINCT e.event_id FROM
> > > kronolith_events WHERE calendar_id = 'liamr'
> > > AND event_start >= {ts '2001-09-01 00:00:00.000'}
> > > AND (event_end <= {ts '2001-09-30 23:59:59.999'}
> > > OR (event_recurEnddate <= {ts '2001-09-30 23:59:59.999'}
> > > AND event_recurType != 0))
> >
> > I couldn't execute the sql from sqlplus either:
> >
> > ORA-00911: invalid character
>
> I've taken the {ts...} stuff out; it seems to work for postgres, mysql (?
> Jan?), and mssql that way. Can you try it in Oracle?
>
> Also, if you're still having column case problems, have heart; some work has
>
> been done on fixing it at the PEAR level, although it ran into a bunch of
> trouble - see the pear list archives.
>
> -chuck
OK... I updated from CVS, but now I get the following error:
Fatal error: Failed opening
required '/home/dan/public_html/horde/config/../kronolith/templates/javascript/d
elete.inc' (include_path='.:/usr/local/lib/php')
in /home/dan/public_html/horde/kronolith/month.php on line 47
I'm sure this is from Jan's addition of the javascript delete confirmation, but
why didn't my cvs update grab it?
-Dan