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

[Tim Hicks]

----- Original Message -----
From: <mbagepll@memphis.edu>
To: "Jim Washington" <jwashin@vt.edu>; <zope@zope.org>
Sent: Monday, February 18, 2002 4:23 PM
Subject: Re: [Zope] connet to MS-SQL database with ython script from with in
zope


> Hi Jim,
>
> Thank you very much. But i want to use Python scripts to write the sql
> queries and not ZSQL methods. I have my ZODBCA installed and have
> created a obdc connection to the MS-SQL database. Can i use this (i
> mean the connection object) some how in the python script and query the
> database.

I haven't followed the rest of this thread, so tell me if I'm way off the
mark.

I do this by having a ZSQL Method (say sqlMethod) that simply contains
<dtml-var the_sql> and has one argument (the_sql).  I then build my sql
statement within my python script and execute it like,

#generate the sql statement
results = container.sqlMethod(the_sql=generated_sql)
#do stuff with the results

I think there's a howto on www.zope.org somewhere, and a few previous posts
on this list too.  Have a scout around.

I'm sure there must be security issues to consider as well...

hth

tim