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!