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