Does db_multirow have the ability to execute code for each row? That would be the best place to do this. If I use db_foreach, I have to build the arrays by hand. My query is something like:
select
s.shipment_id,
s.tracking_number,
... (other fields),
sm.tracking_url
from
ms_shipments s,
ms_shipping_methods sm
...
The main cause of the problem is requiring the use of an array variable to access the current array name.
Having a tcl code block in db_multirow would also solve the problem. I agree 100% using tcl in the adp template is very bad.
