[prev in list] [next in list] [prev in thread] [next in thread] 

List:       python-list
Subject:    Re: fetchall to python lists
From:       christensen.jerome () gmail ! com
Date:       2013-09-30 15:16:41
Message-ID: 96293b0a-3a98-4f23-a4cd-0229a15328ab () googlegroups ! com
[Download RAW message or body]

On Monday, September 30, 2013 4:58:25 PM UTC+2, christens...@gmail.com wrote:
> 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

Thanks Joel did not think it could be so simple!!!
-- 
https://mail.python.org/mailman/listinfo/python-list


[prev in list] [next in list] [prev in thread] [next in thread]