Zen Cart Logo
Forums / Addon Shipping Modules / UPS XML Worldship 9.0

UPS XML Worldship 9.0

Locked

Views: 1,388

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
16 Feb 2009, 5:14 PM
#1
spilker avatar

spilker

New Zenner

Join Date:
Feb 2009
Posts:
1
Plugin Contributions:
0

UPS XML Worldship 9.0

Zen 1.38a

When I try to sort orders by less than or equal to from the admin I get SQL errors:

[SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_purchased, o.order_total, s.orders_status_name FROM orders o LEFT JOIN orders_status s ON o.orders_status = s.orders_status_id WHERE s.language_id = '1' AND o.order_total '16' ORDER BY o.orders_id DESC]

The proper sign = or < doesn't put into the SQL properly.
The &ot_sign=<%3D look fine in the url... Im stumped.

This is where it is at in tools_ups_worldship.php

$ot_sign = array();
$ot_sign[] = array('id' => '>=',
'text' => ' > ' . DROPDOWN_GREATER_THAN);
$ot_sign[] = array('id' => '<=',
'text' => ' < ' . DROPDOWN_LESS_THAN);
$ot_sign[] = array('id' => '==',
'text' => ' = ' . DROPDOWN_EQUAL_TO);

Is anyone else having this problem?