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
-~----------~----~----~----~------~----~------~--~---

Reply via email to