ok thanks. I guess then if you're using the ZMI could you embed this in your ZPT? But I guess that is not best practice.<br><br><div><span class="gmail_quote">On 11/6/07, <b class="gmail_sendername">Andrew Milton</b> <
<a href="mailto:akm@theinternet.com.au">akm@theinternet.com.au</a>> wrote:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
+-------[ michael nt milne ]----------------------<br>| thanks. Is there an example or a tutorial at all on this anywhere?<br><br><br># queryConnection holds the id of a DA<br><br><br>connectionObject=getattr(self, queryConnection)
<br>connection = connectionObject()<br>results = connection.query(SQL_GOES_HERE)<br><br>This is from Product code, it should be usable (s/self/context/) in a<br>PythonScript, but, I haven't tested it.<br><br><br>--<br>
Andrew Milton<br><a href="mailto:akm@theinternet.com.au">akm@theinternet.com.au</a><br></blockquote></div><br><br clear="all"><br>-- <br>michael