<%@ page language="java" import="java.util.*,java.sql.*,javax.servlet.http.*" %> <%@ include file="application.jsp" %> <%@ include file="/shared/funcLibrary.jsp" %> <% String r = getParamValue(request.getParameter("r")); // update listing no of clicks count, latest date ikBlist.reset(); ikBlist.setKeyFieldName("recNo"); ikBlist.setKeyValue(""+r); if (ikBlist.retrieve() == 0) { out.print("Unable to retrieve listing " + r ); return; } ikBlist.setNoOfClicks(ikBlist.getNoOfClicks() + 1); ikBlist.setLatestClickDate(todayDateString()); ikBlist.update(); response.sendRedirect(ikBlist.getUrl()); ikBlist.cleanup(); dbConnection.shutDown(); %>