OpenACS

miguelm
committed
oacs-5-2:miguelm:20050816200436:10
on 16 Aug 05
file payment-ae.adp was added on branch oacs-5-2 on 2005-11-30 15:56:14 +0000
oacs-5-2:miguelm:20050816200436:10
openacs-4/.../util/payment-delete.xql (deleted)
1   <?xml version="1.0"?>
2   <queryset>
3  
4   <fullquery name="title">
5         <querytext>
6  
7           select r.title
8           from cr_revisions r, cr_items i
9           where i.latest_revision = r.revision_id
10           and i.item_id = :payment_id
11  
12         </querytext>
13   </fullquery>
14  
15   <fullquery name="mark_deleted">
16         <querytext>
17  
18           update cr_items
19           set latest_revision = null,
20               live_revision = null
21           where item_id = :payment_id
22  
23         </querytext>
24   </fullquery>
25  
26   </queryset>
27