Index: openacs-4/packages/acs-templating/www/doc/demo/index.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/index.html,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-templating/www/doc/demo/index.html 17 May 2003 10:06:14 -0000 1.3 +++ openacs-4/packages/acs-templating/www/doc/demo/index.html 4 Feb 2006 19:09:15 -0000 1.4 @@ -300,6 +300,50 @@ +

Using ListBuilder

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
DescriptionDataTemplateCompiled
Template
Output
Simplest (single-column) list, no features + View .tcl
+ postgres query
+ oracle query +
+ No master
+ W/ master +
+ No master
+ W/ master +
+ No master
+ W/ master +
Add some columnsViewViewViewView
+

Forms

Index: openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,35 @@ + + + oracle8.1.6 + + + + select template_demo_note_id, title, body, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'write'), + 't', 1, + 'f', 0) as write_p, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'admin'), + 't', 1, + 'f', 0) as admin_p, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'delete'), + 't', 1, + 'f', 0) as delete_p + from template_demo_notes n, acs_objects o + where n.template_demo_note_id = o.object_id + and o.context_id = :package_id + and exists (select 1 + from acs_object_party_privilege_map + where object_id = template_demo_note_id + and party_id = :user_id + and privilege = 'read') + order by creation_date + + + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1a/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1a/index-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1a/index-postgresql.xql 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,22 @@ + + + postgresql7.1 + + + + + select + n.template_demo_note_id, + n.title + from template_demo_notes n, acs_objects o + where n.template_demo_note_id = o.object_id + and exists (select 1 + from acs_object_party_privilege_map + where object_id = template_demo_note_id + and party_id = :user_id + and privilege = 'read') + + + + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1a/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1a/index.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1a/index.adp 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,3 @@ + + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1a/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1a/index.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1a/index.tcl 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,25 @@ +# main index page for notes. + +ad_page_contract { + + @author rhs@mit.edu + @creation-date 2000-10-23 + @cvs-id $Id: index.tcl,v 1.1 2006/02/04 19:09:15 jiml Exp $ +} -properties { + notes:multirow +} + +set package_id [ad_conn package_id] +set user_id [ad_conn user_id] + +db_multirow template_demo_notes template_demo_notes {} + +template::list::create -name notes \ + -multirow template_demo_notes \ + -elements { + title { + label "Title of Note" + } + } + +ad_return_template Index: openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,35 @@ + + + oracle8.1.6 + + + + select template_demo_note_id, title, body, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'write'), + 't', 1, + 'f', 0) as write_p, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'admin'), + 't', 1, + 'f', 0) as admin_p, + decode(acs_permission.permission_p(template_demo_note_id, + :user_id, + 'delete'), + 't', 1, + 'f', 0) as delete_p + from template_demo_notes n, acs_objects o + where n.template_demo_note_id = o.object_id + and o.context_id = :package_id + and exists (select 1 + from acs_object_party_privilege_map + where object_id = template_demo_note_id + and party_id = :user_id + and privilege = 'read') + order by creation_date + + + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1b/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1b/index-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1b/index-postgresql.xql 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,22 @@ + + + postgresql7.1 + + + + + select + n.template_demo_note_id, + n.title + from template_demo_notes n, acs_objects o + where n.template_demo_note_id = o.object_id + and exists (select 1 + from acs_object_party_privilege_map + where object_id = template_demo_note_id + and party_id = :user_id + and privilege = 'read') + + + + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1b/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1b/index.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1b/index.adp 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,2 @@ + + Index: openacs-4/packages/acs-templating/www/doc/demo/list1b/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1b/index.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-templating/www/doc/demo/list1b/index.tcl 4 Feb 2006 19:09:15 -0000 1.1 @@ -0,0 +1,25 @@ +# main index page for notes. + +ad_page_contract { + + @author rhs@mit.edu + @creation-date 2000-10-23 + @cvs-id $Id: index.tcl,v 1.1 2006/02/04 19:09:15 jiml Exp $ +} -properties { + notes:multirow +} + +set package_id [ad_conn package_id] +set user_id [ad_conn user_id] + +db_multirow template_demo_notes template_demo_notes {} + +template::list::create -name notes \ + -multirow template_demo_notes \ + -elements { + title { + label "Title of Note" + } + } + +ad_return_template