Index: openacs-4/packages/authorize-gateway/www/admin/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/authorize-gateway/www/admin/index-postgresql.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/authorize-gateway/www/admin/index-postgresql.xql 21 May 2002 18:36:25 -0000 1.1 +++ openacs-4/packages/authorize-gateway/www/admin/index-postgresql.xql 16 Dec 2003 19:21:50 -0000 1.2 @@ -1,32 +1,32 @@ - - - - postgresql7.1 - - - - txn_attempted_time + '1 days'::interval > now() - - - - - - txn_attempted_time + '7 days'::interval > now() - - - - - - txn_attempted_time + '1 months'::interval > now() - - - - - - select transaction_id, to_char(txn_attempted_time, 'MM-DD-YYYY HH24:MI:SS') as txn_time, txn_attempted_type, response, response_code, response_reason_code, response_reason_text, auth_code, avs_code, amount - from authorize_gateway_result_log - where '1'='1' [ad_dimensional_sql $dimensional] [ad_order_by_from_sort_spec $orderby $table_def] - - - - \ No newline at end of file + + + + postgresql7.1 + + + + txn_attempted_time + '1 days'::interval > now() + + + + + + txn_attempted_time + '7 days'::interval > now() + + + + + + txn_attempted_time + '1 months'::interval > now() + + + + + + select transaction_id, to_char(txn_attempted_time, 'MM-DD-YYYY HH24:MI:SS') as txn_time, txn_attempted_type, response, response_code, response_reason_code, response_reason_text, auth_code, avs_code, amount + from authorize_gateway_result_log + where '1'='1' [ad_dimensional_sql $dimensional] [ad_order_by_from_sort_spec $orderby $table_def] + + + +