[ic] Returns not showing up

[Martin Abell]

Using 4.6.5, when I click on "Order Tracking" or "Order Returns" on the
Customer Service page, no orders are ever found.  Anyone figure this out?
(Could find nothing in archive.)

The returns.html page has this code in it:
---------------------------------------
[query st=db arrayref=orders
        sql="SELECT
            
code,status,nitems,subtotal,shipping,handling,total_cost,payment_method,orde
r_date
            FROM transactions
            WHERE username = '[data base=session field=username filter=sql]'
            ORDER by code
        "][/query]

[mvasp tables=transactions]

-------------------------------------------
But the arrayref that gets back to the asp-like code that follows seems not
to have anything in it. (There are many orders in the transactions file for
the username in question.)  Any clues?

Martin
SpeedSpan.