Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Anyone up for a syntax check? <blush>

Status
Not open for further replies.
DairylandDan

DairylandDan

Programmer
Apr 3, 2008
17
0
0
US
Hey folks.

I'm a newbie at this, not proud of the fact . . . but, it's a fact none-the-less. I've posted a few questions already, and I appreciate all who've jumped in with tips and suggestions. I want to assure you all that I am doing my own learning and investigating on my own as well . . . so, please don't think that I'm just coming here for answers whilst not thinking on my own.

OK, now with the disclaimer out of the way (LOL)...

I'm on AIX trying to pull data from a provided xml sheet and inserting it into a table on Oracle 10g (v2).

I've gotten a test session to work (pulling from a slightly complex xml document into a slightly complex table). But, when I move to a session reflecting what i'm trying to produce for real, I get the following error:

Code: 
<?xml version = '1.0'?>
<!-- insert-APCINVOICE.xsql -->
<xsql-error action="xsql:insert-request">
   <message>Expected name instead of &lt;.</message>
</xsql-error>

So, if'n ya'all don't mind, I'd like some input on my xsl document. I guess I'm looking for any flagarant fouls related to syntax or basic usage. (I'll also include my xsql document, the command-line call I'm using as well as the dtd of the xml document I'm receiving) I do have a zip of the xml document - but, don't use box.net. I'll wait with the actual xml file unless someone specifically requests it.

OK, here's the xsql document:
Code: 
<?xml version="1.0"?>

<!-- insert-APCINVOICE.xsql -->
 <xsql:insert-request xmlns:xsql="urn:oracle-xsql" table="APCINVOICE" transform="insert-APCINVOICE.xsl" connection="testapps"/>

Here's the command-line call to invoke the xsql utility:

Code: 
java oracle.xml.xsql.XSQLCommandLine insert-APCINVOICE.xsql posted-xml=FMVoucher_Extract--4-18-08-Truncated.xml xsql-status action="xsql:insert-request" rows="1"

Here's the dtd of the xml document I'm receiving:

