>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
On Thu, Jul 30, 2009 at 11:20 AM, Person, Roderick 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 -- problem!!
> 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 Mac
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 dicti
