Cameron, Cool! I knew it was going to be easy. Thanks :-) BTW, I noticed that once you get an instance of the object, you *can* read the attributes (which of course correspond to the columns from the SQL query), but it doesn't let me change the values unless I create "wrapper methods" inside the class. Is that a Zope security thing, bug, unimplemented feature... do you know? Thanks, Julian
I was wondering if somebody has a handy example on how to use pluggable brains inside python scripts. For the most part I've only seen the sample in which you have a class:
class MyDataClass: def getSomething(self): return self.field1 + self.field2
and then you have a DTML method that goes something like
<dtml-in myquery> <dtml-var getSomething> </dtml-in>
How would I access the MyDataClass if I were to write a python script rather than a DTML method?
Untested, but it should look very similar to this: for elt in context.myquery(parameter1="dog", parameter2="goose"): print elt.getSomething() The parameters are those of the ZSQL Method, if any. The example above assumes two dummy parameters. Depending on your architecture, 'context' might be 'container' or another variable. It might also be written like for elt in context.myquery(REQUEST=REQUEST): print elt.getSomething() if you're getting your parameters from the HTTP request. --jcc