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

[Cary O'Brien]

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

> 
> Why don't you create a ZClass and make the ZSQLMethod to be one of its
> methods? Then the ZClass can provide the user interface to the SQL
> query and the result set.
> 
> Regards,
> Ivan Raikov
> 
> "Cary O'Brien" <cobrien@Radix.Net> writes:
> 
> > I want to wrap a presentation layer around ZSQLQueries, so that
> > they will have methods to generate an input form [1] for the query,
> > and generate tabular results if so desired.
> > 
> > I tried to create a ZClass to do this, but I can't subclass from a
> > ZSQLMethod.
> > 
> > Any other ideas on how to do this (besides a class where you have
> > to tell it the ZSQLMethod to use)?
> > 
> > -- cary
> > 
> > [1] Using sql.arguments_str to find out the arguments.  Finding THAT was
> >     a struggle!  
> > 
> > 
>