|
<%
printClass = "categoryAdText";
locationCd = "BODY";
catMediaDisp.createCatMediaDisp(catalogId, catSecCd,subCatSecCd,subSubCatSecCd, out, conn, printClass,locationCd,sc);
out.flush();
%>
|
|
<% leftColumn.display(catalogId,catSecCd,subCatSecCd,subSubCatSecCd,out,request,conn,sc,r_urlBeginning,session,response); %>
|
<%
printClass = "categoryAdText";
locationCd = "BODY1";
catMediaDisp.createCatMediaDisp(catalogId, catSecCd, subCatSecCd, subSubCatSecCd, out, conn, printClass,locationCd,sc);
%>
<%
Catalog catalog = new Catalog(conn, "CWOL");
catalog.setSections(conn, -1, "A"); // -1: All sections regardless of parentId. A: Only Active sections
// Inspiration is the parent section.
int sectionId = Integer.parseInt(catalog.getSectionIdByTitle("INSPIRATION"));
boolean includeArticles = true;
boolean includeUMedia = false;
Section mySection = new Section(conn, sectionId,includeArticles,includeUMedia);
System.out.println("cwol.leftColumn(): section: " + sectionId);
mySection.setArticles(conn, 99, true);
ArrayList sectionArticles = mySection.getArticles();
boolean includeText = false;
boolean includeSections = false;
boolean includeUmedia = false;
int memberId = 0;
System.out.println("sectionArticles.size(): " + sectionArticles.size());
if (sectionArticles.size() > 0){
int max = sectionArticles.size() < 2 ? sectionArticles.size() : 1 ;
for (int i = 0; i < max ; i++) {
Article art = new Article(conn, Integer.parseInt((String)sectionArticles.get(i)),includeText,includeSections,includeUmedia);
out.write("");
out.write("");
out.write(art.getHeadline().trim());
out.write("");
out.write("");
out.write("
");
out.write("");
out.write(art.getTeaser().trim());
out.write("");
out.write(" ");
out.write("more");
out.write("");
out.write("
");
}
}
%>
<%
printClass = "categoryAdText";
locationCd = "BODY2";
catMediaDisp.createCatMediaDisp(catalogId, catSecCd, subCatSecCd, subSubCatSecCd, out, conn, printClass,locationCd,sc);
%>
<%
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String maxItemsToShow = "5";
String tmpCatSecCd = "FWT";
String sql = "";
String r_tid = request.getParameter("tid");
if (r_tid == null) {
r_tid = "";
}
if (!r_tid.equals("")) {
r_tid = r_tid + "ZZ";
}
// rownum is not accurate unless you use it outside of your query
// http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html
sql += "select * from (";
sql += "select item_id, subcatsec_cd, subsubcatsec_cd ";
sql += "from live.catdtlv8t ";
sql += "where ";
sql += "catalog_id = '" + catalogId.trim() + "' ";
sql += "and catsec_cd = '" + tmpCatSecCd.trim() + "' ";
sql += "order by web_post_date desc";
sql += ")";
sql += "where rownum <= " + maxItemsToShow + " ";
// out.write(sql);
ResultSet rs2 = stmt.executeQuery(sql);
String itemId = "";
String href = "";
itemDisp itemDisp = new itemDisp();
while (rs2.next()){
itemId = rs2.getString("item_id");
itemElements itemE = new itemElements(itemId, conn, r_tid);
String[] blurb = itemDisp.getAnInform(conn, itemId, "BLRBAD");
if (!blurb[1].equalsIgnoreCase("NA")) {
out.write("\n");
out.write("
");
}
}
printClass = "categoryAdText";
locationCd = "BODY3";
catMediaDisp.createCatMediaDisp(catalogId, catSecCd, subCatSecCd, subSubCatSecCd, out, conn, printClass,locationCd,sc);
%>
|
|
|
<% rightColumn.display(catalogId,catSecCd,subCatSecCd,subSubCatSecCd,out,conn,sc,r_urlBeginning, true); %>
|