xo::db::sql::faq proc new_q_and_a (public)
xo::db::sql::faq new_q_and_a [ -dbn dbn ] [ -entry_id entry_id ] \ -faq_id faq_id -question question -answer answer \ -sort_key sort_key -object_type object_type \ [ -creation_date creation_date ] [ -creation_user creation_user ] \ [ -creation_ip creation_ip ] [ -context_id context_id ]
Defined in packages/xotcl-core/tcl/05-db-procs.tcl
Automatically generated method
- Switches:
- -dbn
(optional)- -entry_id
(optional)- -faq_id
(required)- -question
(required)- -answer
(required)- -sort_key
(required)- -object_type
(required)- -creation_date
(defaults to"current_timestamp"
) (optional)- -creation_user
(optional)- -creation_ip
(optional)- -context_id
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
Source code: #function_args: {ENTRY_ID null} {FAQ_ID {}} {QUESTION {}} {ANSWER {}} {SORT_KEY {}} {OBJECT_TYPE {}} {CREATION_DATE current_timestamp} {CREATION_USER null} {CREATION_IP null} {CONTEXT_ID null} foreach var [list ENTRY_ID FAQ_ID QUESTION ANSWER SORT_KEY OBJECT_TYPE CREATION_DATE CREATION_USER CREATION_IP CONTEXT_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__new_q_and_a($_ENTRY_ID, $_FAQ_ID, $_QUESTION, $_ANSWER, $_SORT_KEY, $_OBJECT_TYPE, $_CREATION_DATE, $_CREATION_USER, $_CREATION_IP, $_CONTEXT_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