gavinbaumanis
06/05/2022, 8:18 AMpothys-mitrahsoft
06/05/2022, 9:36 AMAdam Cameron
Adam Cameron
mike42780
06/05/2022, 7:13 PMpaolo79
06/21/2022, 9:17 AMAdam Cameron
paolo79
06/23/2022, 11:05 AMvar shipUtils = createobject"component","shipUtils").init();
local.q_orders = queryExecute('
SELECT *
FROM TABLE_ORDERS
WHERE "_businessKey" = :businessKey
', {businessKey = {cfsqltype = "varchar", value = arguments.businessKey}});
queryEach(local.q_orders, function(row, rowIndex, query) {
local.q_ship = shipUtils.get(bordero = row.BORDERO);
}