Dag Corell

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_datediff

Take a look at HttpServletRequestWrapper and HttpServletResponseWrapper.
Might be what your looking for...

The first call to matrixResultSet.next() would return false.

Code something like this..
if(!matrixResultSet.next()){ menuString.append(","); } else { do { String parentModuleName = matrixResultSet.getString("MOD_CODE"); logger.debug("this.renderURL"+this.renderURL); menuString.append("[null,'Home','"+this.renderURL+"/index.jsp',null,null,"); logger.debug(parentModuleName); this.makeMenu(parentModuleName, appCode, userId, con); menuString.append("] "); } while (matrixResultSet.next()); }