Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #55081

fetchall to python lists

Show all headers | View raw

Hi - I have some basic programming experience and new to Python. I have connected to SQL Server as follows:

import pyodbc
conn = pyodbc.connect('DSN=DBC')
cursor = conn.cursor()
cursor.execute("select measure,fin_year_no,fin_week_no,location_no,value from actual")
result=cursor.fetchall()

result looks like this:



result[0] - ('2013', 2014, 7, 242, 96064.35)
result[1] - ('2013', 2014, 7, 502, 18444.2)
.... approximately 2m records

Is there a way to assign the values of result to 5 lists without doing 5 select statments one for each of the colums and then assigning it to a list so that:

list1[0] = '2013'
list1[1] = 2014
list1[2] = 7
list1[3] = 242
list1[4] = 96064.35

list2[0] = '2013'
list2[1] = 2014
list2[2] = 7
list2[3] = 502
list2[4] = 18444.2

and so on ...

Hope someone can help. Regards Jerome

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

fetchall to python lists christensen.jerome@gmail.com - 2013-09-30 07:58 -0700
  Re: fetchall to python lists Joel Goldstick <joel.goldstick@gmail.com> - 2013-09-30 11:10 -0400
  Re: fetchall to python lists christensen.jerome@gmail.com - 2013-09-30 08:16 -0700

csiph-web