select ec_order_cost(:order_id) as total_amount, creditcard_id
from ec_orders
where order_id = :order_id
select transaction_amount as total_amount, creditcard_id
from ec_financial_transactions
where transaction_id = :transaction_id
update ec_financial_transactions
set transaction_id = :pgw_transaction_id
where transaction_id = :transaction_id
update ec_financial_transactions
set transaction_id = :pgw_transaction_id
where transaction_id = :transaction_id
update ec_financial_transactions
set failed_p = 't'
where transaction_id = :transaction_id