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

fixed date calculation for one_if_within_n_days

fixed trigger for credit card. it needs to be before updates to the ec_financial_tranactions table.

fixed order_select query

added missing full query update_order_state

fixed ec_order_cost plpgsql function

added query for ec_mailing_list_widget.get_category_children

fixed subquery syntax. Postgresql requires an as statement

updated .info for util.logical_negation corrections. Added -postgresql.xql and -oracle.sql for a few files in admin/

changed logical_negation calls to util__logical_negation and util.logical_negation.

logical_negation changed to util__logical_negation and util.logical_negation in acs-kernel/sql/*/utilities-create.sql

changed triggers to after. if set to before, you sometimes cannot delete from the tables.

fixed fullquery name

function logical_negation was changed to util__logical_negation (acs-kernel)

added db_map for sysdate calls in a dynamic query.

added db_map for partialquery. expanded the ec_products query to get date in standard format for ad_dateentrywidget.

updated with correct names for sql creation/deletion scripts

renamed files to package-name-create/drop format so that the APM will recognize it during installation.

renamed the files to package-name-create/drop.sql so the APM will recognize it

Fixed error in actually selecting bookmarks to view. Hadn't tried that yet...you can use them now.

    • -0
    • +16
    /openacs-4/packages/bookmarks/www/bookmark-access-oracle.xql
Fixed error in sort order on index page. Added editing and viewing. Basic

functionality is working.

    • -0
    • +34
    /openacs-4/packages/bookmarks/www/bookmark-add-one-2.xql
    • -0
    • +35
    /openacs-4/packages/bookmarks/www/bookmark-edit-2-oracle.xql
    • -0
    • +20
    /openacs-4/packages/bookmarks/www/bookmark-edit-2.xql
    • -0
    • +8
    /openacs-4/packages/bookmarks/www/bookmark-edit-oracle.xql
    • -0
    • +40
    /openacs-4/packages/bookmarks/www/bookmark-edit.xql
    • -0
    • +32
    /openacs-4/packages/bookmarks/www/bookmark-view-oracle.xql
    • -0
    • +22
    /openacs-4/packages/bookmarks/www/bookmark-view.xql

fixed naming of fullquery. did initial pass on proc vs. QE verification.

changed all procs/proc_docs to ad_proc.

fixed ec_product__new for postgresql. also did a db_map for sysdate call.

fixed ec_product__new function

fixed sort key calculation. postgres driver encloses bind variables in ' ' which makes the sort key calculation fail. the key calculation is done in tcl now.

fixed queryname names. fixed outer join which wasn't picked up by the query extractor.

fixed sort key calculations. the postgres driver puts ' ' around the bind variable. the old code performed calculations like "and sort_key = (:prev_sort_key + :next_sort_key)/2", which caused postgres to barf. this calculation is now done in tcl.

fixed oracle sign() calls

/bin/bash: q: command not found

Initial OpenACS import

    • -0
    • +91
    /openacs-4/packages/acs-reference/sql/postgresql/us-counties.sql
    • -0
    • +40
    /openacs-4/packages/acs-reference/sql/postgresql/us-states.sql
    • -0
    • +68
    /openacs-4/packages/acs-reference/sql/postgresql/us-zipcodes.sql