Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, I have to build a XML file fro

Status
Not open for further replies.

kulkarniash

Programmer
Nov 12, 2001
1
US
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=&quot;F&quot; sceneDesc=&quot; Scenario F&quot; view=&quot;ALL&quot; viewDesc=&quot; All Lines&quot;>
<BLENDER_1 lineName=&quot;BLENDER 1 &quot; lineDesc=&quot;Blending machine &quot; lineY1=&quot;30&quot; lineY2=&quot;85&quot;>
<A20011107155511651000 ukey=&quot;2001-11-07-15.55.11.651000&quot; scene=&quot;F &quot; line=&quot;BLENDER 1 &quot; lineDesc=&quot;Blending machine &quot; phaseSort=&quot;12&quot; phaseNum=&quot;BL&quot; altPhase=&quot; &quot; product=&quot;SF02 &quot; prodDesc=&quot;TM Blend &quot; startDate=&quot;2001-11-08&quot; startTime=&quot;00:00:00&quot; endDate=&quot;2001-11-08&quot; endTime=&quot;00:00:00&quot; />
</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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top