-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

thanks werner, but i was asking about a generic query (not about one table)

alex

Werner F. Bruhin wrote:
| Alex,
|
| alex bodnaru wrote:
|> -----BEGIN PGP SIGNED MESSAGE-----
|> Hash: SHA1
|>
|>
|> hello friends,
|>
|> as opposed to a table.query() that returns a list of records of that table, 
with
|> fields accessible as record attributes, a select() statement returns a list 
of
|> tuples with the values of the fields in the virtual record.
|>
|> i'd like to access the fields by their column name or label, at least the non
|> calculated or labelled ones. it would suffice to be able to retrieve a list 
with
|> the labels of the fields in the resulted tuples.
|>
|> could you point me in the right direction?
|>
| No expert, so take this with a grain of salt.
|
| q = db.Quality.__table__.select()
| print q
| print dir(q)
| print q.columns
|
| q.columns is giving the column names as a list
|
| Werner
|
| |
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQCVAwUBSGIzI9pwN1sq38njAQKqoQP/VaLmQ87HFKc8At/iuMAk3PdWsJqBvOdi
HLveRI+FGZPEr/ICezW0YzVtXjTiAqPees5j/6PjMsoHeY4AEJKSTCpCBEwCQSdY
lcnyXrdg0cram1uhSItnLSyQslgQAPvAANQEv5AgJlh1garw/3O1h+yWi4kgqswO
mYAClwKrBxE=
=N3xj
-----END PGP SIGNATURE-----

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to