XSQL:insert-request

From: R.H. Nadorp <rene.nadorp_at_ibridge.nl>
Date: 31 Mar 2004 03:28:17 -0800
Message-ID: <6ec47cba.0403310328.3a87396d_at_posting.google.com>

Does anyone have any ideas how to get numeric values with decimals into a database-table using the XSQL-pages - framework.

When processing a <xsql:insert-request I'm having problems inserting a numeric value with decimals (e.g. 101.23) into a table.

Message: java.lang.NumberFormatException: 101.23

I'm using the following xsl to transform the html-form into a <ROWSET><ROW> - format:

<?xml version = '1.0'?>
<rowset xsl:version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

   <xsl:for-each select="request/parameters">    <row>

<id><xsl:value-of select="id"/></id>
<bkgdat><xsl:value-of select="bkgdat"/></bkgdat>
<bkr_id><xsl:value-of select="bkr_id"/></bkr_id>
<bedrag><xsl:value-of select="bedrag"/></bedrag>
<dcin>

        <xsl:choose>
  	      <xsl:when test="dcin = 'C'">C</xsl:when>
          <xsl:otherwise>D</xsl:otherwise>
      	</xsl:choose>


      </dcin>


      <omschrijving><xsl:value-of


select="omschrijving"/></omschrijving>


      <rel_id>      <xsl:value-of select="rel_id"/></rel_id>

      <rek_id>      <xsl:value-of select="rek_id"/></rek_id>


      <afsnr>       <xsl:value-of select="afsnr"/></afsnr>

   </row>
   </xsl:for-each>
</rowset>

The problem occurs on the "<bedrag>"-column.

Greetings,
R.H. Nadorp Received on Wed Mar 31 2004 - 13:28:17 CEST