acs::db::nsdb-postgresql method call faq new_q_and_a (public)
<instance of acs::db::nsdb-postgresql> call 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/acs-tcl/tcl/00-acs-tcl-init.tcl
Automatically generated method TYPES: integer integer text text integer {character varying} {timestamp with time zone} integer {character varying} integer
- Switches:
- -dbn (optional)
- -entry_id (optional, accept empty)
- -faq_id (required)
- -question (required)
- -answer (required)
- -sort_key (required)
- -object_type (required)
- -creation_date (optional, defaults to
"current_timestamp"
)- -creation_user (optional, accept empty)
- -creation_ip (optional, accept empty)
- -context_id (optional, accept empty)
- Testcases:
- No testcase defined.
Source code: db_with_handle -dbn $dbn __DB { set s [ns_pg_bind 0or1row $__DB {select faq__new_q_and_a(CAST(:entry_id AS integer),CAST(:faq_id AS integer),:question,:answer,CAST(:sort_key AS integer),:object_type,:creation_date,CAST(:creation_user AS integer),:creation_ip,CAST(:context_id AS integer))}] return [ns_set value $s 0] }XQL Not present: Generic, PostgreSQL, Oracle