[Zope-CMF] FS ZSQL Method available

Chris Withers chrisw@nipltd.com
Tue, 11 Sep 2001 08:48:13 +0100


Norman Khine wrote:
> 
> Hello Chris,
> The product installs correctly, but is NOT shown in the drop-down product
> list, so mI am unable to added to my CMF.

Urm, add? What would you want to add?!

In the skins folder on the _filesystem_ add the following in a file called
'test.zsql':

<dtml-comment>
connection_id : test_db
arguments: test me now
max_cache: 1000
</dtml-comment>
show tables

...and make sure you have a DB connection called test_db connected to a MySQL
database somewhere the method can acquire it from ;-)

Required parameters are:

connection_id - the connection id

Optional ones are:

title      - the title of the ZSQL Method
arguments  - the space-seperated list of arguments for the ZSQL method
max_rows   - the maximum number of rows your query should return
             (default 1000)
max_cache  - the maximum number of rows to cache
             (default 100)
cache_time - the time to keep cached rows for
             (default 0)

cheers,

Chris