<%@ include file="head_d.jsp" %> <% ResultSet rsInfo = null; try { Statement stmtInfo = con.createStatement(); con.setAutoCommit( false ); // important !!!! String qstr = "SELECT infoTitle,infoText,infoLoc,infoDate,infoID,datemodif,dateshow,datehide,infoAuthor "+ "FROM info "+ "WHERE dateshow <= '"+new java.sql.Date(new java.util.Date().getTime())+"' " + "AND datehide >'"+new java.sql.Date(new java.util.Date().getTime() - 86400000 )+"' " + "AND public = 1 " + "AND security = 0 " + "ORDER BY datemodif DESC"; rsInfo = stmtInfo.executeQuery( qstr ); con.commit(); con.close(); } // try catch( Exception e ) { System.out.println( "Info Error "+e.toString() ); con.close(); } %> <%@ include file="/menul_d.jsp" %>

Aktuell

<% rsInfo.beforeFirst(); while ( rsInfo.next() ) { %>

<%=rsInfo.getString( "infoTitle" )%>
', 'Info')">»Detail
<% if( rsInfo.getString( "infoLoc" ).length() > 2 ) { %> <%=rsInfo.getString( "infoLoc" )%> <% } if( rsInfo.getString( "infoDate" ).length() > 2 ) { %> <%=rsInfo.getString( "infoDate" )%> <% } } %>

<%@ include file="foot_d.jsp" %>