[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

XML spy- exporting xml into multiple tables

• To: xml-dev@l...
• Subject: XML spy- exporting xml into multiple tables
• From: Neile Bermudes <Neile.Bermudes@e...>
• Date: Fri, 11 Apr 2003 14:32:31 +0100

Hi there,

My question is, how to constuct your xml file so that when you export it to MS SQL using XML Spy, the data will go to it's specified table.

For example, say I've got a database with two tables: Contacts and Organisations. Contacts and Organisations have a relationship set up between them so that whenever you add a Contact, you have to specify what Organisation they belong to. Now, if I want to update a database with an XML file that contains, say, the first name and last name of a contact (which would need to go into the Contact table) and the organisation they belong to (which would need to correspond to an Organisation table that already exists and already has a list of available organisations).

I'm using an attribute-based xml file, e.g.

<root>
<Contact FirstName="Joe" LastName="Bloggs"/>

Where or how would I include Organisation???

Thanks

Neile

--

Neile Bermudes
Network Support Analyst
ECB IT Dept
020 74321241

• Follow-Ups:
  • Re: XML spy- exporting xml into multiple tables
    • From: "Thomas B. Passin" <tpassin@c...>

• Prev by Date: Printing XML+CSS to PDF
• Next by Date: XML Spy or hand written SQL-XML?
• Previous by thread: Printing XML+CSS to PDF
• Next by thread: Re: XML spy- exporting xml into multiple tables
• Index(es):
  • Date
  • Thread