Just outputing in an XML format. It quite powerful however. I have yet to run into a situation where it didn't work well. The exact style of the XML can be dictated.
-----Original Message----- From: Kyle Draganov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: RE: [cf-xml] storing xml in database Jason, Are you storing all the xml formatting in SQL Server or just outputting your data into an xml format? Kyle Draganov -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Askew, Jason Sent: Wednesday, July 10, 2002 9:15 AM To: '[EMAIL PROTECTED]' 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 -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
