kulkarniash
Programmer
Hi,
I have to build a XML file from database, on the fly.
I have a problem in building a XML schema, each time the element name will be from database, so i cannot hard code it in the XML schema.
so how can i develop a XML schema for this file, the file will look some thing like this
Message>
<F scene="F" sceneDesc=" Scenario F" view="ALL" viewDesc=" All Lines">
<BLENDER_1 lineName="BLENDER 1 " lineDesc="Blending machine " lineY1="30" lineY2="85">
<A20011107155511651000 ukey="2001-11-07-15.55.11.651000" scene="F " line="BLENDER 1 " lineDesc="Blending machine " phaseSort="12" phaseNum="BL" altPhase=" " product="SF02 " prodDesc="TM Blend " startDate="2001-11-08" startTime="00:00:00" endDate="2001-11-08" endTime="00:00:00" />
</F>
</Message>
in other XML the element name may be BLISTER_1, so i cannot hard code it in XML Schema,
I want to set the attribute type of startDate and endDate as Date, so i can directly retrieve it as Date.
Ashish
I have to build a XML file from database, on the fly.
I have a problem in building a XML schema, each time the element name will be from database, so i cannot hard code it in the XML schema.
so how can i develop a XML schema for this file, the file will look some thing like this
Message>
<F scene="F" sceneDesc=" Scenario F" view="ALL" viewDesc=" All Lines">
<BLENDER_1 lineName="BLENDER 1 " lineDesc="Blending machine " lineY1="30" lineY2="85">
<A20011107155511651000 ukey="2001-11-07-15.55.11.651000" scene="F " line="BLENDER 1 " lineDesc="Blending machine " phaseSort="12" phaseNum="BL" altPhase=" " product="SF02 " prodDesc="TM Blend " startDate="2001-11-08" startTime="00:00:00" endDate="2001-11-08" endTime="00:00:00" />
</F>
</Message>
in other XML the element name may be BLISTER_1, so i cannot hard code it in XML Schema,
I want to set the attribute type of startDate and endDate as Date, so i can directly retrieve it as Date.
Ashish