Re: [sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Dan
Yes, column_literal did the trick. So this is what I have function_call = select([column('table_id'),column('widget_type'),column('effective_date'),column('widget_id')], from_obj=[func.some_user_defined_function('2013-12-01', literal_column("DEFAULT"), '1', 1550,

Re: [sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Michael Bayer
On Dec 30, 2013, at 7:12 PM, Dan wrote: > Hello, > > I have been trying to find the appropriate syntax to query from a user > defined function. I am dealing with a SQL Server 2008 database, and I am > using sqlalchemy 0.8.4 with pyodbc 3.0.7. The machine the python app is > running on is Win

[sqlalchemy] Re: Querying from MS SQL Server functions

2013-12-30 Thread Dan
Nevermind about question 2. I really thought I was using parameters that would return something. Apparently not. However, question 2 still remains. --Dan On Monday, December 30, 2013 7:12:04 PM UTC-5, Dan wrote: > > Hello, > > I have been trying to find the appropriate syntax to query from a use

[sqlalchemy] SQLAlchemy 0.9.0 Released

2013-12-30 Thread Michael Bayer
Hey list - SQLAlchemy release 0.9.0 is now available. After about a year's worth of development, 0.9.0 is the first official release of the 0.9 series of SQLAlchemy. As always, 0.9 includes many major architectural improvements and new features. To get an overview of SQLAlchemy 0.9's new featu

[sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Dan
Hello, I have been trying to find the appropriate syntax to query from a user defined function. I am dealing with a SQL Server 2008 database, and I am using sqlalchemy 0.8.4 with pyodbc 3.0.7. The machine the python app is running on is Windows 7 64 bit, but I am using 32 bit python. I followed