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:
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 348, in
_execute
sqlalchemy.exceptions.SQLError: (ProgrammingError) invalid input
syntax for type
timestamp with time zone: "2007-07-06 00NULLNULL"
"select halt_timestamp from maintenance_objectmessage where
halt_timestamp > '2
007-07-06 00%(00)s%(00)s';" {'00': None}
It's as if SQLAlchemy is using the colon symbol to pull in a
variable...
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
