[ic] Build_related.html selecting deleted orderlines - fix

[interchange-users@interchange.redhat.com (Marty Tennison)]

Hi List,

In case anyone wants it. I've modified build_related.html to not select rows
from orderline table that have a corresponding deleted record in
transactions. (ie, do not count deleted orders as valid)

Look for the build_related.html file.
Find this line.

select code,order_number,sku,username from orderline

Replace it with this line.

select
UCASE(orderline.code),UCASE(orderline.order_number),UCASE(orderline.sku),ord
erline.username
from orderline, transactions
where  UCASE(transactions.code) = UCASE(orderline.order_number)
and transactions.deleted <> 1;

Thats it.

Marty Tennison
Developer
www.sediva.com