I have what you ask, but my database is in Access 2002. I send you the example for inserting/updating a table from an XML file. I use it for my recent project from Agriculture Departement of Indonesia.
Ahmadie Thaha CF developer in Jakarta, Indonesia --- "Rahuman, Abdul" <[EMAIL PROTECTED]> wrote: > Could you please give me an example for > Inserting/updating a table from an > xml, i am using SQL2000 > > Thanks, > Abdul Rahuman > [EMAIL PROTECTED] > > > -----Original Message----- > From: Askew, Jason [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 11:52 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [cf-xml] storing xml in database > > > What I am doing is 2000 specific, I think, but I > remember hearing you can > add the capabilites to 7.0 somehow... a google > search might turn that up. > > Here's some examples of what I'm going with 2000: > > an example table: > > CREATE TABLE [gen_addresses] ( > [fk_person_id] [int] NOT NULL , > [fk_address_type_id] [int] NOT NULL , > [Phone] [varchar] (15) NULL , > [Street] [varchar] (100) NOT NULL , > [City] [varchar] (50) NOT NULL , > [State] [varchar] (30) NULL , > [ZIP] [varchar] (50) NULL , > [Country] [varchar] (50) NULL , > CONSTRAINT [FK_gen_addresses_gen_address_types] > FOREIGN KEY > ( > [fk_address_type_id] > ) REFERENCES [gen_address_types] ( > [PK_ID] > ), > CONSTRAINT [FK_gen_addresses_gen_person] FOREIGN > KEY > ( > [fk_person_id] > ) REFERENCES [gen_person] ( > [PK_ID] > ) > ) ON [PRIMARY] > GO > > Using: > > select * from gen_addresses for xml auto, elements > > The following is returned: > > <gen_addresses><fk_person_id>1</fk_person_id><fk_address_type_id>1</fk_addre > ss_type_id><Street>319 West CatScratch > St</Street><City>Vermillion</City><State>SD</State><ZIP>57069</ZIP><Country> > US</Country></gen_addresses> > > > > > -----------------------+ > cf-xml mailing list > http://torchbox.com/xml/list.cfm > > > �_________________________________________ > > The information in this electronic mail message is > Cendant Confidential > and may be legally privileged. It is intended > solely for the addressee(s). > Access to this Internet electronic mail message by > anyone else is > unauthorized. If you are not the intended > recipient, any disclosure, > copying, distribution or any action taken or omitted > to be taken in reliance > on it is prohibited and may be unlawful. > > The sender believes that this E-mail and any > attachments were free of any > virus, worm, Trojan horse, and/or malicious code > when sent. This message and > its attachments could have been infected during > transmission. By reading > this message and opening any attachments, the > recipient accepts full > responsibility for taking protective and remedial > action about viruses and > other defects. FISI*Madison L.L.C., Benefit > Consultants, Inc., Long Term > Preferred Care, Inc. and Cendant Strategic Marketing > Group are not liable > for any loss or damage arising in any way from this > message or its > attachments. > > -----------------------+ > cf-xml mailing list > http://torchbox.com/xml/list.cfm __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com
rub.zip
Description: rub.zip
