POE Paste with lovely alien head...

No paste!

from "mmorgan" at 64.57.241.14
Cancel invalid transits

format options below
update action.transit_copy
set cancel_time = now()
where id in
(
SELECT atc.id
FROM action.transit_copy atc
join asset.copy ac on atc.target_copy = ac.id
WHERE dest_recv_time IS NULL AND cancel_time IS NULL
and ac.status != 6
)





perl stuff: (might be helpful for others but not perfect)



Valid HTML 4.01!

Pastebot is powered by POE.