Examples of com.knowgate.dataobjs.DBSubset.toXML()

com.knowgate.dataobjs.DBSubset.toXML()

Write DBSubset to an XML string
@param sIdent Initial space identations on the left for fields @param sNode Name of top parent node. If null then main table namefor this DBSubset is used. @param sDateFormat Output format for date values @param sDecimalFormat Output format for decimal and floating point values @return XML string dump of the whole DBSubset pre-loaded data.

        } // next (c)


        oCon.close("CallsTab");
        oCon = null;


        sXML += "<calls>\n"+oCalls.toXML("","call")+"</calls>";
      }
      catch (SQLException e) {
        sXML += "<calls/>";


        try {

View Full Code Here

    DBSubset oAddrs = new DBSubset(DB.k_addresses + " a," + DB.k_x_company_addr + " x",
                                   oColumnList.toString(), "a." + DB.gu_address + "=x." + DB.gu_address + " AND x." + DB.gu_company + "=? ORDER BY a." + DB.ix_address, 10);


    oAddrs.load(oConn, new Object[]{sCompanyGUID});


    String sAddresses = "\n  <company>" + sCompanyGUID + "</company>\n  <catalog>" + sCategoryGUID + "</catalog>\n  <addresses>\n" + oAddrs.toXML("    ", "address") + "\n  </addresses>";


    try { oXMLDoc.removeNode("pageset/company"); }
    catch (DOMException dome) {
      if (dome.code!=DOMException.NOT_FOUND_ERR) throw new DOMException(dome.code, dome.getMessage());
    }

View Full Code Here

  public static String XMLListBugs(JDCConnection oConn, String[] aStatus,
                     String sWorkAreaId, String sUserId,
                     String sDateTimeFormat, String sOrderBy)
    throws SQLException,IllegalArgumentException {
  DBSubset oDbss = Projects.getBugs(oConn, aStatus, sWorkAreaId, sUserId, sOrderBy);
    return "<Bugs count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","Bug",sDateTimeFormat, null)+"</Bugs>";
  } // XMLListOpenBugs


  // --------------------------------------------------------------------------


  public static String XMLListDuties(JDCConnection oConn, String[] aStatus,

View Full Code Here


  public static String XMLListDuties(JDCConnection oConn, String[] aStatus,
                     String sWorkAreaId, String sUserId, String sDateTimeFormat, String sOrderBy)
    throws SQLException,IllegalArgumentException {
  DBSubset oDbss = Projects.getDuties(oConn, aStatus, sWorkAreaId, sUserId, sOrderBy);
    return "<Duties count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","Duty",sDateTimeFormat, null)+"</Duties>";
  } // XMLListPendingDuties


  // --------------------------------------------------------------------------
  
}

View Full Code Here

      DebugFile.incIdent();
    }


    StringBuffer oStrBuff = new StringBuffer(4000);
    oStrBuff.append("<NewsGroupTags>\n");
  oStrBuff.append(oTags.toXML("  ","NewsGroupTag"));
    oStrBuff.append("</NewsGroupTags>");


    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Forums.XMLListTags()");

View Full Code Here

                           int iDomainId, String sWorkAreaId,
                           Boolean bActiveOnly, String sDateTimeFormat,
                           String sOrderBy)
    throws SQLException,IllegalArgumentException {
  DBSubset oDbss = getTopLevelMessages(oConn, nMaxMsgs,sWorkAreaId, bActiveOnly, sOrderBy);
    return "<NewsMessages count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","NewsMessage", sDateTimeFormat, null)+"</NewsMessages>";
  } // XMLListTopLevelMessages


  // --------------------------------------------------------------------------


  public static String XMLListTopLevelMessages(JDCConnection oConn, int nMaxMsgs,

View Full Code Here


  public static String XMLListMessagesForThread(JDCConnection oConn, String sGuThread)
    throws SQLException,IllegalArgumentException {
    DBSubset oDbss = getMessagesForThread(oConn, sGuThread);
    
  return "<NewsMessages count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","NewsMessage","dd/MM/yyyy HH:mm", null)+"</NewsMessages>\n";
  } // XMLListMessagesForThread




  // --------------------------------------------------------------------------

View Full Code Here

                           int nMaxMsgs, int nOffset,
                           String sGroupId, String sOrderBy)
    throws SQLException,IllegalArgumentException {
    DBSubset oDbss = getMessagesForGroup(oConn, sGroupId, nMaxMsgs, nOffset, sOrderBy);
    
  return "<NewsMessages offset=\""+String.valueOf(nOffset)+"\" eof=\""+String.valueOf(oDbss.eof())+"\" count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","NewsMessage","dd/MM/yyyy HH:mm", null)+"</NewsMessages>\n";
  } // XMLListMessagesForGroup


  // --------------------------------------------------------------------------


  public static String XMLListTopLevelMessagesForGroup(JDCConnection oConn,

View Full Code Here

                           String sGroupId, String sOrderBy,
                           String sDateFormat)
    throws SQLException,IllegalArgumentException {
    DBSubset oDbss = getTopLevelMessagesForGroup(oConn, sGroupId, dtStart, dtEnd, sOrderBy);
    
  return "<NewsMessages offset=\"0\" eof=\"true\" count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","NewsMessage",sDateFormat, null)+"</NewsMessages>\n";
  } // XMLListMessagesForGroup




  // --------------------------------------------------------------------------

View Full Code Here

                                   String sGroupId, String sOrderBy,
                                   String sDateFormat)
    throws SQLException,IllegalArgumentException {
    DBSubset oDbss = getTopLevelMessagesForGroup(oConn, sGroupId, nMaxMsgs, nOffset, sOrderBy);


  return "<NewsMessages offset=\""+String.valueOf(nOffset)+"\" eof=\""+String.valueOf(oDbss.eof())+"\" count=\""+String.valueOf(oDbss.getRowCount())+"\">\n"+oDbss.toXML("","NewsMessage",sDateFormat, null)+"</NewsMessages>\n";
  } // XMLListTopLevelMessagesForGroup


  // --------------------------------------------------------------------------


  public static String XMLListTopLevelMessagesForGroup(JDCConnection oConn,

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.