See: http://lists.zope.org/pipermail/zpt/2001-December/002553.html For example code on converting your zsql method results to a dictionary. Scott -----Original Message----- From: Jeff Sacksteder [mailto:jwsacksteder@ramprecision.com] Sent: Tuesday, September 24, 2002 5:31 AM To: 'Julián Muñoz' Cc: 'zope@zope.org' Subject: RE: [Zope] ZODBC and dictionaties If you want to access the results of ZSQL queries from an ODBC connection, you will have to access them positionally. if your results are in a variable called result_set you can do something like this to list the contents of the first three columns for each row. for row in result_set: print row[0],row[1],row[2] An ugly workaround, but it works. Additionally, the odbc module is single threaded, so if you have a large query that takes two minutes to run, everyone else is blocked until it completes. -----Original Message----- From: Julián Muñoz [mailto:jmunoz@telefonica.net] Sent: Tuesday, September 24, 2002 8:21 AM To: Oliver Marx Cc: zope@zope.org Subject: Re: [Zope] ZODBC and dictionaties Some people use FreeTDS to connecto to Microsoft SQL Server On Sun, 22 Sep 2002, Oliver Marx wrote:
Dear List
I need to use Zope with an SQL server, but but but ZODBC which seems to be the standard DA for SQL server doesn't support dictionaries. Is there a proven solution to this problem?
\Oliver
__o _ \<_ (_)/(_) Saludos de Julián -.- DVD-record Tools for linux http://www.freesoftware.fsf.org/dvdrtools/ _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.