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

Groups > comp.lang.python > #55086

Re: fetchall to python lists

Show all headers | View raw

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!!!

Back to comp.lang.python | Previous | Next — Previous 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