/* PAGE DESCRIPTION: A list of transaction information for transactions that matched the parameters of the last-run query is printed to the screen. */ registerLivePayment(); // Select transactions from the LP_PURCHASE table who's id's match // the id's stored in the LP_MATCHQUERY table`. LP_MATCHQUERY contains id's // of transactions resulting from the last query. // cursor = database.cursor("select * from LP_MATCHQUERY, LP_PURCHASE where LP_PURCHASE.ID=LP_MATCHQUERY.ID order by LP_MATCHQUERY.ID"); Transactions that Matched your Query // write out the total number of query matches if (request.hits != null) { write("

" + request.hits); if (request.hits == "1") write(" transaction "); else write(" transactions "); write("matched your query.

\n"); }

Click on an ID to see detailed more information on that transaction.

while(cursor.next()) { } cursor.close(); QueryCleanup();
ID Status Card Type Amount
write("" + cursor.id + ""); write(cursor.status); write(GetCardType(cursor.slipid)); write(cursor.amount);

Return to the Query Page.