[DB-SIG] Multiple Fields in "Order by" Command
Casey Bralla
Casey at nerdworld.org
Wed Nov 24 01:56:44 CET 2004
I'm trying to sort my database by multiple fields. I have written a query
that says:
"select * from TABLE1 order by FIELD1 + FIELD2 + FIELD3"
Unfortunately, while I can sort by any single FIELD, I am unable to create the
multi-field sort I want to create. I've tried parentheses, using the "&"
sign, etc. I figure there's gotta be an easy way to do this... but I'll be
darned if I can find it in the docs or on-line.
Can somebody please point me in the right direction?
BTW, This list is wonderful! Thanks to J Kennedy, Jim Tittlser, Randall
Smith, Peter Mott, and Chris Cogdon for the help on the "fetchone()" and
"fetchmany()" python statements. With your help, I was able to solve my
problem, and I learned a bunch of stuff too. Thanks, guys!
--
Casey Bralla
Chief Nerd in Residence
The NerdWorld Organisation
More information about the DB-SIG
mailing list