[kronolith] configuring kronolith for use w/ sql

[Jan Schneider]

Zitat von 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?

That's the standard way in mysql. And it works.

Jan.

:::::::::::::::::::::::::::::::::::::::: 
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::