Index: openacs-4/packages/dotlrn-fs/www/all-objects.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-fs/www/all-objects.tcl,v
diff -u -r1.10 -r1.10.2.1
--- openacs-4/packages/dotlrn-fs/www/all-objects.tcl 9 Aug 2002 18:39:29 -0000 1.10
+++ openacs-4/packages/dotlrn-fs/www/all-objects.tcl 17 Oct 2002 10:54:02 -0000 1.10.2.1
@@ -60,7 +60,7 @@
set table_def [list]
-lappend table_def [list name Name {fs_objects.name $order} "
\$name | "]
+lappend table_def [list name Name {fs_objects.name $order} "\$name | "]
lappend table_def [list folder_name Folder {} "\$folder_name | "]
lappend table_def {type Type {fs_objects.type $order} {c}}
lappend table_def {content_size Size {fs_objects.content_size $order} {[ad_decode $type folder "$content_size item[ad_decode $content_size 1 {} s]" url {} "$content_size byte[ad_decode $content_size 1 {} s]"] | }}
Index: openacs-4/packages/dotlrn-fs/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-fs/www/index-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/dotlrn-fs/www/index-postgresql.xql 30 Jul 2002 12:27:47 -0000 1.1
+++ openacs-4/packages/dotlrn-fs/www/index-postgresql.xql 17 Oct 2002 10:54:02 -0000 1.1.2.1
@@ -9,7 +9,7 @@
from (select fs_folders.folder_id,
fs_folders.parent_id,
fs_folders.name,
- nvl ((select sum(fs_files.content_size) as content_size
+ coalesce ((select sum(fs_files.content_size) as content_size
from fs_files
where fs_files.parent_id in (select cr_items.item_id
from cr_items