Kipp,
You can get a free addon from MS for SQL7 to do this
Cheers!
Rob
>>> Kipp Grose <[EMAIL PROTECTED]> 07/10 5:42 pm >>>
Hey Jason:
What version of SQL-Server are you doing this with? I'm using SQL 7 and
I'd think it'd be great to start building my apps that way. Lately at work
I've been doing alot of 'cross-developing' with other companies developers
and servers and everything is becoming more and more XML based for me. It'd
be cool if I could start using my DBs using XML, because I bet you I could
cut and paste a lot of code to give to other developers I'm working with to
update my tables. All I'd need to give them is another DTD, big whoop.
Can you do it with 7? I don't hink we'll be upgrading to 2000 anytime
soon and the only thing i hear about XML is in SQL 2000.
Kipp
-----Original Message-----
From: Askew, Jason
To: '[EMAIL PROTECTED]'
Sent: 10/07/02 12:14 PM
Subject: RE: [cf-xml] storing xml in database
I'll throw in my two cents. I'm using MS SQL server, which has built-in
support for both returing results in XML and using XML to update/insert.
I do all my data in/out of the database in XML. You can download the
'sql
books online' from microsoft for free to get sense of how it all works.
Jason
-----Original Message-----
From: Neil Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 11:11 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [cf-xml] storing xml in database
Please note: This e-mail is confidential and may also be privileged.
Please notify us immediately if you are not the intended recipient. You
should not copy it, forward it or use it for any purpose or disclose the
contents to any person.
-----------------------------------------------------------
if you were using Oracle you could store it in a CLOB which will store
upto 4GB of Character data (if you you do use Oracle I would use the
ODBC drivers and the native ones can be a bit funky with large columns
in my experience).
>>> [EMAIL PROTECTED] 07/10/02 04:50pm >>>
The XML is just text. KEY!!! ... you may need to watch the size of the
file. That is the main issue. Also, coldfusion has settings in the
administrator that control the field size database structure will pass
back
in any one recordset. You will need to check that also.
John Farrar
> Is there something special you have to do to store an xml document in
a
database? I'm using the xml capabilities with CFMX to create my xml
document object and wish to store it in my database. Do I need to
convert
it to something first? Do I use the xmlFormat function? Any insight
would
be appreciated.
>
> Thanks - Tom
>
> -----------------------+
> cf-xml mailing list
> http://torchbox.com/xml/list.cfm
>
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
------------------------------------------------------------
Simmons & Simmons
CityPoint
One Ropemaker Street
London
EC2Y 9SS
Tel +44 (0)20 7628 2020
Fax +44 (0)20 7628 2070
DX 12 London/Chancery Ln
For details of our international offices please visit
www.simmons-simmons.com
A list of partners may be inspected at each office
www.elexica.com is the award winning online legal resource powered by
knowledge from Simmons & Simmons.
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
***************************************************************************
This message has been swept for viruses and other
unsuitable content by the Ofsted Mail Sweeper in
accordance with OFIN 59, however care should be
taken when opening any attachments from an untrusted
source.
***************************************************************************
**********************************************************************
We cannot accept any liability for any loss or damage
sustained as a result of software viruses. It is your
responsibility to carry out such virus checking as is necessary before opening any
attachment to
this message.
The information in this email and any files transmitted with
it may be of a confidential nature and is intended solely for
the addressees. If you are not the intended addressee, any
disclosure, copying or distribution by you is prohibited and
may be unlawful.
www.ofsted.gov.uk
**********************************************************************
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
