I'm new to SQLAlchemy (and Python in general) and have been struggling to get a basic execution wrapper working - the goal is to use of raw batches of parameterized SQL - no ORM.
The engine initializes and I can run queries through it without a problem, however the generated SQL from the execute statement seems to interpret everything as string data. The line: engine.execute(text("select result = dateadd(day, :days, getdate())"), dict(days = 7)) ...yields the following error: ProgrammingError: (ProgrammingError) ('42000', '[42000] [FreeTDS][SQL Server]Argument data type varchar is invalid for argument 2 of dateadd function. (8116) (SQLPrepare)') 'select result = dateadd(day, ?, getdate())' [7] Am I overlooking something simple here? Is there a way to have the engine substitute parameters as per the Python datatype? Thanks for any feedback! --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---