[sqlalchemy] Re: how to execute a scalar function in SQL Server

I must be doing something wrong here On Nov 3, 2:14 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Nov 3, 2008, at 5:10 PM, john.goodleaf wrote: > > > > > > > I'd like to map to a selectable, but that selectable should contain > > the result of

[sqlalchemy] how to execute a scalar function in SQL Server

I'd like to map to a selectable, but that selectable should contain the result of a scalar function. I'm unsure how best to accomplish it. In raw SQL, I'd write something like: select P.SubjectId, P.SubjectName, V.VariableName, D.RecordID, D.Data,

[sqlalchemy] Re: Mapping to views

l Bayer <[EMAIL PROTECTED]> wrote: > On Oct 24, 2008, at 11:41 AM, john.goodleaf wrote: > > > > > > > So here's the problem. I am faced with two legacy systems outside my > > control. One is SQL Server and the other is Oracle. In both only views > > are

[sqlalchemy] Mapping to views

So here's the problem. I am faced with two legacy systems outside my control. One is SQL Server and the other is Oracle. In both only views are exposed to me and I don't anticipate that changing. I'd like to map these views to objects. Of course, it's read-only so I'm not concerned with the other