Working with Cursors

2012-04-17 Thread timlash
Searched the web and this forum without satisfaction. Using Python 2.7 and pyODBC on Windows XP I can get the code below to run and generate two cursors from two different databases without problems. Ideally, I'd then like to join these result cursors thusly: SELECT a.state, sum(b.Sales)

Re: Working with Cursors

2012-04-17 Thread Ian Kelly
On Tue, Apr 17, 2012 at 12:11 PM, timlash timl...@gmail.com wrote: Searched the web and this forum without satisfaction.  Using Python 2.7 and pyODBC on Windows XP I can get the code below to run and generate two cursors from two different databases without problems.  Ideally, I'd then like

Re: Working with Cursors

2012-04-17 Thread nn
On Apr 17, 2:11 pm, timlash timl...@gmail.com wrote: Searched the web and this forum without satisfaction.  Using Python 2.7 and pyODBC on Windows XP I can get the code below to run and generate two cursors from two different databases without problems.  Ideally, I'd then like to join these

Re: Working with Cursors

2012-04-17 Thread nn
On Apr 17, 2:11 pm, timlash timl...@gmail.com wrote: Searched the web and this forum without satisfaction.  Using Python 2.7 and pyODBC on Windows XP I can get the code below to run and generate two cursors from two different databases without problems.  Ideally, I'd then like to join these