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
--
https://mail.python.org/mailman/listinfo/python-list
