xo::db::sql::wp_presentation proc new_revision (public)

 xo::db::sql::wp_presentation[i] new_revision [ -dbn dbn ] \
    -creation_date creation_date  -creation_user creation_user  \
    -creation_ip creation_ip  -pres_item_id pres_item_id  \
    -pres_title pres_title  -page_signature page_signature  \
    -copyright_notice copyright_notice  -style style  \
    -public_p public_p  -show_modified_p show_modified_p  \
    -audience audience  -background background 

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

Automatically generated method

Switches:
-dbn (optional)
-creation_date (required)
-creation_user (required)
-creation_ip (required)
-pres_item_id (required)
-pres_title (required)
-page_signature (required)
-copyright_notice (required)
-style (required)
-public_p (required)
-show_modified_p (required)
-audience (required)
-background (required)

Testcases:
No testcase defined.
Source code:
#function_args: {CREATION_DATE {}} {CREATION_USER {}} {CREATION_IP {}} {PRES_ITEM_ID {}} {PRES_TITLE {}} {PAGE_SIGNATURE {}} {COPYRIGHT_NOTICE {}} {STYLE {}} {PUBLIC_P {}} {SHOW_MODIFIED_P {}} {AUDIENCE {}} {BACKGROUND {}}
foreach var [list CREATION_DATE CREATION_USER CREATION_IP PRES_ITEM_ID PRES_TITLE PAGE_SIGNATURE COPYRIGHT_NOTICE STYLE PUBLIC_P SHOW_MODIFIED_P AUDIENCE BACKGROUND]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select wp_presentation__new_revision($_CREATION_DATE$_CREATION_USER$_CREATION_IP$_PRES_ITEM_ID$_PRES_TITLE$_PAGE_SIGNATURE$_COPYRIGHT_NOTICE$_STYLE$_PUBLIC_P$_SHOW_MODIFIED_P$_AUDIENCE$_BACKGROUND) 
    "
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
[ hide source ] | [ make this the default ]
Show another procedure: