<%@ page import="java.sql.*" %> <%@ include file="/dbconn/dbconn.inc" %> <% String query = "Select * from content WHERE guid=?"; java.sql.PreparedStatement RCstmt = conn.prepareStatement(query); RCstmt.setString(1, request.getParameter("rockclimbing")); java.sql.ResultSet RCrs = RCstmt.executeQuery(); String img = ""; while(RCrs.next()) { String id = RCrs.getString("guid"); String imgSml = RCrs.getString("path"); String imgTmp = RCrs.getString("path_large"); if (imgTmp != null){ img = imgTmp; } else { img = imgSml; } String content_title = RCrs.getString("content_title").trim(); String content_abstract = RCrs.getString("content_abstract").trim(); String content_body = RCrs.getString("content_body"); String pub_date = RCrs.getString("pub_date"); %> <%=content_title%>
<%=content_title%>
<%=content_body%> <%} RCrs.close(); RCstmt.close(); %>
<% String queryChild = "Select * from content WHERE parent_id=?"; java.sql.PreparedStatement Childstmt = conn.prepareStatement(queryChild); Childstmt.setString(1, request.getParameter("rockclimbing")); java.sql.ResultSet Childrs = Childstmt.executeQuery(); while(Childrs.next()) { String guid = Childrs.getString("guid"); String child_title = Childrs.getString("content_title"); %>
<%=child_title%> <% } Childrs.close(); Childstmt.close(); %>

Copyright Chuck Quinton 2005, All Rights Reserved

<%@ include file="/includes/header.jsp" %> <%@ include file="/includes/left_nav.jsp" %>