OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   XML spy- exporting xml into multiple tables

[ Lists Home | Date Index | Thread Index ]

Title: XML spy- exporting xml into multiple tables

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.

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

Where or how would I include Organisation???




Neile Bermudes
Network Support Analyst
020 74321241


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS