Index: openacs-4/packages/acs-content-repository/tcl/revision-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/Attic/revision-procs.xql,v diff -u -r1.6.2.5 -r1.6.2.6 --- openacs-4/packages/acs-content-repository/tcl/revision-procs.xql 6 Jul 2005 01:28:07 -0000 1.6.2.5 +++ openacs-4/packages/acs-content-repository/tcl/revision-procs.xql 6 Jul 2005 08:35:34 -0000 1.6.2.6 @@ -4,7 +4,7 @@ select i.storage_type, i.storage_area_key, r.mime_type, i.item_id, - r.content_length + r.content_length from cr_items i, cr_revisions r where r.revision_id = :revision_id and i.item_id = r.item_id @@ -21,17 +21,17 @@ select content_type - from cr_items + from cr_items where item_id = :item_id insert into cr_mime_types (mime_type) - select :mime_type - from dual - where not exists (select 1 from cr_mime_types where mime_type = :mime_type) + select :mime_type + from dual + where not exists (select 1 from cr_mime_types where mime_type = :mime_type) @@ -48,7 +48,7 @@ select 1 from cr_content_mime_type_map where mime_type = :mime_type - and contetnt_type = 'content_revision' + and content_type = 'content_revision'