package org.apache.cocoon.www.logic;

    import java.io.File;
    import java.io.IOException;
    import java.io.StringReader;
    //import java.net.*;
    import java.util.Date;
    import java.util.List;
    import java.util.Stack;

    //import org.w3c.dom.*;
    import org.xml.sax.InputSource;
    import org.xml.sax.SAXException;
    import org.xml.sax.helpers.AttributesImpl;

    //import org.apache.avalon.framework.*;
    import org.apache.avalon.framework.component.Component;
    import org.apache.avalon.framework.component.ComponentException;
    import org.apache.avalon.framework.component.ComponentManager;
    import org.apache.avalon.framework.component.ComponentSelector;
    import org.apache.avalon.framework.context.Context;
    import org.apache.avalon.excalibur.datasource.DataSourceComponent;
    //import org.apache.avalon.framework.util.*;

    import org.apache.cocoon.Constants;
    import org.apache.cocoon.ProcessingException;
    import org.apache.cocoon.components.parser.Parser;
    import org.apache.cocoon.generation.Generator;
    //import org.apache.cocoon.util.*;

    import org.apache.cocoon.components.language.markup.xsp.XSPGenerator;
    import org.apache.cocoon.components.language.markup.xsp.XSPObjectHelper;
    import org.apache.cocoon.components.language.markup.xsp.XSPRequestHelper;
    import org.apache.cocoon.components.language.markup.xsp.XSPResponseHelper;
    import org.apache.cocoon.components.language.markup.xsp.XSPSessionHelper;

    /* User Imports */
    
      import java.sql.DriverManager;
    
      import java.sql.Connection;
    
      import java.sql.Statement;
    
      import java.sql.PreparedStatement;
    
      import java.sql.CallableStatement;
    
      import java.sql.ResultSet;
    
      import java.sql.ResultSetMetaData;
    
      import java.sql.Struct;
    
      import java.sql.SQLException;
    
      import java.sql.Clob;
    
      import java.sql.Blob;
    
      import java.text.SimpleDateFormat;
    
      import java.text.DecimalFormat;
    
      import java.io.StringWriter;
    
      import java.io.PrintWriter;
    
      import java.io.BufferedInputStream;
    
      import java.io.InputStream;
    
      import java.util.Set;
    
      import java.util.List;
    
      import java.util.Iterator;
    
      import java.util.ListIterator;
    
      import java.math.BigDecimal;
    
      import java.sql.Struct;
    
      import java.sql.Types;
    
      import org.apache.cocoon.components.language.markup.xsp.EsqlHelper;
    
      import org.apache.cocoon.components.language.markup.xsp.EsqlQuery;
    
      import org.apache.cocoon.components.language.markup.xsp.EsqlConnection;
    
      import org.apache.cocoon.components.language.markup.xsp.EsqlConnectionCocoon2;
    
      import org.apache.cocoon.components.language.markup.xsp.XSPUtil;
    
      import org.apache.avalon.excalibur.datasource.DataSourceComponent;
    

    /**
     * Generated by XSP. Edit at your own risk, :-)
     */
    public class IDC2_info_int_xsp extends XSPGenerator {

        static {
            dateCreated = 1044022031535L;
            dependencies = new File[] {
          
            };
        }

        /* Built-in parameters available for use */
        // context    - ServletContext
        // request    - org.apache.cocoon.environment.Request
        // response   - org.apache.cocoon.environment.Response
        // parameters - parameters defined in the sitemap

        /* User Class Declarations */
        private Stack _esql_connections = new Stack();
    private EsqlConnectionCocoon2 _esql_connection = null;
    private Stack _esql_queries = new Stack();
    private EsqlQuery _esql_query = null;
    private SQLException _esql_exception = null;
    private StringWriter _esql_exception_writer = null;
  
            private static ComponentSelector _esql_selector = null;

            public void compose(ComponentManager manager) throws org.apache.avalon.framework.component.ComponentException {
              super.compose(manager);
              if (_esql_selector == null) {
                try {
                  _esql_selector = (ComponentSelector) manager.lookup(DataSourceComponent.ROLE + "Selector");
                } catch (ComponentException cme) {
                  getLogger().error("Could not look up the datasource component", cme);
                }
              }
            }
      

            protected void _esql_printObject ( Object obj, AttributesImpl xspAttr) throws SAXException
            {
               if ( obj instanceof List) {
           ListIterator j=((List)obj).listIterator();
           

    this.contentHandler.startElement(
      "",
      "sql-list",
      "sql-list",
      xspAttr
    );

    xspAttr.clear();

    
                       while (j.hasNext()){
                      

    xspAttr.addAttribute(
      "",
      "pos",
      "pos",
      "CDATA",
      String.valueOf(j.nextIndex())
    );
  

    this.contentHandler.startElement(
      "",
      "sql-list-item",
      "sql-list-item",
      xspAttr
    );

    xspAttr.clear();

    this._esql_printObject(j.next(),xspAttr);

    this.contentHandler.endElement(
      "",
      "sql-list-item",
      "sql-list-item");

    
    
                       };
                     

    this.contentHandler.endElement(
      "",
      "sql-list",
      "sql-list");

    
    
               } else if ( obj instanceof Set ) {
            Iterator j=((Set)obj).iterator();
            

    this.contentHandler.startElement(
      "",
      "sql-set",
      "sql-set",
      xspAttr
    );

    xspAttr.clear();

    
                        while (j.hasNext()){
                           

    this.contentHandler.startElement(
      "",
      "sql-set-item",
      "sql-set-item",
      xspAttr
    );

    xspAttr.clear();

    this._esql_printObject(j.next(),xspAttr);

    this.contentHandler.endElement(
      "",
      "sql-set-item",
      "sql-set-item");

    
    
                        };
                      

    this.contentHandler.endElement(
      "",
      "sql-set",
      "sql-set");

    
    
           } else {
              
        
        XSPObjectHelper.xspExpr(contentHandler, obj);
      ;
           }
        }
    
try{
    String timeOfDay = (new
SimpleDateFormat("MM/dd/yyyy")).format(request.getParameter("date"));
}catch(Exception e){}


      /**
       * Generate XML data.
       */
      public void generate() throws SAXException, IOException, ProcessingException {
            
            

            this.contentHandler.startDocument();
            AttributesImpl xspAttr = new AttributesImpl();

            
            
          this.contentHandler.startPrefixMapping(
            "xml",
            "http://www.w3.org/XML/1998/namespace"
          );
      
          this.contentHandler.startPrefixMapping(
            "xsp",
            "http://apache.org/xsp"
          );
      
          this.contentHandler.startPrefixMapping(
            "xspdoc",
            "http://apache.org/cocoon/XSPDoc/v1"
          );
      
          this.contentHandler.startPrefixMapping(
            "esql",
            "http://apache.org/cocoon/SQL/v2"
          );
      
        this.contentHandler.startPrefixMapping(
          "xsp-request",
          "http://apache.org/xsp/request/2.0"
        );
      

    this.contentHandler.startElement(
      "",
      "dataset",
      "dataset",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t");
      
    if (_esql_connection != null) {
      _esql_connections.push(_esql_connection);
    }
    _esql_connection = new EsqlConnectionCocoon2();
    try {
      
          try {
            _esql_connection.datasource = (DataSourceComponent) _esql_selector.select(String.valueOf(
      ""
      
              
                + "IDC2_int"
              ));
            _esql_connection.connection = _esql_connection.datasource.getConnection();
            
          } catch (Exception _esql_exception_N10011) {
            getLogger().error("Could not get the datasource",_esql_exception_N10011);
            throw new RuntimeException("Could not get the datasource "+_esql_exception_N10011);
          }
        
      try {
        if ("false".equals(String.valueOf(""))) {
          if (_esql_connection.getAutoCommit()) {
            _esql_connection.setAutoCommit(false);
          }
        } else {
          if (!_esql_connection.getAutoCommit()) {
            _esql_connection.setAutoCommit(true);
          }
        }
      } catch (Exception _esql_exception_N10011) {
        // do NOT: throw new RuntimeException("Error setting connection autocommit");
      }
      
        this.characters("\n\t\t\t");
      
        this.characters("\n\t\t\t");
      
    if (_esql_query != null) {
      _esql_queries.push(_esql_query);
    }
    _esql_query = new EsqlQuery( _esql_connection, String.valueOf(
      ""
      
              
                + "          select * from info_bericht  where country ='"
              
              
                + 
        
        (
          (XSPRequestHelper.getParameter(objectModel,
          "GETcountry", null,
          null,
          null))
        )
      
              
                + "' "
              
              
                + "          "
              ) );

    

    try {
      
          _esql_query.createStatement();
          _esql_query.execute();
        
      getLogger().debug("esql query: " + _esql_query.getQueryString());

      
  do {
     if (_esql_query.hasResultSet()) {
        _esql_query.getResultRows();
        if (_esql_query.nextRow()) {
           switch (_esql_query.getResultCount()) {
           
             case 1: 
             default: 
        this.characters("\n\t\t\t\t\t");
      
    do {
      
        this.characters("\n\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "client",
      "client",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "rest",
      "rest",
      xspAttr
    );
    xspAttr.clear();

    
        
        XSPObjectHelper.xspExpr(contentHandler, timeOfDay );
      
        this.characters("\t");
      

    this.contentHandler.endElement(
      "",
      "rest",
      "rest"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "address",
      "address",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "bname1",
      "bname1",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"business_name")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "bname1",
      "bname1"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "bname2",
      "bname2",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"business_name_2")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "bname2",
      "bname2"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "street",
      "street",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"address")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "street",
      "street"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "street2",
      "street2",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"address_2")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "street2",
      "street2"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "ZIP",
      "ZIP",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"zip_code")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "ZIP",
      "ZIP"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "City",
      "City",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"city")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "City",
      "City"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "country",
      "country",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"country")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "country",
      "country"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "telephone_number",
      "telephone_number",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"telephone_number")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "telephone_number",
      "telephone_number"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "address",
      "address"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "ap",
      "ap",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "salutation",
      "salutation",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"salutation")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "salutation",
      "salutation"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "titel",
      "titel",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"titel")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "titel",
      "titel"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "forename",
      "forename",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"forename")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "forename",
      "forename"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "surname",
      "surname",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"surname")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "surname",
      "surname"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "textension",
      "textension",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"direct_dial_")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "textension",
      "textension"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "ap",
      "ap"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "aktion",
      "aktion",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "PI",
      "PI",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, _esql_query.getResultSet().getInt("PI"));
      
        this.characters("\n\t\t\t\t\t");
      
        this.characters("\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "PI",
      "PI"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Muster",
      "Muster",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, _esql_query.getResultSet().getInt("Muster"));
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Muster",
      "Muster"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Rueckruf",
      "Rueckruf",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, _esql_query.getResultSet().getInt("Rueckruf"));
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Rueckruf",
      "Rueckruf"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Angebot",
      "Angebot",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, _esql_query.getResultSet().getInt("Angebot"));
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Angebot",
      "Angebot"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Infotext_adm",
      "Infotext_adm",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"Info_text_adm")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Infotext_adm",
      "Infotext_adm"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Infotext_idm",
      "Infotext_idm",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"Info_text_idm")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Infotext_idm",
      "Infotext_idm"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "Info_datum",
      "Info_datum",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, _esql_query.getResultSet().getDate("Info_datum"));
      
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "Info_datum",
      "Info_datum"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "aktion",
      "aktion"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "WD",
      "WD",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "to",
      "to",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "name",
      "name",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"to_name")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "name",
      "name"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "email",
      "email",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"to_email")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "email",
      "email"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "branch",
      "branch",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"to_country")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "branch",
      "branch"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "to",
      "to"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "cc",
      "cc",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "cc_name",
      "cc_name",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"cc_name")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "cc_name",
      "cc_name"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.startElement(
      "",
      "cc_email",
      "cc_email",
      xspAttr
    );
    xspAttr.clear();

    
        this.characters("\n\t\t\t\t\t\t\t\t\t\t");
      
        
        XSPObjectHelper.xspExpr(contentHandler, 
      EsqlHelper.getAscii(_esql_query.getResultSet(),"cc_email")
    );
      
        this.characters("\n\t\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "cc_email",
      "cc_email"
    );

    
        this.characters("\n\t\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "cc",
      "cc"
    );

    
        this.characters("\n\t\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "WD",
      "WD"
    );

    
        this.characters("\n\t\t\t\t\t\t");
      

    this.contentHandler.endElement(
      "",
      "client",
      "client"
    );

    
        this.characters("\n\t\t\t\t\t");
      
  //checking out early?
    if (_esql_query.getMaxRows() != -1 && _esql_query.getCurrentRow() - _esql_query.getSkipRows() == _esql_query.getMaxRows()) {
      _esql_query.setKeepGoing( false );
    } else {	//if not, advance normally
      _esql_query.setKeepGoing( _esql_query.nextRow() );
    }
    
    } while ( _esql_query.keepGoing() );

    if (_esql_query.getSkipRows() > 0 ) {
        
    }

    if (_esql_query.nextRow()) {
        
    }
  
        this.characters("\n\t\t\t\t");
      
                 break;
           
           }
        } else {
           switch (_esql_query.getUpdateCountCount()) {
           
             case 1: 
           default: 
                 break;
           
           }
        }
        _esql_query.getResultSet().close();
     } else {
        if (_esql_query.getUpdateCount() > 0) {
           switch (_esql_query.getUpdateCountCount()) {
           
           }
        } else {
           switch (_esql_query.getUpdateCountCount()) {
           
             case 1: 
             default: 
                 break;
           
           }
        }
     }
   } while(_esql_connection.multipleResults() && _esql_query.getMoreResults());


      _esql_query.getStatement().close();

    } catch (SQLException _esql_exception_N10019) {
        
          try {
            _esql_exception = _esql_exception_N10019;
            _esql_exception_writer = new StringWriter();
            _esql_exception.printStackTrace(new PrintWriter(_esql_exception_writer));
            
            if (!_esql_connection.getAutoCommit()) {
              _esql_connection.rollback();
            }
          } catch (Exception _esql_exception_N10019_2) {}
          
    }
    if (_esql_queries.empty()) {
      _esql_query = null;
    } else {
      _esql_query = (EsqlQuery)_esql_queries.pop();
    }
  
        this.characters("\n\t\t");
      
    } finally {
      try {
        if(!_esql_connection.getAutoCommit()) {
          _esql_connection.commit();
        }
        _esql_connection.close();
        if (_esql_connections.empty()) {
          _esql_connection = null;
        } else {
          _esql_connection = (EsqlConnectionCocoon2)_esql_connections.pop();
        }
      } catch (Exception _esql_exception_N10011) {}
    }
  
        this.characters("\n\t");
      

    this.contentHandler.endElement(
      "",
      "dataset",
      "dataset"
    );

    
      this.contentHandler.endPrefixMapping(
        "xsp-request"
      );
      
      this.contentHandler.endPrefixMapping(
        "xml"
      );
      
      this.contentHandler.endPrefixMapping(
        "xsp"
      );
      
      this.contentHandler.endPrefixMapping(
        "xspdoc"
      );
      
      this.contentHandler.endPrefixMapping(
        "esql"
      );
      

            this.contentHandler.endDocument();
        }
    }