faq::get_instance_info (public)

 faq::get_instance_info -arrayname arrayname -faq_id faq_id

Defined in packages/faq/tcl/faq-procs.tcl

returns the name of the FAQ and whether to display questions and their answers all on the listing page or on separate pages

Switches:

-arrayname (required)

-faq_id (required)

Testcases:

faq_create_and_retrieve

Source code:

        upvar $arrayname faq_info
        db_0or1row get_info "" -column_array faq_info

Generic XQL file:

<fullquery name="faq::get_instance_info.get_info">
    <querytext>	
        select faq_name, separate_p from faqs
        where faq_id = :faq_id
        </querytext>
</fullquery>

packages/faq/tcl/faq-procs.xql

PostgreSQL XQL file:

packages/faq/tcl/faq-procs-postgresql.xql

Oracle XQL file:

packages/faq/tcl/faq-procs-oracle.xql