Index: openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql 7 Jul 2004 17:26:45 -0000 1.3 +++ openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql 12 Aug 2004 17:46:42 -0000 1.4 @@ -10,15 +10,26 @@ crr.title, crr.item_id, cri.storage_type, - crr.revision_id - from evaluation_tasks_sols ets, cr_items cri, cr_revisions crr + crr.revision_id, + ets.mime_type + from evaluation_tasks_solsi ets, cr_items cri, cr_revisions crr where ets.solution_id = :solution_id and ets.solution_id = crr.revision_id and crr.item_id = cri.item_id + + + + select evaluation__delete_task_sol(solution_id) + from evaluation_tasks_sols + where task_item_id = :task_item_id + + + +