Import from XML

From: Jon Griffin <nospam_at_e88.org>
Date: 2000/02/20
Message-ID: <bBYr4.3357$8h4.37633_at_typhoon.we.mediaone.net>#1/1


I am working on a project where I need to go to different sites and import XML of (for example: cd's).These don't necessarily have a unique identifier. Other than reading each parsed xml record and comparing it to the table, can the insert query look for a record with the same column(s) data (i.e. title,artist) and not insert if it is a duplicate?

Something like:(psuedo code)
insert into table
(artist,title,label,genre)
("artist","title","label","genre")

where
table.artist+table.title ! in
(select * from table)
Received on Sun Feb 20 2000 - 00:00:00 CET

Original text of this message