[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] how to capture a value returned by a template call into a variable

---

---

I suspect there is no @jdbc-type in the context where you are trying to create the variable.  Check whether @jdbc-type exists by placing <xsl:value-of select="@jdbc-type"/> before you try to create the variable.

The following example uses a subset of your examples, and it works fine.

the xslt file
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
	<xsl:template name="translate_type">
		<xsl:param name="db_type"/>
		<xsl:choose>
			<xsl:when test="$db_type='CHAR'">String</xsl:when>
			<xsl:when test="$db_type='VARCHAR'">String</xsl:when>
			<xsl:when test="$db_type='LONGVARCHAR'">String</xsl:when>
		</xsl:choose>
	</xsl:template>
	<xsl:template match="testnode">
		<xsl:variable name="java_type">
			<xsl:call-template name="translate_type">
				<xsl:with-param name="db_type" select="@jdbc-type"/>
			</xsl:call-template>
		</xsl:variable>
		<xsl:value-of select="$java_type"/>
	</xsl:template>
</xsl:stylesheet>

the example test file.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="2003-1-9.xslt"?>
<testnode jdbc-type="CHAR"></testnode> 

Edward Middleton

-----Original Message-----
From: Anthony Kong [mailto:anthony.kong@xxxxxxxxx]
Sent: Thursday, January 09, 2003 6:14 PM
To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
Subject: RE: [xsl] how to capture a value returned by a template call into a variable


Hi, Ed,

The template is as such:

 <xsl:template name="translate_type" >
     <xsl:param name="db_type" />
     <xsl:choose >
         <xsl:when test="$db_type='CHAR'">String</xsl:when>
         <xsl:when test="$db_type='VARCHAR'">String</xsl:when>
         <xsl:when test="$db_type='LONGVARCHAR'">String</xsl:when>
         <xsl:when test="$db_type='NUMERIC'">java.math.BigDecimal</xsl:when>
         <xsl:when test="$db_type='DECIMAL'">java.math.BigDecimal</xsl:when>
         <xsl:when test="$db_type='BIT'">boolean</xsl:when>
         <xsl:when test="$db_type='TINYINT'">byte</xsl:when>
         <xsl:when test="$db_type='SMALLINT'">short</xsl:when>
         <xsl:when test="$db_type='INTEGER'">  int </xsl:when>
         <xsl:when test="$db_type='BIGINT'">  long    </xsl:when>
         <xsl:when test="$db_type='REAL'">  float   </xsl:when>
         <xsl:when test="$db_type='FLOAT'">  double  </xsl:when>
         <xsl:when test="$db_type='DOUBLE'">  double  </xsl:when>
         <xsl:when test="$db_type='BINARY'">  byte[]  </xsl:when>
         <xsl:when test="$db_type='VARBINARY'">  byte[]  </xsl:when>
         <xsl:when test="$db_type='LONGVARBINARY'">  byte[]  </xsl:when>
         <xsl:when test="$db_type='DATE'">  java.sql.Date   </xsl:when>
         <xsl:when test="$db_type='TIME'">  java.sql.Time   </xsl:when>
         <xsl:when test="$db_type='TIMESTAMP'">  java.sql.Timestamp
</xsl:when>
         <xsl:when test="$db_type='CLOB'">  Clob    </xsl:when>
         <xsl:when test="$db_type='BLOB'">  Blob    </xsl:when>
         <xsl:when test="$db_type='ARRAY'">  Array   </xsl:when>
         <xsl:when test="$db_type='DISTINCT'">  mapping of underlying type
</xsl:when>
         <xsl:when test="$db_type='STRUCT'">  Struct  </xsl:when>
         <xsl:when test="$db_type='REF'">  Ref </xsl:when>
         <xsl:when test="$db_type='JAVA_OBJECT'">  underlying Java class
</xsl:when>
    </xsl:choose>
 </xsl:template>


Regards,

Anthony



-----Original Message-----
From: Edward.Middleton@xxxxxxxxxxx [mailto:Edward.Middleton@xxxxxxxxxxx]
Sent: Thursday, January 09, 2003 3:24 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] how to capture a value returned by a template call
into a variable


You need to post your translate_type template.  What you have posted looks
fine.

Edward Middleton

-----Original Message-----
From: Anthony Kong [mailto:anthony.kong@xxxxxxxxx]
Sent: Thursday, January 09, 2003 3:04 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] how to capture a value returned by a template call into a
variable


Hi, all,

I have tried to search by keyword "function" or "template" into the mailing
list but there are no many enties returned in the results. So i have to
venture to ask this question in this list. If the question has appeared
before, please kindly bear with me.

I would like to modularise some common code as a function. But in XSLT 1.0
there is no function facility. My common code involved is to tranlate a DB
type into a java type. That is what i have done:

 <xsl:variable name="java_type">
        <xsl:call-template name="translate_type">
            <xsl:with-param name="db_type" select="@jdbc-type"/>
        </xsl:call-template>
    </xsl:variable>

I intended (wish, actually :-) to capture the result into variable
"java_type". However it failed.

What is a better way to achieve this?


Regards,

Anthony

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

---