Mike Driscoll wrote: > > > > On Jun 26, 5:49 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote: >> Mike wrote: >> >> > TypeError: 'Alias' object is unindexable >> >> that error means you're trying to say x['foo'] on something that doesn't >> have a __getitem__(). I don't see that here, can you send a stack trace >> which would reveal if this is being produced from within SQLAlchemy >> internals ? > > Oops...you're exactly right. I didn't copy and paste everything and > missed that piece. It appears to return some correct results, but not > all of them. When I run the straight SQL in MS SQL, I get additional > results. Do you have any insights as to why that might happen?
if you were querying for whole entities, it would only be able to give you an entity for each row that has a non-null primary key. since your query was for individual columns I dont see why that would happen. use echo='debug' on your engine to get more insight. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
