[kronolith] configuring kronolith for use w/ sql

[Chuck Hagenbuch]

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

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be, lie, like children whose faces we cannot see, in the
arms of silence. All we ever have is here, now." - Ursula K. Le Guin