fixed money_select query
used db_map for dynamic queries with date calcs
used db_map for dynamic sql queries with date calcs
added db_map for dynamic queries with dates
fixed date filters by adding db_map for dynamic sql
fixed missing " for set carrier_info
fixed trigger for address_id insert
fixed date queries to use timespan_days for interval calculation
fixed date queries by using db_map
changed $addess_link to checkout-2
postgresql returns the full timestamp including the time which screws up some procs which assume that the date returned is formatted as YYYY-MM-DD. a simple to_char statement fixes the problem
fixed missing queries and incorrect query names
fixed template query for OpenACS 4
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
Got a suggestion or an issue? Discuss it on the Atlassian Community or visit Atlassian Support for other options.