Select City:


<%@ page autoFlush='true' contentType="text/html; charset=iso-8859-1" language="java" %> <%@ page import="java.sql.*"%> <%@ page import="java.util.*"%> <%@ page import="java.io.*"%> <%@ page import="java.net.*"%> <%@page isELIgnored="false" %> <%-- //-------------------------------------------------------------------------- Variable Declarations //-------------------------------------------------------------------------- --%> <%@ include file='basicdb.jsp' %> <%! int getMaxwidth(String imgURL) { java.awt.Toolkit tool = java.awt.Toolkit.getDefaultToolkit(); java.awt.Image image = tool.getImage(imgURL); int width = image.getWidth(null); if (width>300) return 300; else return width; } %> <% //Connect to Database Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(url, user, password); PreparedStatement stmt = conn.prepareStatement ("SELECT OrganizationName, Address, Phone, Email, LinkURL, LogoURL, PictureURL, Timings, Details, City, State, ZipCode, Contact, SubCategory, MenuItem, SiteID from tblContent2 where RecordID=?"); String recordID = request.getParameter ("rec"); stmt.setString (1, recordID); ResultSet rs = stmt.executeQuery(); //stmt.executeQuery(); out.println ("
    "); if (rs.next()) { String orgName = rs.getString(1); String subCat = rs.getString (14); String menuItem = rs.getString (15); String cityID = rs.getString (16); String articleType = ((subCat.indexOf("Restaurant")!=-1)?"Restaurant":((menuItem.indexOf("Store")!=-1)?"Store":"Organization")); %>
    <%=rs.getString(1)%>
    <% String imgURL = rs.getString(6); if ((imgURL != null) && (imgURL.length()>5)) { %> style='max-width:300;' oncontextmenu='javascript:/*alert("Arre arre...yeh kya kar rahe ho? What would your mother say?");*/ return false;'> <% } String hours = ""; if ((hours=rs.getString(8)) != null) { if (hours.length()>0) { %> Hours:
    <%=hours%>
    <% } } %> Address:
    <%=rs.getString(2)%>
    <%=rs.getString(10)%>, <%=rs.getString(11)%> <%=rs.getString(12)%>
    Map Directions
    Recommend

    <%=rs.getString (9)%>
    Contact: <%=(((rs.getString(13) != null) && (rs.getString(13).length()>2))?("
    "+rs.getString(13)):"")%>
    Phone: <%=rs.getString (3) %>
    Website


    Your Comments
    <% String filename = "../comments/RetrieveComments.jsp?cid=" + recordID + "&cmtType=" + articleType; %>
    <% } } catch (Exception e) { out.println (e); } %>

    news
    Copyright© indogram.com, 2000-2007. All rights reserved.







































    Indogram