But how do I get the connection id ?
Actually I get it when I instance the product in Zope.
What I think is something like
class Foo
def __init__ (self, conn):
self.conn = conn
myquery = SQL ('doMyQuery', '', self.conn, '', 'select * from table')
but obviously it will not work.
TIA,
ngw
p.s. Sorry for top-posting
Marco Bizzarri <[EMAIL PROTECTED]> ha scritto:
Marco Bizzarri <[EMAIL PROTECTED]> ha scritto:
I can't talk for best practise. You can put your queries also outside of
the init, in this way:
class YourProduct:
_my_query = SQL('doMyQuery', '',
'your_connection', '', 'select * from data')
def __init__(self):
pass
Also, if you have a *LOT* of queries, consider in building your query on
the fly.
Yahoo! Mail: gratis 1GB per i messaggi, antispam, antivirus, POP3
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )