Not really a pywin32 related by I will bite :)
For every iteration of the while loop you have to create a new
dictionary, fill it up with data and append to the list.
I posted here because this has never happened to me before, only with the COM
object thrown in does it do this.
So I assumed it
I'm connecting to a MS SQL 2005 database using ADO com objects and getting a
dataset from a stored procedure -- Works great.
I'm placing that dataset into a dictionary -- works.
I'm placing that dictionary into a list -- problem!! When I move to the next
record in the dataset and place the
Does anyone have an idea why? I been trying to figure this out for
3 hours now.
You appear to be re-using the same dictionary for each record; allocate
a new one for each record before starting to populate it.
- These thoughts are mine alone! -
Andrew
On Thu, Jul 30, 2009 at 11:20 AM, Person, Roderickperso...@upmc.edu wrote:
I'm connecting to a MS SQL 2005 database using ADO com objects and getting a
dataset from a stored procedure -- Works great.
I'm placing that dataset into a dictionary -- works.
I'm placing that dictionary into a list