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.3 -r1.4
--- openacs-4/packages/authorize-gateway/lib/one.tcl	8 Sep 2008 11:53:46 -0000	1.3
+++ openacs-4/packages/authorize-gateway/lib/one.tcl	8 Sep 2008 12:15:19 -0000	1.4
@@ -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')"
+      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"
 
 if { [info exists response_reason_text] && [info exists avs_code] } {
     # decode left most avs_code. Second character is card CVV2/CVC2/CID code response