pa_clipboards_multirow (public)

 pa_clipboards_multirow [ -create_new ] [ -force_default ] user_id \
    datasource

Defined in packages/photo-album/tcl/photo-album-procs.tcl

creates a multirow datasource with the existing clipboards

Switches:

-create_new (optional, boolean)

add a "Create new folder" entry to list

-force_default (optional, boolean)

create the datasource with a default folder even if none exist

Parameters:

user_id (required)

the owner id for the folders

datasource (required)

the datasource name to use.

Author:

Jeff Davis davis@xarg.net

Created:

2002-10-30

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    db_multirow $datasource clipboards {select collection_id, title, 0 as selected from pa_collections where owner_id = :user_id}

    if {[template::multirow size $datasource] > 0} {
        if {$create_new_p} { 
            template::multirow append $datasource -1 "Create a new clipboard" 0
        } 

    } else { 
        if { $force_default_p } { 
            template::multirow create $datasource collection_id title selected
            template::multirow append $datasource 0 "General" 0
        }
    }
    return [template::multirow size $datasource]

Generic XQL file:

packages/photo-album/tcl/photo-album-procs.xql

PostgreSQL XQL file:

packages/photo-album/tcl/photo-album-procs-postgresql.xql

Oracle XQL file:

packages/photo-album/tcl/photo-album-procs-oracle.xql