xo::db::Class instproc get_instances_from_db (public)

 <instance of xo::db::Class> get_instances_from_db \
    [ -select_attributes select_attributes ] \
    [ -from_clause from_clause ] [ -where_clause where_clause ] \
    [ -orderby orderby ] [ -page_size page_size ] \
    [ -page_number page_number ] [ -initialize initialize ]

Defined in /var/www/openacs.org/packages/xotcl-core/tcl/05-db-procs.tcl

Returns a set (ordered composite) of the answer tuples of an 'instance_select_query' with the same attributes. Note that the returned objects might by partially instantiated.

Switches:

-select_attributes (optional)

-from_clause (optional)

-where_clause (optional)

-orderby (optional)

-page_size (optional, defaults to "20")

-page_number (optional)

-initialize (optional, defaults to "true")

Returns:

ordered composite

Testcases:

No testcase defined.

Source code:

set s [:instantiate_objects  -object_class [self]  -sql [:instance_select_query  -select_attributes $select_attributes  -from_clause $from_clause  -where_clause $where_clause  -orderby $orderby  -page_size $page_size  -page_number $page_number  ]  -initialize $initialize]
return $s

XQL Not present:

Generic, PostgreSQL, Oracle