Hello,

Does anyone have much experience using sqlalchemy with stored
procedures on mssql?
I'm trying to use bind params with text() in a query and it doesn't
seem to like them

ie, i try running:
s = sql.text("""DECLARE @res INT; exec @res = LOGINS_ID :x ; select
@res;""")
and then:
Session.execute(s, x='abc')
which results in:
TypeError: get_bind() got an unexpected keyword argument 'x'

Am I doing anything particularly wrong?

If I just manually type in 'abc' instead of :x the query returns
successfully.  This is using pymssql.

Thanks,
Damian

--

You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@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=.


Reply via email to