[Zope] Why can't I subclass a ZSQLMethod?

[Ivan Raikov]

What do you mean, you cannot get a view to it? I can change in the
management area. I believe ZSQL methods are not supposed to provide
the user interface; you use them the way you would use an external
method. That means you have to create the form that sends the query
parameters to the SQL method, and you have to write the DTML code that
obtains the result set, and displays it accordingly.

At least that's way I do it; there might be a better way, I don't
know. 

Best,
Ivan

"Cary O'Brien" <cobrien@Radix.Net> writes:

> I tried that.  You can't add a ZSQLMethod unless there is a connection
> for it to connect to.  There isn't a connection in the products area.
> 
> Actually....
> 
> If I put a dummy gadfly connection in the Product folder, I can
> indeed add a zsql method to my ZClass.  However I can't get a
> view to it.  I can configure it as a view, but it doesn't show
> up in the management tabs.
> 
> I guess it may be possible to leave it invisible and use
> other methods to set the query, arguments, and database
> connection.  More digging through the .py files!
> 
> -- cary
>