Index: openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql	7 Apr 2005 11:27:00 -0000	1.11
+++ openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql	7 Apr 2005 18:57:01 -0000	1.12
@@ -10,9 +10,11 @@
 		et.title,
         	et.item_id,
 		et.mime_type,
+		crr.content_length,
 		cri.storage_type
-		from evaluation_tasksi et, cr_items cri
+		from evaluation_tasksi et, cr_items cri, cr_revisions crr
 		where et.task_id = :task_id
+		  and crr.revision_id = et.task_id
           and et.item_id = cri.item_id
 	
       </querytext>
@@ -21,7 +23,7 @@
 <fullquery name="set_date">      
       <querytext>
 
-		select to_timestamp('[template::util::date::get_property linear_date $due_date]','YYYY MM DD HH24 MI SS')l
+		select to_timestamp('[template::util::date::get_property linear_date $due_date]','YYYY MM DD HH24 MI SS')
 	
       </querytext>
 </fullquery>
@@ -46,6 +48,16 @@
      </querytext>
 </fullquery>
 
+<fullquery name="set_storage_type">      
+      <querytext>
+
+	update cr_items
+ 	set storage_type = 'text'
+	where item_id = :item_id
+
+     </querytext>
+</fullquery>
+
 <fullquery name="copy_content">      
       <querytext>