Hi,
Yesterday I was searching this group and the SA 5.0 doc to get something working. Somewere I came across an option to specify the columnames to return (and getting a tuple or so) Let me explain: Keep the following in mind: I have a table which stores files defined with Declarative_base: Class file(Base): __tablename__ = "sometable" Id = Column(Integer, primary_key=True) Filename = Column(String(255), index=True) Permissions = Column(Integer) Store = Column(Someblobtype) Now I need to build a query which results in the following information in any form: Filename, permissions and the "size of" Store I think I need func from sqlalchemy.sql but whatever I try I cannot find any sizeof or alike, I know MySQL has something like that. To build a list of files (in realality it is a store for a webdav server and I greatly simplified this example, I need this since listing a "directory" causes Martijn --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---