[Zope-DB] ZSQL Method dictionaries() failing - Please help!

jwsacksteder@ramprecision.com jwsacksteder@ramprecision.com
Tue, 20 May 2003 11:27:59 -0400

> I connecting to a MS SQL Server using ODBC on Win2000. 


> On the other hand, to get the contents of the table 'holidays', when I
> execute context.getHolidays().dictoinaries(), I get -
> Error Type: AttributeError
> Error Value: DatabaseResults instance has no attribute 'dictionaries'

ZODBCDA does not support dictionaries.
See the following posts.


and more irritatingly...


You can still access your results ordinally by position- 

for row in dataset:
   print row[0]

will print the 1st column of each row by position, not name. It works, but
you must be careful to preserve the order of your result columns. Two other
ways to get data from ms-sql are mxODBC(commercial) or the remote ODBC DA
included in Zdataquerykit.