[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