Code: 
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XML Spy v3.5 NT ([URL unfurl="true"]http://www.xmlspy.com)[/URL] by John Fairbairn (Canopy International) -->
<!--DTD generated by XML Spy v3.5 NT ([URL unfurl="true"]http://www.xmlspy.com)-->[/URL]
<!ELEMENT ABRV ANY>
<!ELEMENT AENAME ANY>
<!ELEMENT AENM ANY>
<!ELEMENT AMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST AMOUNT
	qualifier (DISCOUNT | DISCOUNT1 | DISCOUNT2 | INVOICE | PAID | PAYMENT) #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT AUTHID ANY>
<!ELEMENT BASE_AMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST BASE_AMOUNT
	qualifier CDATA #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT BATCH ANY>
<!ELEMENT BSR (VERB*, NOUN*, REVISION*)*>
<!ELEMENT CHARGEAMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST CHARGEAMOUNT
	qualifier CDATA #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT CHARGE_AMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST CHARGE_AMOUNT
	qualifier CDATA #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT CHARGE_QUANTITY (VALUE*, NUMOFDEC*, SIGN*, UOM*)*>
<!ELEMENT CNTROLAREA (BSR*, SENDER*, DATETIME*)*>
<!ELEMENT CODEPAGE ANY>
<!ELEMENT COMPONENT ANY>
<!ELEMENT CONDITION (OBJECTID*, DESCRIPTION*, ABRV*, STATUS*, CHARGEAMOUNT*, CONDITIONGROUP*)*>
<!ELEMENT CONDITIONGROUP (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT CONFIRMATION ANY>
<!ELEMENT COSTGROUP (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT CRFROMEXPREC ANY>
<!ELEMENT CURRENCY ANY>
<!ELEMENT DATAAREA (SYNC_VOUCHER*)*>
<!ELEMENT DATETIME (YEAR*, MONTH*, DAY*, HOUR*, MINUTE*, SECOND*, SUBSECOND*, TIMEZONE*)*>
<!ATTLIST DATETIME
	qualifier (BASE_DATE | CREATION | CreateDate | DISCOUNT_DATE | LAST_CHECK_DATE | PAYMENT_DUE_DATE | PDATE | ReceivedDate | SentDate | UpdateDate) #IMPLIED
>
<!ELEMENT DAY ANY>
<!ELEMENT DESCRIPTION ANY>
<!ELEMENT DISCOUNT (AMOUNT*)*>
<!ELEMENT DISCOUNT_1 (DATETIME*, AMOUNT*, DISCOUNT_PERCENT*)*>
<!ELEMENT DISCOUNT_2 (DATETIME*, AMOUNT*, DISCOUNT_PERCENT*)*>
<!ELEMENT DISCOUNT_PERCENT (VALUE*, NUMOFDEC*, SIGN*)*>
<!ELEMENT DRCR ANY>
<!ELEMENT ENTITY (OBJECTID*, ID*, AENAME*, DESCRIPTION*, ENTITYTYPE*, SITEID*)*>
<!ELEMENT ENTITYTYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT GLENTITYS ANY>
<!ELEMENT HOUR ANY>
<!ELEMENT ID ANY>
<!ELEMENT INVENTORY_ITEM (OBJECTID*, ID*, AENAME*, DESCRIPTION*, ITEMTYPE*)*>
<!ELEMENT INVLINE (OBJECTID*, ID*, CRFROMEXPREC*, INVLINETYPE*)*>
<!ELEMENT INVLINETYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT INVOICE (OBJECTID*, ID*, AENAME*, DESCRIPTION*, VOUCH_ID*, BATCH*, EXCHANGERATEUSED*, EXCHANGERATE*, REVERSED*, DATETIME*, VENDOR*, AMOUNT*, INVOICETYPE*, SITEID*)*>
<!ELEMENT INVOICETYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT ITEMTYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT LANGUAGE ANY>
<!ELEMENT LAST_CHECK (DATETIME*, NUMBER*)*>
<!ELEMENT LOGICALID ANY>
<!ELEMENT LOOKUP (ID, AENM)>
<!ATTLIST LOOKUP
	qualifier CDATA #REQUIRED
	type CDATA #REQUIRED
>
<!ELEMENT MINUTE ANY>
<!ELEMENT MONTH ANY>
<!ELEMENT NOUN ANY>
<!ELEMENT NUMBER ANY>
<!ELEMENT NUMOFDEC ANY>
<!ELEMENT OBJECTID ANY>
<!ELEMENT PAID_TO_DATE (AMOUNT*)*>
<!ELEMENT PAYMENT (AMOUNT*)*>
<!ELEMENT PAYMENT_TERMS (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT PCITEM (OBJECTID*, ID*, AENAME*, DESCRIPTION*, ITEMTYPE*)*>
<!ELEMENT REFERENCEID ANY>
<!ELEMENT REMIT_VENDOR (OBJECTID*, ID*, AENAME*, DESCRIPTION*, VENDORTYPE*)*>
<!ELEMENT REVISION ANY>
<!ELEMENT SDCREATOR ANY>
<!ELEMENT SDIO ANY>
<!ELEMENT SDNUM ANY>
<!ELEMENT SDTYPE ANY>
<!ELEMENT SECOND ANY>
<!ELEMENT SENDER (LOGICALID*, COMPONENT*, TASK*, REFERENCEID*, CONFIRMATION*, LANGUAGE*, CODEPAGE*, AUTHID*)*>
<!ELEMENT SIGN ANY>
<!ELEMENT SITEID (ID, AENM)>
<!ELEMENT STATUS ANY>
<!ELEMENT STOREROOM (OBJECTID*, ID*, ABRV*)*>
<!ELEMENT SUBSECOND ANY>
<!ELEMENT SYNC_VOUCHER (VOUCHER*)*>
<!ELEMENT SYNC_VOUCHER_31 (CNTROLAREA*, DATAAREA*)*>
<!ELEMENT TASK ANY>
<!ELEMENT TAX (OBJECTID*, DESCRIPTION*, ABRV*, TAXAMOUNT*, TAXABLEAMOUNT*, TAXGROUP*)*>
<!ELEMENT TAXABLEAMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST TAXABLEAMOUNT
	qualifier CDATA #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT TAXAMOUNT (VALUE*, NUMOFDEC*, SIGN*, CURRENCY*, DRCR*)*>
<!ATTLIST TAXAMOUNT
	qualifier CDATA #IMPLIED
	type CDATA #IMPLIED
>
<!ELEMENT TAXGROUP (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT TIMEZONE ANY>
<!ELEMENT UOM ANY>
<!ELEMENT USERAREA ANY>
<!ELEMENT VALUE ANY>
<!ELEMENT VENDOR (OBJECTID*, ID*, AENAME*, DESCRIPTION*, VENDORTYPE*)*>
<!ELEMENT VENDORTYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT VERB ANY>
<!ELEMENT VOUCHER (USERAREA*, DATETIME+, OBJECTID*, SITEID*, SDCREATOR*, SDIO*, SDNUM*, SDTYPE*, PAYMENT*, PAID_TO_DATE*, DISCOUNT*, DISCOUNT_1*, DISCOUNT_2*, LAST_CHECK*, PAYMENT_TERMS*, REMIT_VENDOR*, INVOICE*, VOUCHER_LINE*)*>
<!ELEMENT VOUCHER_LINE (OBJECTID*, PCITEM*, INVENTORY_ITEM*, STOREROOM*, TAX*, CONDITION*, CHARGE_AMOUNT*, BASE_AMOUNT*, CHARGE_QUANTITY*, WORKORDER*, WORKTASK*, ENTITY*, COSTGROUP*, GLENTITYS*, NAMEDSEGMENTS?, INVLINE*)*>
<!ELEMENT NAMEDSEGMENTS (SEGMENT1*, SEGMENT2*, SEGMENT3*, SEGMENT4*, SEGMENT5*, SEGMENT6*, SEGMENT7*, SEGMENT8*, SEGMENT9*, SEGMENT10*)*>
<!ELEMENT SEGMENT1 ANY>
<!ELEMENT SEGMENT2 ANY>
<!ELEMENT SEGMENT3 ANY>
<!ELEMENT SEGMENT4 ANY>
<!ELEMENT SEGMENT5 ANY>
<!ELEMENT SEGMENT6 ANY>
<!ELEMENT SEGMENT7 ANY>
<!ELEMENT SEGMENT8 ANY>
<!ELEMENT SEGMENT9 ANY>
<!ELEMENT SEGMENT10 ANY>
<!ELEMENT VOUCH_ID ANY>
<!ELEMENT WORKORDER (OBJECTID*, ID*, AENAME*, DESCRIPTION*, WORKORDERTYPE*, SITEID*)*>
<!ELEMENT WORKORDERTYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT WORKTASK (OBJECTID*, ID*, AENAME*, DESCRIPTION*, WORKTASKTYPE*)*>
<!ELEMENT WORKTASKTYPE (OBJECTID*, DESCRIPTION*, ABRV*)*>
<!ELEMENT YEAR ANY>
<!ELEMENT EXCHANGERATEUSED ANY>
<!ELEMENT EXCHANGERATE ANY>
<!ELEMENT REVERSED ANY>

And, here's the xsl document:

Code: 
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="[URL unfurl="true"]http://www.w3.org/1999/XSL/Transform">[/URL]

<!-- insert-APCINVOICE.xsl -->
<xsl:template match="/">
<ROWSET xmlns:xsl="[URL unfurl="true"]http://www.w3.org/1999/XSL/Transform"[/URL] xsl:version="1.0">
 <xsl:for-each select="//SYNC_VOUCHER_31/DATAAREA/SYNC_VOUCHER/VOUCHER">
  <ROW>
   <COMPANY><xsl:text>1</xsl:text></COMPANY>
   <VENDOR><xsl:value-of select="INVOICE/VENDOR/ID"/></VENDOR>
   <EDI_NBR><xsl:text> </xsl:text></EDI_NBR>
   <INVOICE><xsl:value-of select="INVOICE/ID"/></INVOICE>
   <SUFFIX><xsl:text>0</xsl:text></SUFFIX>
   <BATCH_NUM><xsl:text>1</xsl:text></BATCH_NUM>
   <VOUCHER_NBR><xsl:value-of select="INVOICE/VOUCH_ID"/></VOUCHER_NBR>
   <AUTH_CODE><xsl:text> </xsl:text></AUTH_CODE>
   <PROC_LEVEL><xsl:text>1</xsl:text></PROC_LEVEL>
   <ACCR_CODE><xsl:text>  AP</xsl:text></ACCR_CODE>
   <INVOICE_TYPE><xsl:text> </xsl:text></INVOICE_TYPE>
   <OLD_VENDOR><xsl:text> </xsl:text></OLD_VENDOR>
   <INV_CURRENCY><xsl:value-of select="VOUCHER_LINE/CHARGE_AMOUNT/CURRENCY"/></INV_CURRENCY>
   <INVOICE_DTE>
    <xsl:for-each select="DATETIME">
     <xsl:if test="DATETIME[@qualifier = 'BASE_DATE']">
      <xsl:value-of select="DATETIME/MONTH"/>
      <xsl:text>-</xsl:text>
      <xsl:value-of select="DATETIME/DAY"/>
      <xsl:text>-</xsl:text>
      <xsl:value-of select="DATETIME/YEAR"/>
     </xsl:if>
    </xsl:for-each> 
   </INVOICE_DTE>
   <TAX_PNT_DATE><xsl:text>01/01/1700</xsl:text></TAX_PNT_DATE>
   <PURCH_FR_LOC><xsl:text> </xsl:text></PURCH_FR_LOC>
   <PO_NUMBER><xsl:text> </xsl:text></PO_NUMBER>
   <PO_RELEASE><xsl:text>0</xsl:text></PO_RELEASE>
   <PO_CODE><xsl:text> </xsl:text></PO_CODE>
   <AUTO_MATCH><xsl:text> </xsl:text></AUTO_MATCH>
   <DESCRIPTION><xsl:text> </xsl:text></DESCRIPTION>
   <BASE_INV_AMT><xsl:text>0</xsl:text></BASE_INV_AMT>
   <TRAN_INV_AMT>
    <xsl:choose>
     <xsl:when test="PAYMENT/AMOUNT[@qualifier = 'PAYMENT']">
      <xsl:choose>
       <xsl:when test="PAYMENT/AMOUNT/SIGN = '-'">
        <xsl:text>-</xsl:text>
        <xsl:choose>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '2'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE * .01" />
         </xsl:when>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '1'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE * .1" />
         </xsl:when>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '0'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE" />
         </xsl:when>
         <xsl:otherwise>
          <xsl:value-of select="VALUE" />
         </xsl:otherwise>
        </xsl:choose>
       </xsl:when>
       <xsl:otherwise>
        <xsl:choose>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '2'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE * .01" />
         </xsl:when>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '1'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE * .1" />
         </xsl:when>
         <xsl:when test="PAYMENT/AMOUNT/NUMOFDEC = '0'">
          <xsl:value-of select="PAYMENT/AMOUNT/VALUE" />
         </xsl:when>
         <xsl:otherwise>
          <xsl:value-of select="VALUE" />
         </xsl:otherwise>
        </xsl:choose>
       </xsl:otherwise>
      </xsl:choose>
     </xsl:when>
    </xsl:choose>
   </TRAN_INV_AMT>
   <TRAN_ALOW_AMT><xsl:text>0</xsl:text></TRAN_ALOW_AMT>
   <TRAN_TXBL_AMT><xsl:text>0</xsl:text></TRAN_TXBL_AMT>
   <TRAN_TAX_AMT><xsl:text>0</xsl:text></TRAN_TAX_AMT>
   <TRAN_DISC_AMT>
    <xsl:choose>
     <xsl:when test="DISCOUNT_1/AMOUNT[@qualifier = 'PAYMENT']">
      <xsl:choose>
       <xsl:when test="DISCOUNT_1/AMOUNT/SIGN = '-'">
        <xsl:text>-</xsl:text>
        <xsl:choose>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '2'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE * .01" />
         </xsl:when>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '1'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE * .1" />
         </xsl:when>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '0'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE" />
         </xsl:when>
         <xsl:otherwise>
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE" />
         </xsl:otherwise>
        </xsl:choose>
       </xsl:when>
       <xsl:otherwise>
        <xsl:choose>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '2'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE * .01" />
         </xsl:when>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '1'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE * .1" />
         </xsl:when>
         <xsl:when test="DISCOUNT_1/AMOUNT/NUMOFDEC = '0'">
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE" />
         </xsl:when>
         <xsl:otherwise>
          <xsl:value-of select="DISCOUNT_1/AMOUNT/VALUE" />
         </xsl:otherwise>
        </xsl:choose>
       </xsl:otherwise>
      </xsl:choose>
     </xsl:when>
    </xsl:choose>
   </TRAN_DISC_AMT>
   <ORIG_CNV_RATE><xsl:text>0</xsl:text></ORIG_CNV_RATE>
   <ANTICIPATION><xsl:text> </xsl:text></ANTICIPATION>
   <DISCOUNT_RT><xsl:text>0</xsl:text></DISCOUNT_RT>
   <DISC_DATE>
    <xsl:choose>
     <xsl:when test="DISCOUNT_1/DATETIME[@qualifier = 'DISCOUNT_DATE']">
      <xsl:value-of select="DISCOUNT_1/DATETIME/MONTH" />
      <xsl:text>/</xsl:text>
      <xsl:value-of select="DISCOUNT_1/DATETIME/DAY" />
      <xsl:text>/</xsl:text>
      <xsl:value-of select="DISCOUNT_1/DATETIME/YEAR" />
     </xsl:when>
    </xsl:choose> 
   </DISC_DATE>
   <DUE_DATE>
    <xsl:choose>
     <xsl:when test="DATETIME[@qualifier = 'PAYMENT_DUE_DATE']">
      <xsl:value-of select="DATETIME/MONTH" />
      <xsl:text>/</xsl:text>
      <xsl:value-of select="DATETIME/DAY" />
      <xsl:text>/</xsl:text>
      <xsl:value-of select="DATETIME/YEAR" />
     </xsl:when>
    </xsl:choose> 
   </DUE_DATE>
   <NBR_RECUR_PMT><xsl:text>0</xsl:text></NBR_RECUR_PMT>
   <RECUR_FREQ><xsl:text> </xsl:text></RECUR_FREQ>
   <REMIT_TO_CODE>
    <xsl:value-of select="REMIT_VENDOR/ID" />
   </REMIT_TO_CODE>
   <CASH_CODE><xsl:text>VW</xsl:text></CASH_CODE>
   <SEP_CHK_FLAG>
    <xsl:value-of select="VOUCHER_LINE/CONDITION/DESCRIPTION" />
   </SEP_CHK_FLAG>
   <PAY_IMM_FLAG><xsl:text> </xsl:text></PAY_IMM_FLAG>
   <ENCLOSURE><xsl:text> </xsl:text></ENCLOSURE>
   <CURR_RECALC><xsl:text> </xsl:text></CURR_RECALC>
   <DISC_LOST_FLG><xsl:text> </xsl:text></DISC_LOST_FLG>
   <TAX_CODE><xsl:text> </xsl:text></TAX_CODE>
   <INCOME_CODE><xsl:text> </xsl:text></INCOME_CODE>
   <HLD_CODE><xsl:text> </xsl:text></HLD_CODE>
   <DIST_CODE><xsl:text> </xsl:text></DIST_CODE>
   <TERM_CODE>
    <xsl:value-of select="PAYMENT_TERMS/ABRV"
   </TERM_CODE>
   <REC_STATUS><xsl:text>0</xsl:text></REC_STATUS>
   <POSTING_STATUS><xsl:text>0</xsl:text></POSTING_STATUS>
   <DISTRIB_DATE><xsl:text>01/01/1700</xsl:text></DISTRIB_DATE>
   <PAY_VENDOR><xsl:text> </xsl:text></PAY_VENDOR>
   <TRANS_NBR><xsl:text> </xsl:text></TRANS_NBR>
   <BANK_INST_CODE><xsl:text>SYS</xsl:text></BANK_INST_CODE>
   <CHECK_DATE><xsl:text>01/01/1700</xsl:text></CHECK_DATE>
   <INVOICE_GROUP><xsl:text> </xsl:text></INVOICE_GROUP>
   <ONE_TIME_VEND><xsl:text>N</xsl:text></ONE_TIME_VEND>
   <VENDOR_VNAME><xsl:text> </xsl:text></VENDOR_VNAME>
   <VENDOR_SNAME><xsl:text> </xsl:text></VENDOR_SNAME>
   <ADDR1><xsl:text> </xsl:text></ADDR1>
   <ADDR2><xsl:text> </xsl:text></ADDR2>
   <ADDR3><xsl:text> </xsl:text></ADDR3>
   <ADDR4><xsl:text> </xsl:text></ADDR4>
   <CITY_ADDR5><xsl:text> </xsl:text></CITY_ADDR5>
   <STATE_PROV><xsl:text> </xsl:text></STATE_PROV>
   <POSTAL_CODE><xsl:text> </xsl:text></POSTAL_CODE>
   <COUNTY><xsl:text> </xsl:text></COUNTY>
   <COUNTRY><xsl:text> </xsl:text></COUNTRY>
   <LEGAL_NAME><xsl:text> </xsl:text></LEGAL_NAME>
   <VEN_INC_CODE><xsl:text> </xsl:text></VEN_INC_CODE>
   <TAX_ID><xsl:text> </xsl:text></TAX_ID>
   <JRNL_BOOK_NBR><xsl:text> </xsl:text></JRNL_BOOK_NBR>
   <BANK_CHK_AMT><xsl:text>0</xsl:text></BANK_CHK_AMT>
   <BANK_ND><xsl:text>0</xsl:text></BANK_ND>
   <BNK_CNV_RATE><xsl:text>0</xsl:text></BNK_CNV_RATE>
   <DISCOUNT_CODE><xsl:text> </xsl:text></DISCOUNT_CODE>
   <INVOICE_SOURCE><xsl:text> </xsl:text></INVOICE_SOURCE>
   <INVC_REF_TYPE><xsl:text> </xsl:text></INVC_REF_TYPE>
   <APPROVED_FLAG><xsl:text> </xsl:text></APPROVED_FLAG>
   <INC_ACCR_CODE><xsl:text> </xsl:text></INC_ACCR_CODE>
   <OPERATOR><xsl:text> </xsl:text></OPERATOR>
   <INV_USR_FLD_01><xsl:text> </xsl:text></INV_USR_FLD_01>
   <INV_USR_FLD_02><xsl:text> </xsl:text></INV_USR_FLD_02>
   <INV_USR_FLD_03><xsl:text> </xsl:text></INV_USR_FLD_03>
   <INV_USR_FLD_04><xsl:text> </xsl:text></INV_USR_FLD_04>
   <INV_USR_FLD_05><xsl:text> </xsl:text></INV_USR_FLD_05>
   <HANDLING_CODE><xsl:text> </xsl:text></HANDLING_CODE>
   <RCPT_INV_DATE><xsl:text>01/01/1700</xsl:text></RCPT_INV_DATE>
   <RECORD_ERROR><xsl:text> </xsl:text></RECORD_ERROR>
   <REASON_CODE><xsl:text> </xsl:text></REASON_CODE>
   <CBPRINT_FL><xsl:text> </xsl:text></CBPRINT_FL>
   <RETAIL_AMT><xsl:text>0</xsl:text></RETAIL_AMT>
   <SEGMENT_BLOCK><xsl:text> </xsl:text></SEGMENT_BLOCK>
   <JBK_SEQ_NBR><xsl:text>0</xsl:text></JBK_SEQ_NBR>
   <VAT_REG_CTRY><xsl:text> </xsl:text></VAT_REG_CTRY>
   <VAT_REG_NBR><xsl:text> </xsl:text></VAT_REG_NBR>
   <L_INDEX><xsl:text> </xsl:text></L_INDEX>
   <CVISET3_SS_SW><xsl:text>N</xsl:text></CVISET3_SS_SW>
   <CVISET4_SS_SW><xsl:text>Y</xsl:text></CVISET4_SS_SW>
   <CVISET5_SS_SW><xsl:text>Y</xsl:text></CVISET5_SS_SW>
   <L_ATCVI_SS_SW><xsl:text>N</xsl:text></L_ATCVI_SS_SW>
  </ROW>
 </xsl:for-each>
</ROWSET>
</xsl:template>
</xsl:stylesheet>

As always, please be gentle with me. <blush>

Any and all time & assistance are appreciated!


Dan
 
Sort by date Sort by votes
Got it fixed!

But, I'm embarrassed to admit that it was, indeed, a simple syntax error. <blush>

Here's the section of the xsl (notice missing end of the xsl:vaule tag) <groan>:

Code: 
   <TERM_CODE>
    <xsl:value-of select="PAYMENT_TERMS/ABRV"
   </TERM_CODE>


Dan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

developer11
  • Locked
  • Question
thread426-1595399 Can anyone giv
Replies
0
Views
109
developer11
developer11
P
  • Question
How to re-use a recursive template
Replies
1
Views
170
pdrapeau
P
smak1
  • Locked
  • Question
add structure to XML
Replies
0
Views
135
smak1
smak1
Dashley
  • Locked
  • Question
Consuming a WSDL and passing arrays into an object
Replies
1
Views
129
Dashley
Dashley
Sunil Sharma
  • Locked
  • Question
Add Minus (-) into pattern but constrain is Munis (-) should not be first character
Replies
1
Views
147
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top