What's a better way to handle this in Python
<p>Simple problem, I have it solved .. but python has a million ways to solve the same problem. I don't want the most terse solution, I just want one that makes more sense than the following:</p>

<pre><code># sql query happens above, returns multiple rows
rows = cursor.fetchall()
cursor.close()
cntdict = {}
for row in rows:
 a, b, c = row[0], row[1], row[2]
 cntdict = {
  a : { "b":b, "c":c }
 }
print dict(cntdict)
</code></pre>

<p>note, a is always unique above. I want a dictionary created from the result set. Later on in my script I need to reference the values in the dictionary for each row that occurred. I'm trying to index the dictionary by making the key the value from the var a. that should point to another dictionary with two more key/value pairs that describe a... unless there's a smarter/shorter way to do it.</p>
