• last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed get_path to match oracle version

Port group-type/change-join-policy

This query wrongly extracted from comment in party::new

This query wrongly extracted from comment in group::new

Initial port of the acs-datetime package. All database calls to Oracle-

specific functions have been replaced with Tcl procedures. These Tcl

procedures should mimic exactly thier Oracle counterparts to reduce the

chance of introducing bugs into the system. Future enhancements are likely

forthcoming to increase the robustness of the code.

Importing.

    • -0
    • +13
    /openacs-4/packages/acs-datetime/tcl/acs-datetime-procs.xql
fixed exception message in content_type__drop_attribute

RAC: Added *xql missing from previous commit

    • -0
    • +69
    /openacs-4/packages/address-book/tcl/address-book-procs.xql
    • -0
    • +11
    /openacs-4/packages/address-book/www/address-ae-2.xql
    • -0
    • +42
    /openacs-4/packages/address-book/www/address-delete-oracle.xql
    • -0
    • +18
    /openacs-4/packages/address-book/www/address-delete.xql
    • -0
    • +25
    /openacs-4/packages/address-book/www/address-swap-oracle.xql
    • -0
    • +11
    /openacs-4/packages/address-book/www/address-swap.xql
    • -0
    • +30
    /openacs-4/packages/address-book/www/attr-ae-2-oracle.xql
    • -0
    • +34
    /openacs-4/packages/address-book/www/attr-ae-2-postgresql.xql
    • -0
    • +22
    /openacs-4/packages/address-book/www/attr-ae-2.xql
    • -0
    • +38
    /openacs-4/packages/address-book/www/attr-ae.xql
    • -0
    • +15
    /openacs-4/packages/address-book/www/attr-delete-oracle.xql
    • -0
    • +17
    /openacs-4/packages/address-book/www/attr-delete-postgresql.xql
    • -0
    • +15
    /openacs-4/packages/address-book/www/attr-delete.xql
  1. … 14 more files in changeset.
RAC (Nov 23, 2001): Unfinished port for address-book.

The places package needs to be replaced by acs-references. This makes the data model file crash. The *xql files were created but untouched.

Similar to previous fix.

Added missing where clause in "bboard_message_set.message_set_content"

query. Thanks to Louis Zirkel for catching this.

Fix for message-edit-3 blowing up. Tested on both PG and Oracle. Thanks

go out to Louis. - Arjun

"In digging into the code I found that there is a call to

bboard_message_clear_categories which in turn calls db_dml to call a

stored proc. This doesn't seem to work, but changing the db_dml call

to db_exec_plsql seems to have resolved the issue." -- Louis Zirkel

fixed MIME type checking for text inside oracle clob

moved the time check inside the if statment for expected_arrival_time

fixed bug when all_items_p is selected, the item_id_list was not set to item_id so only the last item_id would get passed to fulfill-3.tcl. Also added a time check to make sure all parts of the time had two digits. PostgreSQL chokes if it's not formatted exactly (ie. HH:MI:SS). Created a new function called: ec_timeentrywidget_time_check to do the check.

added a proc ec_timeentrywidget_time_check to make sure that the time part of the time stamp has all of the necessary digits for HH:MM:SS. If it doesn't, postgresql complains.

fixed trig_ec_order_state_after_tr

fixed typo

reimplemented RI triggers for live_revision and latest_revision as user triggers

cleanups, playing with cvs, hi log readers

cleanup

removed trigger delete

fixes

removed deleted file

- converted over to using pg lobs,

- always uses template system for content generation

- added basic double click checks to postcard sending

- added more fine grained security checks based on

a more atomic security/permission model

  1. … 15 more files in changeset.
added basic permissioning and pg lob support

updated with latest file revisions, not sure about url conventions

changed number to numeric in one of the functions

fixed bug where the order amount would not be subtracted from the gift certificate total

fixed to_number call that I missed