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