• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

1. Fixed a bug in the oracle version of acs-mail-nt-create.sql

2. Fixed a bug in the oracle version of the APM - a standard SQL92

left join was being executed rather than the nasty Oracle-specific

notation.

3. Futzed with the APM a bit - you can now only set "watch" commands on

those .xql files which are used by the current installation, you can

only install packages supported by the current installation's RDBMS.

    • -8
    • +10
    ./packages/acs-admin/www/apm/packages-install.tcl
    • -2
    • +2
    ./packages/acs-admin/www/apm/version-files.tcl
    • -0
    • +17
    ./packages/acs-tcl/tcl/00-database-procs.tcl
    • -1
    • +15
    ./packages/acs-tcl/tcl/apm-xml-procs.tcl

Superceded by acs-mail.

Superceded by acs-reference.

    • -803
    • +0
    ./packages/places/doc/design.html
    • -272
    • +0
    ./packages/places/doc/requirements.html
    • -51
    • +0
    ./packages/places/extras/county_txt_parse.pl
    • -70
    • +0
    ./packages/places/extras/zip_dbf_parse.pl
    • -11
    • +0
    ./packages/places/sql/oracle/analyze.sql
    • -1470
    • +0
    ./packages/places/sql/oracle/pl_countries-load.sql
  1. … 21 more files in changeset.

fixed a few more queries in subsite, added a correction to the API for subsite nodes.

    • -1
    • +23
    ./packages/acs-subsite/tcl/attribute-procs.tcl
    • -5
    • +17
    ./packages/acs-subsite/tcl/rel-types-procs.tcl
    • -0
    • +14
    ./packages/acs-subsite/tcl/rel-types-procs.xql
    • -1
    • +24
    ./packages/acs-tcl/tcl/site-nodes-procs.tcl
Changed dm_dml to db_exec_plsql since query is a select (bug in original).

    • -4
    • +4
    ./packages/file-storage/www/file-move-2.tcl
Added last two (hopefully) .xql files

    • -0
    • +2
    ./packages/file-storage/file-storage.info
Made aliases for all subselects to make it easier to follow which is which; also removed commented out connect by's

Corrected typo when refering to table acs_objects

Corrected typo in original version: user_ud should be user_id

    • -2
    • +2
    ./packages/file-storage/www/file-copy-2.tcl
Initial port

    • -0
    • +35
    ./packages/file-storage/www/folder_list-oracle.xql
Added dm_map for dynamic part of query

    • -13
    • +15
    ./packages/file-storage/www/folder_list.tcl
Forgot to update bookmarks.info

Adding files for Javascript view

    • -0
    • +33
    ./packages/bookmarks/www/tree-dynamic-oracle.xql
    • -0
    • +37
    ./packages/bookmarks/www/tree-dynamic-postgresql.xql
    • -0
    • +14
    ./packages/bookmarks/www/tree-dynamic.xql
fixup to get base item creation working

    • -4
    • +4
    ./packages/cms/tcl/pagination-procs.tcl
    • -1
    • +1
    ./packages/cms/tcl/pagination-procs.xql
Added dynamic queries

    • -0
    • +37
    ./packages/file-storage/www/file-oracle.xql
Changed query name fle-delete to file_delete.

    • -2
    • +2
    ./packages/file-storage/www/file-delete.tcl
cleanup of add item routines

    • -0
    • +38
    ./packages/cms/tcl/content-method-procs-oracle.xql
    • -0
    • +38
    ./packages/cms/tcl/content-method-procs-postgresql.xql
    • -5
    • +5
    ./packages/cms/tcl/content-method-procs.tcl
    • -0
    • +28
    ./packages/cms/tcl/content-method-procs.xql
    • -19
    • +1
    ./packages/cms/tcl/form-procs-oracle.xql
    • -22
    • +20
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -43
    • +43
    ./packages/cms/tcl/form-procs.tcl
fixup to get main screen working

    • -1
    • +1
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -6
    • +58
    ./packages/cms/tcl/module-procs-postgresql.xql
Removed level attribute in fs_context_bar_lis.context_bar query

moving timezones to a seperate package

    • -532
    • +0
    ./packages/acs-reference/sql/common/timezone-data.sql
Initial port

    • -0
    • +19
    ./packages/file-storage/www/search-oracle.xql
    • -0
    • +19
    ./packages/file-storage/www/search-postgresql.xql
    • -0
    • +17
    ./packages/file-storage/www/version-add.xql
    • -0
    • +25
    ./packages/file-storage/www/version-delete.xql
    • -0
    • +29
    ./packages/file-storage/www/download/index-oracle.xql
    • -0
    • +30
    ./packages/file-storage/www/download/index-postgresql.xql
    • -0
    • +15
    ./packages/file-storage/www/download/index.xql
Use db_map for dynamically creeated query

    • -12
    • +16
    ./packages/file-storage/www/file.tcl
Bookmark Import working

    • -0
    • +66
    ./packages/bookmarks/www/bookmarks-import-oracle.xql
    • -0
    • +70
    ./packages/bookmarks/www/bookmarks-import-postgresql.xql
    • -0
    • +70
    ./packages/bookmarks/www/bookmarks-import.xql
Inital port

    • -0
    • +13
    ./packages/file-storage/www/file-copy-2.xql
Initial port.

    • -0
    • +17
    ./packages/file-storage/www/file-edit-oracle.xql
Initial port

    • -0
    • +64
    ./packages/file-storage/www/file-add-2-oracle.xql
    • -0
    • +17
    ./packages/file-storage/www/file-add-2.xql
    • -0
    • +56
    ./packages/file-storage/www/file-copy-2-oracle.xql
    • -0
    • +17
    ./packages/file-storage/www/file-copy.xql
    • -0
    • +38
    ./packages/file-storage/www/file-delete-oracle.xql
    • -0
    • +13
    ./packages/file-storage/www/file-delete.xql
    • -0
    • +32
    ./packages/file-storage/www/file-edit-2-oracle.xql
    • -0
    • +20
    ./packages/file-storage/www/file-move-2-oracle.xql
    • -0
    • +36
    ./packages/file-storage/www/file-move-2.xql
    • -0
    • +17
    ./packages/file-storage/www/file-move-oracle.xql
  1. … 3 more files in changeset.
Includes all .xql files

    • -0
    • +46
    ./packages/file-storage/file-storage.info
Fix broken threading due to incorrect query name.

Syncing with server after move; adding fixes to CONNECT BY replacements. Presently, some are broken once multiple users are added to site

    • -22
    • +22
    ./packages/bookmarks/bookmarks.info
    • -1
    • +1
    ./packages/bookmarks/www/folder-selection.tcl
Fixed posting error due to incorrect partialquery name.