Re: win32com and ADO

2005-05-11 Thread Chris Curvey
it was working fine before running makepy, once I ran makepy, I had to add the array index to make it work. -- http://mail.python.org/mailman/listinfo/python-list

Re: win32com and ADO

2005-05-11 Thread Peter Hansen
Chris Curvey wrote: > Achim, > > Bingo. The recordset is in item 0. And that appears to work even on > systems where makepy has not been run. > > Thanks so much. So was this not really something that was working *before* you ran makepy, or is there still an unsolved mystery there? -- http://

Re: win32com and ADO

2005-05-11 Thread Chris Curvey
Achim, Bingo. The recordset is in item 0. And that appears to work even on systems where makepy has not been run. Thanks so much. -- http://mail.python.org/mailman/listinfo/python-list

Re: win32com and ADO

2005-05-11 Thread Chris Curvey
Thanks Peter. I found the files that makepy generated (in $PYTHON_HOME/Lib/site-packages/win32com/gen_py). I've tried deleting the individual files, and the entire directory, and I'm still getting the error. (Maybe something was changed in the registry?) [Fun side note -- after deleting the fil

Re: win32com and ADO

2005-05-11 Thread Achim Domma (Procoders)
Chris Curvey wrote: > result = conn.execute("select * from foo") > > while not result.EOF: > doSomething() > result.MoveNext() > > 'tuple' object has no attribute EOF The recordset you are looking for is a element of the tuple. Out of my head I would say it's element 1, so you have to

Re: win32com and ADO

2005-05-11 Thread Peter Hansen
Chris Curvey wrote: > I'm having one of those weeks. > > I have this pattern all over my code. > > result = conn.execute("select * from foo") > > while not result.EOF: > doSomething() > result.MoveNext() > > So recently I got around to running makepy on all of the Microsoft > ActiveX Da

win32com and ADO

2005-05-11 Thread Chris Curvey
I'm having one of those weeks. I have this pattern all over my code. result = conn.execute("select * from foo") while not result.EOF: doSomething() result.MoveNext() So recently I got around to running makepy on all of the Microsoft ActiveX Data Objects, and now every call to that patte