?
Solved

processing xml document from VB application.

Posted on 2009-12-16
1
Medium Priority
?
255 Views
Last Modified: 2012-05-08
Hi,

Have a look at this xml:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
    xmlns:ota="http://www.opentravel.org/OTA/2003/05"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
      <xsl:output indent="yes"/>
      <xsl:strip-space elements="*"/>
      <xsl:param name="service" select="''" />
      <xsl:param name="trans" select="''" />
      <xsl:output method="xml" omit-xml-declaration="yes"/>
      <xsl:template match="/">
            <Anteeo>
                  <table name="STATUS" service="{$service}">
                                          </table>
                  <xsl:apply-templates select=".//ota:OTA_HotelAvailRS/ota:RoomStays"/>
            </Anteeo>

      </xsl:template>

      <xsl:template match="ota:Errors">
            <Error
                  AnteeoReason="There was an error retrieving availability."
                  ErrorCode="{/Error/Code}"
                  ErrorText="{//Error/ShortText}"
                  ErrorText2=""
                  Code="{/Error/Code}"
                  AppErrorSeverityLevel=""
                  QuickIndicator="N"
                        />
      </xsl:template>

      <xsl:template match="message">
            <xsl:apply-templates />
      </xsl:template>

      <xsl:template match="alternatelistseg">
            <table name="HotelAvail" service="{$service}">
                  <xsl:apply-templates />
            </table>
      </xsl:template>
      <!--      <xsl:template match="/">
            <xsl:apply-templates select="ota:OTA_HotelAvailRS/ota:RoomStays"/>
      </xsl:template>
-->
      <xsl:template match="ota:RoomStays">
            <table name="HotelAvail" service="">
                  <xsl:apply-templates select="ota:RoomStay"/>
            </table>
      </xsl:template>
      <xsl:template match="ota:RoomStay">
            <xsl:element name="AvailHtl">
                  <xsl:apply-templates select="*"/>
            </xsl:element>
      </xsl:template>
      <xsl:template match="ota:TimeSpan">
            <xsl:attribute name="TimeStart">
                  <xsl:value-of select="@Start"/>
            </xsl:attribute>
            <xsl:attribute name="TimeDuration">
                  <xsl:value-of select="@Duration"/>
            </xsl:attribute>
      </xsl:template>
      <xsl:template match="ota:Total">
            <xsl:attribute name="AmountAfterTax">
                  <xsl:value-of select="@AmountAfterTax"/>
            </xsl:attribute>
            <!-- 09/12/2009 <xsl:attribute name="TimeDuration">
                  <xsl:value-of select="@Duration"/>
            </xsl:attribute>            -->
      </xsl:template>            
      <xsl:template match="ota:ResGuestRPHs">
            <xsl:for-each select="ota:ResGuestRPH">
                  <xsl:attribute name="ResGuestRPH-{position()}">
                        <xsl:value-of select="@RPH"/>
                  </xsl:attribute>
            </xsl:for-each>
      </xsl:template>
      <xsl:template match="ota:RoomRates">
            <xsl:for-each select="ota:RoomRate">
                  <xsl:attribute name="RoomRate-{position()}">
                        <xsl:value-of select="@RatePlanCode"/>
                  </xsl:attribute>
            </xsl:for-each>
      </xsl:template>
      <xsl:template match="ota:BasicPropertyInfo">
            <xsl:attribute name="ID">
                  <xsl:value-of select="@HotelCodeContext"/>
            </xsl:attribute>
            <xsl:attribute name="VendorMessage">
                  <xsl:value-of select="ota:VendorMessages"/>
            </xsl:attribute>
      </xsl:template>
      <xsl:template match="ota:CancelPenalties">
            <xsl:for-each select="ota:CancelPenalty">
                  <xsl:attribute name="CancelPenalty-{position()}">
                        <xsl:value-of select="ota:Deadline/@OffsetUnitMultiplier"/>
                  </xsl:attribute>
            </xsl:for-each>
      </xsl:template>
      <xsl:template match="ota:RoomStay">
            <xsl:element name="AvailHtl">
                  <xsl:attribute name="MaxOccupancy"></xsl:attribute>
                  <xsl:attribute name="Minoccupancy"></xsl:attribute>
                  <xsl:apply-templates select="*"/>
            </xsl:element>
      </xsl:template>

</xsl:stylesheet>

I need to process this xml file from a VB application. First of all, I need to check the error status and if no error and continue to process the xml. Can some body show me how can I achieve this VB6 please.
0
Comment
Question by:ube100
1 Comment
 
LVL 42

Accepted Solution

by:
Meir Rivkin earned 2000 total points
ID: 26069814
this is xsl file, what do u mean by "process this xml"?
what r u trying to achieve?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question