Will this order at least be the same for that same query every time the script is executed?
On Thu, Jul 2, 2009 at 10:48 AM, Tim Chase <python.l...@tim.thechases.com>wrote: > sql = "SELECT player_id, SUM(K) AS K, SUM(IP) AS IP, SUM(ER) AS ER, SUM(HR) >> AS HR, SUM(H) AS H, SUM(BB) AS BB, Teams.league FROM Pitching INNER JOIN >> Teams ON Pitching.team = Teams.team_id WHERE Date BETWEEN '%s' AND '%s' >> GROUP BY player_id" % (start, date) >> cursor.execute(sql) >> >> for row in cursor.fetchall(): >> print row.keys() >> >> What I get is: >> >> ['league', 'BB', 'HR', 'IP', 'K', 'H', 'player_id', 'ER'] >> >> Neither alphabetical nor the order in which they were specified in the >> query >> nor... any seeming order I can suss out. Any ideas? Thanks! >> >> (cursor being a MySQLdb.cursors.DictCursor object.) >> > > My guess is you're experiencing the fact that dicts are unordered by nature > which allows it to return in any order it likes (usually per the internal > representation/storage). > > -tkc > > > > -- Wells Oliver we...@submute.net
-- http://mail.python.org/mailman/listinfo/python-list
