Thanks for the info guys. I'm going to get on someones ass about getting
SQL2000. Jason: That's looks really damn useful to me for sure... talk
about convenient.
Kipp
-----Original Message-----
From: Askew, Jason
To: '[EMAIL PROTECTED]'
Sent: 10/07/02 12:51 PM
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_a
ddre
ss_type_id><Street>319 West CatScratch
St</Street><City>Vermillion</City><State>SD</State><ZIP>57069</ZIP><Coun
try>
US</Country></gen_addresses>
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
