> while not rs.EOF: > print rs.Fields("FieldName1") > rs.MoveNext() > >
This isn't working for me either. Same error about error: (-2147352567, 'Exception occurred.', (0, 'ADODB.Recordset', 'Operation is not allowed when the object is closed.', 'C:\\WINDOWS\\HELP\\ADO270.CHM', 1240653, -2146824584), None) >>> the object being closed. I'm not sure why it thinks that. If I print rs it describes an instance etc. and my result value from (rs, result) is 35 which is exactly the number of records updated by the query. Could it have something to do with the fact that the query updates another table? Do I need to look at that table? Is that why rs is empty or closed. Bizarre. Phill _______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32