[Zope] ZODBC and dictionaties

Meilicke, Scott scott.meilicke@intp.com
Tue, 24 Sep 2002 08:58:14 -0700


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=E1n Mu=F1oz'
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=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 )

_______________________________________________
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 )
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.