xo::db::sql::category proc change_parent (public)
xo::db::sql::category change_parent [ -dbn dbn ] \ -category_id category_id -tree_id tree_id -parent_id parent_id
Defined in /var/www/openacs.org/packages/xotcl-core/tcl/05-db-procs.tcl
Automatically generated method
- Switches:
- -dbn (optional)
- -category_id (required)
- -tree_id (required)
- -parent_id (required)
- Testcases:
- No testcase defined.
Source code: #function_args: {CATEGORY_ID {}} {TREE_ID {}} {PARENT_ID {}} foreach var [list CATEGORY_ID TREE_ID PARENT_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select category__change_parent($_CATEGORY_ID, $_TREE_ID, $_PARENT_ID) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }XQL Not present: Generic, PostgreSQL, Oracle