RE: Storing XML

2003-10-13 Thread Dave Watts
Wow I'd be really surprised if cfhttp was quicker than cffile. Oddly enough, sometimes it is, when used to fetch a file from the local machine. I was very surprised by that myself, as it strikes me as counterintuitive, to say the least. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

RE: Storing XML

2003-10-13 Thread Barney Boisvert
isn't always desirable. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 8:32 AM To: CF-Talk Subject: RE: Storing XML Wow I'd be really surprised if cfhttp was quicker than cffile. Oddly enough, sometimes it is, when used to fetch a file from

RE: Storing XML

2003-10-12 Thread Matthew Walker
Wow I'd be really surprised if cfhttp was quicker than cffile. Another option though is cfinclude: cfsavecontent variable=rawXmlcfinclude template=myxml.xml/cfsavecontent -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, 13 October 2003 3:54 p.m. To: CF-Talk

Re: storing xml in sql

2003-08-26 Thread Massimo Foti
Instead I want to store the data as XML in a text field. Pretty simple right? I format the data using cfwddx. This way I can easily format the data as it comes in and out of the database. It works great. But now I ran into a problem. What if I want to search by model? Say I want all the

Re: storing xml in sql

2003-08-26 Thread Massimo Foti
You may check some native XML database, like Tamino or Xindice but, sincerely I never used them, only read something You may start reading from here: http://xml.apache.org/xindice/ Massimo ~| Archives:

RE: storing xml in sql

2003-08-21 Thread Tony Weeg
to. columnar format, with some keys and good design in mind. tony -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 10:30 PM To: CF-Talk Subject: Re: storing xml in sql 1) Using wddx is, well, a really bad idea. How can you describe a product using

Re: storing xml in sql

2003-08-21 Thread S . Isaac Dealey
1) Using wddx is, well, a really bad idea. How can you describe a product using wddx? _VERY_ easily... cfset product = structnew() cfset product.productname = my product cfset product.price = 20.00 cfset product.description = blah blah blah cfwddx action=cfml2wddx input=#product# output=xml

Re: storing xml in sql

2003-08-21 Thread Thomas Chiverton
On Wednesday 20 Aug 2003 22:27 pm, Alan Quinlan wrote: Instead I want to store the data as XML in a text field. Pretty simple right? Use an XML database, or one that supports a native XML type, such as Oracle. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749

RE: storing xml in sql

2003-08-21 Thread Michael Traher
Im working on something with the best of both worlds i think. I basically made a product_attributes table that links to the product table. All the attribtues can go there. Its not what i originally wanted to do, but im meeting myself in the middle here. hah Hi Alan, I would recommend this last

Re: storing xml in sql

2003-08-20 Thread Kwang Suh
1) Using wddx is, well, a really bad idea. How can you describe a product using wddx? 2) Storing XML in a text field is, well, a bad idea. Besides the obvious performance implications, you're already running into problems with having multiple pieces of data glommed into a big field. Seems to