[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 )