Re: fetchall to python lists

2013-09-30 Thread christensen . jerome
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.execu

Re: fetchall to python lists

2013-09-30 Thread Joel Goldstick
On Mon, Sep 30, 2013 at 10:58 AM, 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_

fetchall to python lists

2013-09-30 Thread christensen . jerome
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() resul