xml-dev - anyone try putting xml into multiple tables in SQL

anyone try putting xml into multiple tables in SQL

[ Lists Home | Date Index | Thread Index ]

To: xml <xml-dev@lists.xml.org>
Subject: anyone try putting xml into multiple tables in SQL
From: Neile Bermudes <Neile.Bermudes@ecb.co.uk>
Date: Fri, 25 Apr 2003 12:15:03 +0100

This seems to be fairly complex...I am trying to update a contact database. Say it has two tables: Person and Organization. There is a many-to-many relationship between the 2 tables (because of the ridiculous complexity in our org.). Say my XML file has a person record and the organization he/she belongs to. How do I export this to SQL so that it updates all the tables- both people, org and the cross reference table?

Anyone experienced something vaguely similar to this before?

Neile

Neile Bermudes

Network Support Analyst

England & Wales Cricket Board

020 74321241

Prev by Date: Re: [xml-dev] Data streams and schema use and identification
Next by Date: Re: [xml-dev] Statistical vs "semantic web" approaches to makingsense of the Net
Previous by thread: Re: [xml-dev] Statistical vs "semantic web" approaches to making senseof the Net
Next by thread: Validation with MSXML - XML against XSD
Index(es):
- Date
- Thread