• last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
attempting fix for bug 2603 and an anticipated bug with another ad_parameter case. also removing tabs in sql and code for good measure.

fix for bug 2610, variable not found in documentation page

fixing typo

    • -1
    • +1
    ./tcl/ecommerce-state-changes-procs.xql
removing duplicate query

standardized oracle query, adding postgresql equivalent, closes bug 2491

fixing corrupt file

    • -0
    • +20
    ./www/checkout-one-form-2-oracle.xql
removing hanging bracket

adding html ability to ec_custom_fields, to be consistent with ec_products.detailed_description. This does not affect other types because the code that validates them is unchanged.

improving error checking and reporting, such as for connect timeouts and inserting of custom field rows (instead of updating)

    • -56
    • +77
    ./www/admin/products/extras-upload-2.tcl
    • -0
    • +19
    ./www/admin/products/extras-upload-2.xql
getting rid of trailing quote that is breaking sql

fixing error in product_count queries

    • -10
    • +0
    ./www/admin/products/list-postgresql.xql
fixed typo

adding noquote

fixing typo

adding limit / offset so product list handles catalogs with many items

    • -0
    • +17
    ./www/admin/products/list-oracle.xql
    • -0
    • +32
    ./www/admin/products/list-postgresql.xql
moving limit / offset filtering from tcl to db level to improve performance when many items are not yet categorized

updating category browsing to use the db limit / offset to improve performance capacity for cases with many parts per category or an external db

    • -1
    • +11
    ./www/category-browse-postgresql.xql
    • -0
    • +19
    ./www/category-browse-subcategory-oracle.xql
    • -1
    • +12
    ./www/category-browse-subcategory-postgresql.xql
    • -21
    • +24
    ./www/category-browse-subcategory.tcl
    • -0
    • +57
    ./www/category-browse-subsubcategory-oracle.xql
    • -0
    • +48
    ./www/category-browse-subsubcategory-postgresql.xql
    • -19
    • +23
    ./www/category-browse-subsubcategory.tcl
making the limit / offset at the db level instead of tcl, increasing performance capacity by magnitudes

    • -3
    • +31
    ./www/product-search-postgresql.xql
removing progress bar from here, because it is redundant, and status 6 already displayed on verfication page

fixing bug on orders that are fulfilled after being modified

correcting variable name, so that passed value prevents the progress bar from being displayed

getting category and subcategory breadcrumbs to follow through search

adding better handling for cases where display scope is out of range of results

making subsequent search text editable, based on current search text

making product search scale better by adding a simulated LIMIT / SET to the page output to limit search results to same number from ec parameter ProductsToDisplayPerPage used on other pages.

updating ssl procs to work with current config.tcl, clarifying annotations

more noquotes added

    • -1
    • +1
    ./www/category-browse-subsubcategory.adp
adding noquotes

    • -1
    • +1
    ./www/category-browse-subsubcategory.adp
adding noquote

adding noquote to recomendation var