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: > > > > > 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() > > just use engine.execute(sql). text() is going to treat :<symbol> as > a bind parameter, yes. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
