Index: openacs-4/packages/authorize-gateway/lib/one.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/authorize-gateway/lib/one.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/authorize-gateway/lib/one.tcl	8 Sep 2008 12:15:19 -0000	1.4
+++ openacs-4/packages/authorize-gateway/lib/one.tcl	8 Sep 2008 12:24:33 -0000	1.5
@@ -10,7 +10,7 @@
 # get transaction log comments. 
 db_0or1row get_transaction_comments "select response_reason_text, avs_code
       from authorize_gateway_result_log 
-      where transaction_id = :transaction_id and amount = :amount and (substr(txn_attempted_type,1,9) = 'AUTH_ONLY' or substr(txn_attempted_type,1,12) = 'AUTH_CAPTURE') and response_reason_text is not null and avs_code is not null limit 1"
+      where transaction_id = :transaction_id and amount = :amount and (substr(txn_attempted_type,1,9) = 'AUTH_ONLY' or substr(txn_attempted_type,1,12) = 'AUTH_CAPTURE') and response_reason_text is not null and avs_code is not null order by txn_attempted_time desc limit 1"
 
 if { [info exists response_reason_text] && [info exists avs_code] } {
     # decode left most avs_code. Second character is card CVV2/CVC2/CID code response