[sqlalchemy] Re: Colon Errors with Explicit SQL Queries

2007-07-10 Thread Moses Ting
Thanks for the quick response Mike. Now I'm interested in finding out how to use the ':' as a bind parameter, where is it stated in the documentation? On Jul 10, 11:25 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Jul 10, 2007, at 11:21 AM, Moses Ting wrote: > >

[sqlalchemy] Colon Errors with Explicit SQL Queries

2007-07-10 Thread Moses Ting
Anyone having problems (or know how the remedy) to the following issue with using a colon in your custom SQL statement: SQL = """ select * from mytable where timestamp > '2007-07-07 00:05:00'; """ result = engine.text(sql).execute() It returns the following error: