[Zope] ZODBC and dictionaties

Jeff Sacksteder jwsacksteder@ramprecision.com
Tue, 24 Sep 2002 08:30:56 -0400


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=E1n Mu=F1oz [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=E1n
-.-

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 -=20
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )