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