You've probably already heard this by now, but there's an API way to create a ZSQLMethod. I don't know why, but the Zope book calls this "ZSQLMethod", while it appears to be called SQL in the actual Zope Source. Here's an example snipped out of my current project. I know the "import SQL as ZSQLMethod" is kind of weird -- I did that because I had already typed ZSQLMethod a whole bunch of times, and wasn't sure which was the "right" name. This code works, though. dbc = 'NaryaDB' # from Products.ZSQLMethods.SQL import SQL as ZSQLMethod #--------------------------------------------------------------------- getPostByNum = ZSQLMethod('addThreadStatus', 'Get a particular post', dbc, "number", """ SELECT post.username, post.post_time, post.postnum, post.body, user.tagline, user.avatar, user.nrecent, user.nposts, user.signature, user.www FROM post, user WHERE post.postnum = <dtml-sqlvar number type="int"> """ ) That's: <method-object> = ZSQLMethod(<method-id>, <method-title>, <DB-connection>, <method-arguments (no commas!)>, <method-ZSQL code>) Note that this creates the object -- I have this assigned as a class method in a Zope Product. I.e. it is assigned here in a module "ZSQLRead", then I assign from the module to the class method: import ZSQLRead class my_folderish_product(Folder): # ... lots of other stuff ... getPostByNum = ZSQLRead.getPostByNum' # ... lots more stuff ... You can call this from the web or from other Zope objects, just as if it were contained in the folder, but it doesn't appear in the mgmt interface and is not alterable. It also will automatically be updated when the product is changed, and it will exist for any number of actual instances of the product. If you want to see it in the management interface, you'll want to use "manage_addZSQLMethod(...)" instead. (But I don't explain that because I didn't do it that way -- it is mentioned in the Zope book as something like: object.manage_addZSQLMethod(<id>,<title>,<connection>,<args>,<ZSQL>) analogous to the above). The book calls this the "ZSQLMethod" class, so I had assumed the constructor would be invoked by "ZSQLMethod()", but I couldn't get that to work without the weird import ... as (This is Zope 2.5.1). Sorry if this is redundant, but I wanted to reply before I lost this message and forgot about it. :-) -- ------------------------------------------------------ Terry Hancock hancock@anansispaceworks.com Anansi Spaceworks http://www.anansispaceworks.com P.O. Box 60583 Pasadena, CA 91116-6583 ------------------------------------------------------