XML Transformation , problem

[Savita]

Hi all,

I want to perform a xml transformation .I have a XSL file which contains the 
SQL statements.

I am checking in this file like this

update OS_CUSTOMER set
    <xsl:if test="(count(CUSTOMER/FIRST_NAME) = 1)">
         FIRST_NAME='<xsl:value-of select="CUSTOMER/FIRST_NAME"/>'
        </xsl:if>
         <xsl:if test="(count(CUSTOMER/LAST_NAME) = 1)">
             ,LAST_NAME='<xsl:value-of select="CUSTOMER/LAST_NAME"/>'
        </xsl:if>
     <xsl:if test="(count(CUSTOMER/CONTACT_TYPE) = 1)">
         ,CONTACT_TYPE='<xsl:value-of select="CUSTOMER/CONTACT_TYPE"/>'
    </xsl:if>
    <xsl:if test="(count(CUSTOMER/ADDRESS_1) = 1)">
         ,ADDRESS_1='<xsl:value-of select="CUSTOMER/ADDRESS_1"/>'
    </xsl:if>

Here I am facing a problem with transformation ,If the first element FIRST_NAME 
is not present it
will put a , infront of LAST_NAME then the update statement will become invalid 
.Is there any way in
the API where we can avoid putting the , infront of the second element.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]