faq-add-edit.xql

DB Query file

Related Files

• packages/faq/lib/faq-add-edit.xql
• packages/faq/lib/faq-add-edit.tcl
• packages/faq/lib/faq-add-edit.adp
• packages/faq/lib/faq-add-edit-postgresql.xql
• packages/faq/lib/faq-add-edit-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
    <fullquery name="get_faq">
        <querytext>
           select faq_name, separate_p from faqs where faq_id = :faq_id
        </querytext>
    </fullquery>

    <fullquery name="edit_faq">
        <querytext>
            update faqs  
            set    faq_name   = :faq_name, 
                   separate_p = :separate_p 
            where  faq_id     = :faq_id
        </querytext>
    </fullquery>

</queryset>