<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <%@ include file="Connections/con_ro_mnsl.jsp" %> <%! public String DoDateTime(java.lang.Object aObject,int nNamedFormat,java.util.Locale aLocale) throws Exception{ if ((aObject != null) && (aObject instanceof java.util.Date)){ if (aLocale!=null){ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat,aLocale); return df.format(aObject); } else{ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat); return df.format(aObject); } } return ""; } %> <% String country="$$"; String port="$$"; Driver Driverrc = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrc = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrc = Connrc.prepareStatement("SELECT * FROM dbo.view_flag where st='A'order by fg",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrc.setFetchSize(0); Statementrc.setQueryTimeout(0); ResultSet rc = Statementrc.executeQuery(); boolean rc_isEmpty = !rc.next(); boolean rc_hasData = !rc_isEmpty; Object rc_data; int rc_numRows = 0; %> <% String rp__MMColParam = "%"; if (request.getParameter("cntry") !=null) {rp__MMColParam = delim((String)request.getParameter("cntry"));} %> <% Driver Driverrp = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrp = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrp = Connrp.prepareStatement("SELECT * FROM dbo.view_agents WHERE fid LIKE '" + rp__MMColParam + "' AND zz=1 order by fg,pnm,nm",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrp.setFetchSize(0); Statementrp.setQueryTimeout(0); ResultSet rp = Statementrp.executeQuery(); boolean rp_isEmpty = !rp.next(); boolean rp_hasData = !rp_isEmpty; Object rp_data; int rp_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; rp_numRows += Repeat1__numRows; %> MNSL - Agents & Offices
<%@ include file="globalnav.jsp" %>
Agents & Offices

 
   
   
<% while ((rp_hasData)&&(Repeat1__numRows-- != 0)) { %> <%if(!country.equals((String)(((rp_data = rp.getObject("fg"))==null || rp.wasNull())?"":rp_data))){ country=(String)(((rp_data = rp.getObject("fg"))==null || rp.wasNull())?"":rp_data); %> <%}%> <%if(!port.equals((String)(((rp_data = rp.getObject("pnm"))==null || rp.wasNull())?"":rp_data))){ port=(String)(((rp_data = rp.getObject("pnm"))==null || rp.wasNull())?"":rp_data); %> <%}%> <% Repeat1__index++; rp_hasData = rp.next(); } %>
<% if (rp_isEmpty ) { %> Search returned no Agents or Offices <% } /* end rp_isEmpty */ %>

<%=(((rp_data = rp.getObject("fg"))==null || rp.wasNull())?"":rp_data)%>
<%=(((rp_data = rp.getObject("pnm"))==null || rp.wasNull())?"":rp_data)%>

<%=((String)(((rp_data = rp.getObject("nm"))==null || rp.wasNull())?"":rp_data))%>
<%=Wrap((String)(((rp_data = rp.getObject("add0"))==null || rp.wasNull())?"":rp_data))%>
email:"><%=(((rp_data = rp.getObject("email"))==null || rp.wasNull())?"":rp_data)%>
website:"><%=(((rp_data = rp.getObject("web"))==null || rp.wasNull())?"":rp_data)%>

 

 

 

 

 

 

 
<%@include file="footer.jsp"%>
<% rc.close(); Statementrc.close(); Connrc.close(); %> <% rp.close(); Statementrp.close(); Connrp.close(); %> <%@ include file="__notice.jsp" %>