	AllExperts > Experts
	Search

XML

Volunteer
Answers to thousands of questions

Home · More Questions · Answer Library

· Encyclopedia ·

Topic: XML

Expert: Ashvin
Date: 3/30/2004
Subject: adding an element

Question
I an getting data from a database in XML form. It looks like this:

<NewDataSet>
<Table1></Table1>
<Table2></Table2>
</NewDataSet>

Every query comes back like this. Each time I update the XML it does so like this:

<NewDataSet>
<Table1></Table1>
<Table2></Table2>
<Table1></Table1>
<Table2></Table2>
</NewDataSet>

I would like it to reform the XML data with a schema. I would like the data to look like this:

<NewDataSet>
<Query>
   <Table1></Table1>
   <Table2></Table2>
</Query>
<Query>
   <Table1></Table1>
   <Table2></Table2>
</Query>
</NewDataSet>

Is this possible? If so, how?

Answer
Hello Don,

I have gone through your code, I am not able to understand how you are getting your XML from the database. I mean to say which language you used for the XML output. It can be done with SQL Query itself and also by using some scripting language. So it will be good if you send me the remaining code for retrinving XML for the Database. I can help you in better way.

Thanks for asking

Take care

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.