|
<% leftColumn.display(catalogId,catSecCd,subCatSecCd,subSubCatSecCd,out,request,conn,sc,r_urlBeginning,session,response); %>
|
<%
printClass = "categoryAdText";
locationCd = "BODY";
catMediaDisp.createCatMediaDisp(catalogId, catSecCd, subCatSecCd, subSubCatSecCd, out, conn, printClass,locationCd,sc);
%>
This is a list of people who are participating in the Consuming Worship community.
| Name |
City |
State |
| |
|
|
<%
String sql = "";
sql += "select * ";
sql += "from live.cstmrparm cp, live.cstmrv8t c ";
sql += "where ((cp.generic_id = c.cstmr_id ";
sql += " and cp.generic_id_type_cd = 'C' ) ";
sql += "or (cp.generic_id = c.user_id ";
sql += "and cp.generic_id_type_cd = 'U')) ";
sql += "and cp.attribute_name = 'CWOL-MEMBERDIRECTORY' ";
sql += "and cp.attribute_value = 'Y' ";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
int index = 0;
while (rs.next()) {
String style = (index % 2 == 1) ? "bbsNormalTextBgTint" : "";
String formalName = rs.getString("formal_name");
String city = rs.getString("city");
String state = rs.getString("state");
%>
| <%=formalName.toLowerCase()%> |
<%=city.toLowerCase()%> |
<%=state%> |
<%
index ++;
}
%>
|
<% rightColumn.display(catalogId,catSecCd,subCatSecCd,subSubCatSecCd,out,conn,sc,r_urlBeginning, true); %>
|
| |
<%
footer.display(out,conn,catalogId);
manager.returnConnection(conn);
%>
|
|