<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Dieter Maurer wrote:
<blockquote cite="mid17238.42724.736998.327897@gargle.gargle.HOWL"
type="cite">
<pre wrap="">Vangelis Mihalopoulos wrote at 2005-10-19 12:22 +0300:
</pre>
<blockquote type="cite">
<pre wrap="">...
I am thinking of using a Z Database Connection (mysql) from within an
external method, without using Z SQL Methods, but can't figure out how i
can "safely" do it
</pre>
</blockquote>
<pre wrap=""><!---->
Calling a "DA" object gives you a low level connection object (a
"db" object). It has a "query" method. Calling it provides
"safe" SQL execution.
</pre>
</blockquote>
Thanks, this is what i had in mind.<br>
<blockquote cite="mid17238.42724.736998.327897@gargle.gargle.HOWL"
type="cite">
<pre wrap="">>From other posts, I understood that you want to do special things.
</pre>
</blockquote>
Yes, this is true.<br>
<blockquote cite="mid17238.42724.736998.327897@gargle.gargle.HOWL"
type="cite">
<pre wrap="">In such cases, reading the source is necessary</pre>
</blockquote>
Yes, i know. But this would take me much more time than sending an
email to the Zope list and getting quick help from experienced
Zopistas, time that i unfortunately cannot afford. Of course, reviewing
product code on other cases wasn't such a big overhead and i got my
task done.<br>
<blockquote cite="mid17238.42724.736998.327897@gargle.gargle.HOWL"
type="cite">
<pre wrap=""> -- and being prepared
that things may change between releases...
</pre>
</blockquote>
Of course... <span class="moz-smiley-s1"><span> :-) </span></span><br>
<blockquote cite="mid17238.42724.736998.327897@gargle.gargle.HOWL"
type="cite">
<pre wrap="">I follow the recommendation of others to use ZSQL methods...
</pre>
</blockquote>
I am loading the zodb in read-only mode. If someone breaks into Zope
(which btw i believe to be very secure) i don't want him to be able to
directly access (read/write) the database i am using. *AFAIK*,
ZSQLMethods won't do for this.<br>
<br>
<br>
Thanks for your comments, helpful as always!<br>
<br>
- Vangelis<br>
<br>
<br>
</body>
</html>