vendor/CMF/1.5.2/docs

view FSZSQLMethods.stx @ 0:33c8dd739958

Vendor import of CMF 1.5.2
author fguillaume
date Wed, 20 Jul 2005 16:21:26 +0000
parents
children
line source
1 FS ZSQL Methods
3 This document describes how to use FS ZSQL Methods. These are
4 Z SQL Methods that form part of filesystem-based skin layers.
6 They behave identically to normal Z SQL Methods except that
7 their parameters are specified in a comment block in the
8 method's body. This comment block may appear anywhere, but
9 it is recommended you place it at the top of the body.
11 Here is a sample:
13 <dtml-comment>
14 Connection_id : my_db_connection
15 arguments: arg1 arg2 arg3
16 max_cache: 1000
17 max_rows: 0
18 cache_time: 0
19 </dtml-comment>
21 INSERT INTO
22 mytable
23 SET
24 col1 = <dtml-sqlvar arg1 type=int>,
25 col2 = <dtml-sqlvar arg2 type=string>,
26 col3 = <dtml-sqlvar arg3 type=int>
28 <dtml-var sql_delimiter>
30 SELECT LAST_INSERT_ID() as NEWID
32 The following list describes how the parameters in the
33 comment block map to the properties of a ZSQL Method:
35 FS ZSQL Method Z SQL Method
36 title Title
37 connection_id Connection Id
38 arguments Arguments
39 max_rows Maximum rows to retrieve
40 max_cache Maximum results to cache
41 cache_time Maximum time (sec) to cache
43 You cannot control the class used for the data records
44 with FS ZSQL Methods.
46 For further details, please see the documentation for
47 Z SQL Methods.