I would like the documentation... could you give me the links and the pages to look at?
Thanks, John Farrar > 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 > -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
