• To: xml-dev <xml-dev@l...>, xml-dev-request@l..., xml-dev-sc.1122121879.fkofhmklgipmialamdlf-sube.verma=gmail.com@l...
• Subject: Problem in uses of XML,XSD and XSL
• From: "Sube Singh" <sube.verma@g...>
• Date: Wed, 3 May 2006 16:44:27 +0530
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=KYdXl01eOZZcz7hJS+NwpFLFM+MShkrcC1+2+eg9EZMnf0LrtmMmzMsS8KnCI6/JYPYEiyASnOu/Ta02x5aZ/RfnpI4W6pVmVAmAZLn6YA2u5J06Q/4uV1k8fnXCDBUPDFw0GrXqLGX6uPoyFtWN/C+NljDb5hZBCJdwrAdMX/U=

Hi,

I would like to get your urgent help on use of XML,XSLT  and XSD

Scenario

In my case I have XML file that you can find in attachment. It have information (ColumnName+Data) related to DML operation that we have performed on a table.

I would like  to rewrite the XML only having data instead of Schema information like table name, ColumnName etc. I have required to define schema information

anywhere else using xsd or xsl.

If I write schema information in a XSD then is it require to give the column Name  and Table Name in XML also?

Is it not required to write it again in XML file then How to Map the XSD in XML ?

Is XSL is useful here?

Is XML , XSD and XSL all  are required to use it. If require what is the role of each.

Is XSL is used to map the XSD file with XML ?

I hope that u will understand my scenario and help me to solve the problem.

Waiting for your prompt reply.

Regards,

Sube Singh

<?xml version="1.0" encoding="ISO-8859-1"?><root><tableName>DBO.STUDENT<operation>D<primary><pk name="rollNo"><![CDATA[1]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[1]]></col>
<col name="c2"><![CDATA[Two]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[1]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[2]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[0]]></col>
<col name="c2"><![CDATA[Three]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[0]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[3]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[3]]></col>
<col name="c2"><![CDATA[Four]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[3]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[4]]></pk>
</primary></operation>
<operation>I<row><col name="c1">4</col>
<col name="c2"><![CDATA[FourAgain]]></col>
<col name="c3">NULL</col>
<col name="c4">NULL</col>
</row><primary><pk name="rollNo"><![CDATA[4]]></pk>
</primary></operation>
<operation>I<row><col name="c1">2</col>
<col name="c2"><![CDATA[ TwoAgain ]]></col>
<col name="c3">NULL</col>
<col name="c4">NULL</col>
</row><primary><pk name="rollNo"><![CDATA[2]]></pk>
</primary></operation>
</tableName>
</root>

• Prev by Date: RE: Schema definition of element with optional children
• Next by Date: Problem in uses of XML, XSL and XSD
• Previous by thread: XML4J --> Xerces
• Next by thread: Problem in uses of XML, XSL and XSD
• Index(es):
  • Date
  • Thread