Create a dtml method called sql_doc, this is almost identical to pups code with a couple of changes. You will want to replace the string YOUR_FOLDER_HERE with the actual name of the top level zope folder that hold your zsql.

&dtml.-newid; (&dtml.-title_or_id;)

Max Rows:

/ Max Cache:

/ Cache Time:

/ Class:

/ Class File:

/ Direct:

Then create another dtml method called sql_map with the following code. Notice that sql_doc is hardcoded to reference the above method, change to reference what ever you called the first method.

()