OpenACS

antoniop
committed
oacs-5-9:antoniop:20161221001456
on 21 Dec 16
Added new database utility to retrieve primary keys of a table.
Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_p… Show more
Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

Show less

/cadmin/site-wide-status-change.xql (+1 -1)
1 1 <?xml version="1.0"?>
2 2 <queryset>
3 3
4 4 <fullquery name="toggle_site_wide_status">     
5 5       <querytext>
6 6      
7 7     update category_trees
8       set site_wide_p = case when :action = '1' then 't' else 'f' end
  8     set site_wide_p = (:action = '1')
9 9     where tree_id  = :tree_id
10 10
11 11       </querytext>
12 12 </fullquery>
13 13
14 14  
15 15 </queryset>