faq-procs.xql

DB Query file

Related Files

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

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

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

    <fullquery name="faq::notification::get_url.get_faq_id">
        <querytext>	
        select faq_id from faq_q_and_as 
        where entry_id = :q_and_a_id
        </querytext>
    </fullquery>

</queryset>