[Zope] connet to MS-SQL database with ython script from with in zope

mbagepll@memphis.edu mbagepll@memphis.edu
Mon, 18 Feb 2002 12:58:46 -0600


This is a multi-part message in MIME format.

----5ed8126579007888
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi Tim,
I did exactly as you told me to do. The following is the python script

         sql="Select * from LinkArea"
         results = container.sql_method(the_sql=sql)
         for i in results:
              print i
         return printed

and below is the ZSQL method:
<dtml-var the_sql>

when i do this, it gives me the instances, something like this..
<r instance at 01674978>
<r instance at 015DAED0>
<r instance at 01674978>
<r instance at 015DAED0>

I do not understand this.

--madhavi

----5ed8126579007888
Content-Type: text/x-vcard; name="mbagepll.vcf"; charset=us-ascii
Content-Disposition: attachment; filename="mbagepll.vcf
Content-Description: Card for <mbagepll@memphis.edu>
Content-Transfer-Encoding: 7bit

begin:vcard
n:Bagepalli;Madhavi
tel;home:901-452-8078
tel;work:901-678-1659
org:The University of Memphis;Academic Systems
adr:;;3570 Mynders, Apt # 12;Memphis;TN ;38111;USA
version:2.1
email;internet:mbagepll@memphis.edu
title:Graduate Assistant
end:vcard


----5ed8126579007888--