-
-This region may not be edited by normal users.
-
-
-
Index: openacs-4/packages/new-portal/www/place-element.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/www/place-element.tcl,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/new-portal/www/place-element.tcl 5 Nov 2001 19:02:18 -0000 1.12
+++ openacs-4/packages/new-portal/www/place-element.tcl 5 Nov 2001 20:08:25 -0000 1.13
@@ -22,20 +22,22 @@
# get the elements for this region.
set region_count 0
template::multirow create element_multi element_id name sort_key state
-db_foreach select_elements_by_region \
- "select element_id, name, sort_key, state
+db_foreach select_elements_by_region {
+ select element_id, name, sort_key, state
from portal_element_map
where
portal_id = :portal_id
and region = :region
and state != 'hidden'
- order by sort_key"
-{
- template::multirow append element_multi $element_id $name $sort_key $state
- incr region_count
-}
+ order by sort_key } {
+ template::multirow append element_multi \
+ $element_id $name $sort_key $state
+ incr region_count
+ }
+
+
db_1row select_all_noimm_count \
"select count(*) as all_count
from portal_element_map
@@ -57,11 +59,10 @@
where pdam.portal_id = :portal_id
and pd.datasource_id = pdam.datasource_id
and pd.datasource_id in (
- select datasource_id
- from portal_element_map
- where portal_id = :portal_id
- and state = 'hidden')
-)
+ select datasource_id
+ from portal_element_map
+ where portal_id = :portal_id
+ and state = 'hidden')
order by name
} {
set add_avail_p 1