Index: openacs-4/packages/lorsm/www/admin/md/educationalmd.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/md/educationalmd.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/admin/md/educationalmd.xql 16 Apr 2010 21:35:12 -0000 1.2 +++ openacs-4/packages/lorsm/www/admin/md/educationalmd.xql 2 Nov 2010 10:33:00 -0000 1.3 @@ -3,63 +3,63 @@ - select '(' || int_type_s || ') ' || int_type_v as intt + select int_type_s || ' ' || int_type_v as intt from ims_md_educational where ims_md_id = :ims_md_id - select '(' || lrt_s || ') ' || lrt_v as lrt + select lrt_s || ' ' || lrt_v as lrt from ims_md_educational_lrt where ims_md_id = :ims_md_id - select '(' || int_level_s || ') ' || int_level_v as intl + select int_level_s || ' ' || int_level_v as intl from ims_md_educational where ims_md_id = :ims_md_id - select '(' || sem_density_s || ') ' || sem_density_v as semd + select sem_density_s || ' ' || sem_density_v as semd from ims_md_educational where ims_md_id = :ims_md_id - select '(' || ieur_s || ') ' || ieur_v as ieur + select ieur_s || ' ' || ieur_v as ieur from ims_md_educational_ieur where ims_md_id = :ims_md_id - select '(' || context_s || ') ' || context_v as context + select context_s || ' ' || context_v as context from ims_md_educational_context where ims_md_id = :ims_md_id - select '(' || tar_l || ') ' || tar_s as tar + select tar_l || ' ' || tar_s as tar from ims_md_educational_tar where ims_md_id = :ims_md_id - select '(' || difficulty_s || ') ' || difficulty_v as diff + select difficulty_s || ' ' || difficulty_v as diff from ims_md_educational where ims_md_id = :ims_md_id @@ -68,15 +68,15 @@ select type_lrn_time as tlt, - '(' || type_lrn_time_l || ') ' || type_lrn_time_s as tlt_ls + type_lrn_time_l || ' ' || type_lrn_time_s as tlt_ls from ims_md_educational where ims_md_id = :ims_md_id - select '(' || descrip_l || ') ' || descrip_s as desc + select descrip_l || ' ' || descrip_s as desc from ims_md_educational_descrip where ims_md_id = :ims_md_id @@ -90,54 +90,4 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Index: openacs-4/packages/lorsm/www/admin/md/lifecyclemd.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/md/lifecyclemd.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/admin/md/lifecyclemd.xql 16 Apr 2010 21:35:12 -0000 1.2 +++ openacs-4/packages/lorsm/www/admin/md/lifecyclemd.xql 2 Nov 2010 10:33:00 -0000 1.3 @@ -19,9 +19,9 @@ - select lfc.role_v || ' ' || '(' || lfc.role_s || ')' as role, + select lfc.role_v || ' ' || lfc.role_s as role, lfce.entity, lfc.cont_date, - '(' || lfc.cont_date_l || ')' || ' ' || lfc.cont_date_s as cont_date_ls + lfc.cont_date_l || ' ' || lfc.cont_date_s as cont_date_ls from ims_md_life_cycle_contrib lfc, ims_md_life_cycle_contrib_entity lfce where lfc.ims_md_lf_cont_id = lfce.ims_md_lf_cont_id and lfc.ims_md_id = :ims_md_id Index: openacs-4/packages/lorsm/www/admin/md/metamd.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/md/metamd.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/admin/md/metamd.xql 16 Apr 2010 21:35:12 -0000 1.2 +++ openacs-4/packages/lorsm/www/admin/md/metamd.xql 2 Nov 2010 10:33:00 -0000 1.3 @@ -3,17 +3,17 @@ - select catalog, '(' || entry_l || ')' || ' ' || entry_s as entry_ls + select catalog, entry_l || ' ' || entry_s as entry_ls from ims_md_metadata_cata where ims_md_id = :ims_md_id - select mdc.role_v || ' ' || '(' || mdc.role_s || ')' as role, + select mdc.role_v || ' ' || mdc.role_s as role, mdce.entity, mdc.cont_date, - '(' || mdc.cont_date_l || ')' || ' ' || mdc.cont_date_s as cont_date_ls + mdc.cont_date_l || ' ' || mdc.cont_date_s as cont_date_ls from ims_md_metadata_contrib mdc, ims_md_metadata_contrib_entity mdce where mdc.ims_md_md_cont_id = mdce.ims_md_md_cont_id and mdc.ims_md_id = :ims_md_id Index: openacs-4/packages/lorsm/www/admin/md/rightsmd.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/md/rightsmd.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/admin/md/rightsmd.xql 16 Apr 2010 21:35:12 -0000 1.2 +++ openacs-4/packages/lorsm/www/admin/md/rightsmd.xql 2 Nov 2010 10:33:00 -0000 1.3 @@ -3,23 +3,23 @@ - select '(' || cost_s || ') ' || cost_v as cost + select cost_s || ' ' || cost_v as cost from ims_md_rights where ims_md_id = :ims_md_id - select '(' || caor_s || ') ' || caor_v as caor + select caor_s || ' ' || caor_v as caor from ims_md_rights where ims_md_id = :ims_md_id - select '(' || descrip_l || ') ' || descrip_s as desc + select descrip_l || ' ' || descrip_s as desc from ims_md_rights where ims_md_id = :ims_md_id Index: openacs-4/packages/lorsm/www/admin/md/technicalmd.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/md/technicalmd.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/admin/md/technicalmd.xql 16 Apr 2010 21:35:12 -0000 1.2 +++ openacs-4/packages/lorsm/www/admin/md/technicalmd.xql 2 Nov 2010 10:33:00 -0000 1.3 @@ -27,24 +27,24 @@ - select '(' || type_s || ')' || ' ' || type_v as type, - '(' || name_s || ')' || ' ' || name_v as name, min_version, max_version + select type_s || ' ' || type_v as type, + name_s || ' ' || name_v as name, min_version, max_version from ims_md_technical_requirement where ims_md_id = :ims_md_id - select '(' || instl_rmrks_l || ')' || ' ' || instl_rmrks_s as instl_rmrks + select instl_rmrks_l || ' ' || instl_rmrks_s as instl_rmrks from ims_md_technical where ims_md_id = :ims_md_id - select '(' || otr_plt_l || ')' || ' ' || otr_plt_s as otr_plt + select otr_plt_l || ' ' || otr_plt_s as otr_plt from ims_md_technical where ims_md_id = :ims_md_id