<%@page contentType="text/html; charset=iso-8859-1" session="true" language="java" %> <%@page import="java.sql.Connection" %> <%@page import="java.sql.PreparedStatement" %> <%@page import="java.sql.ResultSet" %> <%@page import="com.connection.*" %> .:www.riveredace.com:.Home <% HttpSession sesion = request.getSession(true); Connection c = null; AbstractConnector conn = new QogsDbConnector(); String marqueeTxt = ""; try{ c = conn.getConnection(); PreparedStatement ps = c.prepareStatement("SELECT data FROM Datamap WHERE itemId = 1 "); ResultSet rs = ps.executeQuery(); if(rs.next()){ marqueeTxt = rs.getString(1); } rs.close(); ps.close(); }catch(Exception e){ try { if(c != null){ c.rollback(); } } catch (Exception e1) { System.out.println("Database problems, contact tecnichal support."); } System.out.println(e.getMessage()); out.println("Database problems, contact tecnichal support."); } finally{ try { if(c != null){ c.close(); } } catch (Exception e) { System.err.println(e.getMessage()); } } %>
<%out.println(marqueeTxt); %>
The States of:

Alaska, Arizona, California, Connecticut, Delaware, Florida, Hawaii, Illinois, Iowa, Kansas, Kentucky, Louisiana, Maine, Massachusetts, Mississippi, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, Oregon, Pennsylvania, Rhode Island, Utah, Vermont, Virginia, West Virginia, Wisconsin, Wyoming, District of Columbia.

The Countries of:

Argentina, Australia, Brazil, Canada, Egypt, Finland, France, Germany, India, Mexico, Norway, South Africa, Spain, Sweden, Switzerland and the United Kingdom.