serve-slide.xql

DB Query file

Related Files

• packages/wp-slim/www/serve-slide.xql
• packages/wp-slim/www/serve-slide.tcl
• packages/wp-slim/www/serve-slide.adp
• packages/wp-slim/www/serve-slide-postgresql.xql
• packages/wp-slim/www/serve-slide-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

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

<fullquery name="get_presentation_page_signature">      
      <querytext>
      
    select p.page_signature,
    p.copyright_notice,
    p.show_modified_p,
    p.style,
    p.show_comments_p
    from cr_wp_presentations p, cr_items i
    where i.item_id = :pres_item_id
    and   i.live_revision = p.presentation_id

      </querytext>
</fullquery>

 
<fullquery name="get_previous_slide_item_id">      
      <querytext>
      
	select i.item_id
	from cr_wp_slides s, cr_items i
	where i.parent_id = :pres_item_id
        and   i.live_revision = s.slide_id
	and   s.sort_key = (:sort_key - 1)
    
      </querytext>
</fullquery>

 
<fullquery name="get_next_slide">      
      <querytext>
      
    select i.item_id as next_slide_item_id 
    from cr_wp_slides s, cr_items i 
    where i.parent_id = :pres_item_id
    and   i.live_revision = s.slide_id
    and   s.sort_key = :next_sort_key

      </querytext>
</fullquery>

</queryset>