acs::db::nsdb-postgresql method call faq new_q_and_a (public)

 <instance of acs::db::nsdb-postgresql[i]> 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
[ hide source ] | [ make this the default ]
Show another procedure: