Re: XML - no encoding

SOLVED: URL had leading space. trim() fixed it. Thanks! :-) On Tue, Jun 17, 2014 at 3:10 PM, John M Bliss wrote: > Element. This changed my XML from this: > > http://myurl.com/?x=y&a=b <http://myurl.com/?x=y&a=b> > > ...to this: > > > > ...wh

Re: XML - no encoding

Element. This changed my XML from this: http://myurl.com/?x=y&a=b ...to this: ...which, I guess, was the desired effect. Now, response I'm getting has changed to, "URL 'http:// http://myurl.com/?x=y&a=b' is not in the expected format." Repeating "http://

Re: XML - no encoding

> CDATA: MyXMLObj.MyXMLChild[1].XMLCData=蘇ttp://myurl.com?x=y&a=b'; > > Most XML libraries for other languages will read CDATA just like they would a > non-escaped node. I'm pretty sure that this will only work for element values, not attribute values. I'm not

Re: XML - no encoding

'; > > ...? > > > On Tue, Jun 17, 2014 at 2:39 PM, Jon Clausen > wrote: > >> >> CDATA: MyXMLObj.MyXMLChild[1].XMLCData=蘇ttp://myurl.com?x=y&a=b'; >> >> Most XML libraries for other languages will read CDATA just like they >&g

Re: XML - no encoding

ld[1].XMLCData=蘇ttp://myurl.com?x=y&a=b'; > > Most XML libraries for other languages will read CDATA just like they > would a non-escaped node. > > On Jun 17, 2014, at 2:33 PM, John M Bliss wrote: > > > > > I'm working with a vendor to troublesho

Re: XML - no encoding

CDATA: MyXMLObj.MyXMLChild[1].XMLCData=‘http://myurl.com?x=y&a=b'; Most XML libraries for other languages will read CDATA just like they would a non-escaped node. On Jun 17, 2014, at 2:33 PM, John M Bliss wrote: > > I'm working with a vendor to troubleshoot an error

XML - no encoding

I'm working with a vendor to troubleshoot an error and he's asked me to *not* replace & with & etc in a URL field. I'm building an XML doc with xmlnew() and then posting it with cfhttp method="post" and I'm not explicitly calling urlencodedformat() or any

RE: Parsing XML response from web services with ColdFusion DeserializeJSON

ot;. Now I'm going to have to go back try again :) Round two. Matt -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, May 09, 2013 12:58 PM To: cf-talk Subject: Re: Parsing XML response from web services with ColdFusion DeserializeJSON > Next,

Re: Parsing XML response from web services with ColdFusion DeserializeJSON

> Next, I do realize that I need to remove the two lines at the very top and > bottom that contain "--uuid ...") and the first three lines > after the first boundary marker which are part of the response header. The > problem here is that simply using Replace() function to > replace those lines

Re: Parsing XML response from web services with ColdFusion DeserializeJSON

t="gSOAP/2.8" > result="httpResponse"> > > value="text/xml"> > > > > value="#len(signOnSoap)#"> > > > > value="no-compression" /> > > > >

RE: Parsing XML response from web services with ColdFusion DeserializeJSON

Hi Che, Thank you for your advice, but unfortunately it didn't help. Here is an error I got: An error occured while Parsing an XML document. Element or attribute do not match QName production: QName::=(NCName':')?NCName. Sincerely, Sasha. -Original Message- Fro

Re: Parsing XML response from web services with ColdFusion DeserializeJSON

ceImmediate"> > > My first question is, have you tried using CFINVOKE to call the web service? That doesn't always work, but it's specifically intended to invoke SOAP services. > Where ckBalRequest is an xml variable created according to the web service > pro

RE: Parsing XML response from web services with ColdFusion DeserializeJSON

Hello Sasha. Try this... Hope this helps... Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/c

Parsing XML response from web services with ColdFusion DeserializeJSON

result="httpResponse"> Where ckBalRequest is an xml variable created according to the web service provider specifications. I have no problem getting the request to them and receiving the response. However, while the response should

Re: neo-runtime xml

all those neo files get backed up automatically when they change, so look for a backup copy in the same folder. I would also strongly suggest you consider taking backups of your server. On Mon, Dec 31, 2012 at 12:37 PM, Ian Chapman wrote: > > Hi Guys, > > (Sorry I may have already posted this

neo-runtime xml

Hi Guys, (Sorry I may have already posted this on my really old login so aplogies for the repost) We had to reboot an old Win2K box which is running MX 6.1. Since the reboot all CF pages are rending as white pages, no source/markup etc. Including /cfide/Administrator. When looking at the ser

Re: duplicate keys in rss xml feed

Ray, Thanks for the suggestion on keys being available as array under the node. I was able to get the values for duplicate keys. Below is the code I used, I guess it can be improved upon On Wed, Dec 5, 2012 at 2:54 PM, Raymond Camden wrote: > > It should be available as

Re: duplicate keys in rss xml feed

It should be available as an array under the node. Can you share the full URL of the feed? If so I can make a demo for you. On Wed, Dec 5, 2012 at 2:41 PM, fun and learning wrote: > > Pennsylvania Primary Roundup > Barack Obama improved his showing among white, middle-class > voters, but not e

duplicate keys in rss xml feed

Hi All - I am parsing rss feed. The feed has custom data and custom data can have duplicate attributes. I am following the example at http://www.raymondcamden.com/index.cfm/2008/4/23/Ask-a-Jedi-Handling-RSS-feeds-with-custom-data. For example if the feed has following data, and the last custom

Re: XML Security

> I was presented with some questions regarding XML and was wondering if there > are any setting in Coldfusion to > disable any of these or I do not need to worry about it since we do not use > any XML in our code: > > 1.  How application employs methods for XML schema val

Re: XML Security

d with some questions regarding XML and was wondering if there > are any setting in Coldfusion to disable any of these or I do not need to > worry about it since we do not use any XML in our code: > > 1.  How application employs methods for XML schema validation. > 2.  How application

XML Security

I was presented with some questions regarding XML and was wondering if there are any setting in Coldfusion to disable any of these or I do not need to worry about it since we do not use any XML in our code: 1. How application employs methods for XML schema validation. 2. How application

Re: XML and "unicode: 0x1a"

I don't want to sound stupid but how does regex work? I could use something similar to this and always fall flat on my face every time someone mentions regex… Ken Hammond IT Director The Salem Group Phone: 630-873-3018 Fax: 630-932-7010 Email: khamm...@saleminc.com www.saleminc.com On F

Re: XML and "unicode: 0x1a"

On 2/24/2012 2:04 AM, Leigh wrote: > > Have you tried a regex replace of "\x1a" ? It *might* work. Worth a shot > anyway. and there are several other codepoints that are illegal in XML. probably should sweep them all away. these are supposed to be a-ok for XML: #x9 | #xA |

Re: XML and "unicode: 0x1a"

Have you tried a regex replace of "\x1a" ? It *might* work. Worth a shot anyway.   -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: h

XML and "unicode: 0x1a"

Apparently, after a billion hours of trying to figure out why I couldn't successfully output some xml data, it seems that the "unicode: 0x1a" character is contained in a text string and making it fail. #xmlformat(thestring)# does not successfully strip it from the string. How c

Re: Is what I'm trying to do with XML even possible?

> In trying to achieve step number 1, I tried to create a document > on my hard drive.  Should this code not create an xml document > on my e: drive? All you need to fetch a file is a single CFHTTP with the PATH and FILE attributes. Dave Watts, CTO, Fig Leaf Software http://www.fi

Re: Is what I'm trying to do with XML even possible?

t > on my hard drive.  Should this code not create an xml document > on my e: drive? > >     > >          URLToPull = 'http://lennox.com/api/v1/z7RRSHM/categories/'; > >     > >                     method   =  'get' >                 timeou

RE: Is what I'm trying to do with XML even possible?

In trying to achieve step number 1, I tried to create a document on my hard drive. Should this code not create an xml document on my e: drive? URLToPull = 'http://lennox.com/api/v1/z7RRSHM/categories/'; -Origin

Re: Is what I'm trying to do with XML even possible?

it's definitely possible. However, you probably don't want to do it all at runtime, if information doesn't change that frequently. For example, I doubt that the categories change every day. So, here's what I'd do. 1. Fetch the XML files periodically, based on their Last-Mod

RE: Is what I'm trying to do with XML even possible?

ge- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, January 04, 2012 10:38 AM To: cf-talk Subject: Is what I'm trying to do with XML even possible? Hi, all... I've been banging my head against this XML wall for over a week now and either I just don't get i

Is what I'm trying to do with XML even possible?

Hi, all... I've been banging my head against this XML wall for over a week now and either I just don't get it or what I'm trying to do is not possible given what the vendor is providing. The vendor of product info provides 3 ways to access product information: Categories, Produ

Re: XML! Aaargh! How do I do this?

BTW, the issue with the existing code is this: xmllennox-products CF thinks you are trying to do maths on xmllennox and products by subtracting one from the other. -- Shu Ha Ri: Agile and .NET blog http://www.bifrost.com.au/ On 2 January 2012 10:10, James Holmes wrote: > xmllennox-product

Re: XML! Aaargh! How do I do this?

Try searching directly for the modelName: Dump that result to see how to get the name. -- Shu Ha Ri: Agile and .NET blog http://www.bifrost.com.au/ On 2 January 2012 09:18, Rick Faircloth wrote: > At this point, all I'm really after is the "modelName/text()" ~

RE: XML! Aaargh! How do I do this?

pastbin. Thanks for the feedback! Rick Lennox XML Search Test xmlSearch() XPath

RE: XML! Aaargh! How do I do this?

What are the values of xmllennox in the xml page (or what is it supposed to be derived from)? And what is the search trying to search for? -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Sunday, January 01, 2012 3:53 PM To: cf-talk Subject: RE: XML

Re: XML! Aaargh! How do I do this?

Rick, I generally find the easiest way to work through an XML doc is to create a page that just converts it to an XMLDOC first using or xmlparse() and them CFDUMP the result. This makes it must easier to find the node references you need to loop through or reference. I also prefer to simplify

RE: XML! Aaargh! How do I do this?

Hopefully, the error of my ways will be obvious to thos of you who work with xml a lot, but...HELP!!! Given this demo xml: Air Conditioners Air Conditioners XC21

RE: XML! Aaargh! How do I do this?

Thanks for the info, James! I had actually been doing some more research on CF and XML and was reading about xmlSearch. I'll give that try, too. Rick -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, December 30, 2011 8:14 PM To: cf-talk Subjec

RE: XML! Aaargh! How do I do this?

Thanks for the tip, Justin! I'll give it a try! Rick -Original Message- From: Justin Scott [mailto:leviat...@darktech.org] Sent: Friday, December 30, 2011 7:51 PM To: cf-talk Subject: Re: XML! Aaargh! How do I do this? > Okay... I've worked this every way I can thin

Re: XML! Aaargh! How do I do this?

If you are just after products, you can dramatically simplify the code by using xmlsearch() to get them with xpath instead of manually looping multiple levels down. -- Shu Ha Ri: Agile and .NET blog http://www.bifrost.com.au/ On 31 December 2011 08:50, Justin Scott wrote: > > > Okay... I've w

Re: XML! Aaargh! How do I do this?

> Okay... I've worked this every way I can think > of and, I admit it, I just don't get it. Hi Rick, replace your inner-most loop with the following. It should get you going in the right direction. It looks like there is another layer of sub-categories which needs to be accounted for:

XML! Aaargh! How do I do this?

n't figure out how to loop through the products. Clues for the cluesless? Rick PS - you can see the cfdumps in the code to show the actual XML I'm trying to work with. I've seen examples of the XML data put into a database and then worked with from there. Would that be prefer

Re: Save Form Data to XML file

... > >then you can do: > >colCount = listLen(form.align); >xml = ""; >for (i = 1; i LTE colCount; i++) { > xml &= ""; > xml &= "#listGetAt(form.align, i)#"; > xml &= "#listGetAt(form.dname, i)#&

Re: Save Form Data to XML file

If you don't care about the form of the XML, you can also use WDDX to do the conversion in one quick call. On Wed, Dec 14, 2011 at 10:53 PM, Mike Kear wrote: > > IF you use  you should see a struct called "form" > with each of your form fields and their settings from

Re: Save Form Data to XML file

IF you use you should see a struct called "form" with each of your form fields and their settings from the submitted form. If you use Daniel Gaspar <http://www.danielgaspar.com/>'s ANYTHINGXOXML.cfc you can automatically convert it to XML without any effort. http://anyth

Re: Save Form Data to XML file

So, if you have an arbitrary number of columns and when you submit the form you get: form.align=left,left,... form.dname=Agent Version,Allow Client,... then you can do: colCount = listLen(form.align); xml = ""; for (i = 1; i LTE colCount; i++) { xml &= "";

Save Form Data to XML file

Hello, I have been searching all over cf-talk archives and on google and I don't see a good example on how to save form data to a xml file. So what I'm doing right now is, I have a xml file and read that and then display it in a form so the it can be edited. Here is an example o

Re: FCKEditor.. XML Request error: Access denied (403)

This is disabled by default, you need to enable it via a Java System Property, see details here: http://www.petefreitag.com/item/718.cfm -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting & Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is

FCKEditor.. XML Request error: Access denied (403)

Coldfusion 9, just started has been working fine on all the websites until today when using FCKEditor to browse server for an image. Any Ideas? Java recently Updated. Terry ~| Order the Adobe Coldfusion Anthology now! http://

Re: XML signature generation failed

No the code does not write to file system. However, it reads a config file and a PFX certificate file to generate the XML signature. Isidro On 10/21/11 9:53 PM, "Dave Watts" wrote: > >> I am invoking a java method that will generate an xml signature. I >>successfu

Re: XML signature generation failed

> I am invoking a java method that will generate an xml signature. I > successfully invoke and define the method, however if the method if the code > is run > more more than once, the first user gets the XML signature the second user > gets the error XML signature generation fai

XML signature generation failed

Hello all, I am invoking a java method that will generate an xml signature. I successfully invoke and define the method, however if the method if the code is run more more than once, the first user gets the XML signature the second user gets the error XML signature generation failed. Can

Re: XML parse

are you sure that CF is actually getting the XML ? try grabbing it with CFHTTP first instead just to make sure. On Wed, Sep 21, 2011 at 2:02 PM, Torrent Girl wrote: > > Hi all > > I tried to parse the XML from the following feed as I normally do and kept > getting error

Re: XML parse

"Jobs" is capitalized in the XML. This works: http://feeds.jobs2web.com/feeds/view?siteId=246&feedId=682";)> On Wed, Sep 21, 2011 at 9:02 AM, Torrent Girl wrote: > > Hi all > > I tried to parse the XML from the following feed as I normally do and k

XML parse

Hi all I tried to parse the XML from the following feed as I normally do and kept getting error messages ("not defined") on everything I tried. http://feeds.jobs2web.com/feeds/view?siteId=246&feedId=682 Here are a few snippets that I tried: http://feeds.jobs2web.com/feeds/v

Re: Spam:*******, Re: RETS - Real Estate Standards Organization - XML feed - anyone have any experience

a RETS client in ColdFusion once. > It's market specific and the client owns the code. The best I can suggest is > to look at phRets and decided if you want to use that or rewrite that to > ColdFusion. > > The thing to remember it that it's all XML. NExt you have to make h

Re: RETS - Real Estate Standards Organization - XML feed - anyone have any experience

s the code. The best I can suggest is to look at phRets and decided if you want to use that or rewrite that to ColdFusion. The thing to remember it that it's all XML. NExt you have to make http calls to get the meta data, then parse that out then do another http call to get the next leve

RETS - Real Estate Standards Organization - XML feed - anyone have any experience

I need to convert over a couple of real estate website that are currently receiving MLS data via an hourly FTP feed. The new system handed down by the National Association of Realtors is RETS . Do any of you know if there are any CFC functions out there that would make

Re: Coldfusion 9 XML creation and HTML after

my guess is that you have answered your question by saying that you could use a cflocation tag. Alternatively, if you trust your xml scrip to always create the xml document without errors, you may use a prompt to display your activity status just before you use the xml script. Best Regrads

Re: Coldfusion 9 XML creation and HTML after

> Here is what I am running into.  I have a web form that takes in the info I > need.  I process the form on the next page and it creates an XML document > that I need (which is being created successfully).  I need to display > something back to the end user telling them it's bee

Re: Coldfusion 9 XML creation and HTML after

can you post the code here http://pastebin.com/ <http://pastebin.com/> On Fri, May 13, 2011 at 5:43 PM, Ken Hammond wrote: > > Here is what I am running into. I have a web form that takes in the info I > need. I process the form on the next page and it creates an XML documen

Coldfusion 9 XML creation and HTML after

Here is what I am running into. I have a web form that takes in the info I need. I process the form on the next page and it creates an XML document that I need (which is being created successfully). I need to display something back to the end user telling them it's been created. Aft

Re: MS XML Parse

stick it inside a -- Russ Michaels www.bluethunderinternet.com : Business hosting services & solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me*

Re: MS XML Parse

If you're using SQL Server, it'll auto-handle the XML directly with no pre-parsing with CF (SEE http://msdn.microsoft.com/en-us/library/ms186918.aspx ): PROCEDURE [BulkInsert] @doc text AS BEGIN DECLARE @idoc int --Create an internal representation of the XML docu

Re: MS XML Parse

Hi all. I have been able to output my values from the xml (YAY!!) using xmlSearch (Thanks Guys). Here is my code: myxmldoc = XmlParse("E:\domains\aawit.net\wwwroot\Microsoft-Diversity-AAWIT116obs.xml"); title= XmlSearch(myxmldoc, "/jobs/job/title");

Re: MS XML Parse

ory. > >The problem will occur when you try to parse that flat text into a DOM >relational data structure. > >Now IF you do not need to parse the flat data, you can use >xmlTransform(), and maybe xmlSearch(), to apply XPATH to the large flat >text data and create smaller subset

Re: MS XML Parse

r when you try to parse that flat text into a DOM relational data structure. Now IF you do not need to parse the flat data, you can use xmlTransform(), and maybe xmlSearch(), to apply XPATH to the large flat text data and create smaller subsets of the XML. That might get you where you need

Re: MS XML Parse

> On 5/3/2011 9:14 AM, Torrent Girl wrote: > > > > That looks to be a pretty large XML document. There are definite > limits > on how large of document that xmlParse() can process. As xmlParse > uses > a DOM parsing methodology, the entire resulting data str

Re: MS XML Parse

On 5/3/2011 9:14 AM, Torrent Girl wrote: > 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml'> That looks to be a pretty large XML document. There are definite limits on how large of document that xmlParse() can process. As xmlParse uses a DOM parsing

Re: MS XML Parse

, at 12:14, Torrent Girl wrote: > > Hello all. > > I am trying to parse thru an XML feed using the method that I always use and > it's not working: > > Here is my code: > > 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml'> > &

RE: MS XML Parse

Are you sure that someone didn't screw up the XML in the file? -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Tuesday, May 03, 2011 12:15 PM To: cf-talk Subject: MS XML Parse Hello all. I am trying to parse thru an XML feed using the method that I a

MS XML Parse

Hello all. I am trying to parse thru an XML feed using the method that I always use and it's not working: Here is my code: The dump doesn't show up. I just get a blank screen. Any suggestions? TIA ~|

Re: Coldfusion 9 & SQL Server 2008 XML bulkload

e > > Steve > > Sent from my iPhone > > On May 3, 2011, at 12:48 AM, Kam Heydari wrote: > >> >> Hi, >> Anyone know how to pass file name to the bulkload when sqlserver and >> coldfision servers are on different physical servers; The following xml lo

Re: Coldfusion 9 & SQL Server 2008 XML bulkload

then you reference it as > \\sernername\sharename\filename > > Steve > > Sent from my iPhone > > On May 3, 2011, at 12:48 AM, Kam Heydari wrote: > > > > > Hi, > > Anyone know how to pass file name to the bulkload when sqlserver and > coldfision servers are

Re: Coldfusion 9 & SQL Server 2008 XML bulkload

pass file name to the bulkload when sqlserver and > coldfision servers are on different physical servers; The following xml load > works when both SQl and CF servers are residing on the same physical server. > - How I can refer to the local file where sqlserver can access it? > -

Coldfusion 9 & SQL Server 2008 XML bulkload

Hi, Anyone know how to pass file name to the bulkload when sqlserver and coldfision servers are on different physical servers; The following xml load works when both SQl and CF servers are residing on the same physical server. - How I can refer to the local file where sqlserver can access it

RE: Big XML files processing Really s-l-o-w. Solution?

From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Saturday, February 19, 2011 8:06 PM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? Here's the update: Jochem's StAX-based solution worked so well -- and it allowed me to re-use existing code sinc

RE: Big XML files processing Really s-l-o-w. Solution?

Nice... -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Saturday, February 19, 2011 9:06 PM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? Here's the update: Jochem's StAX-based solution worked so well -- and it all

Re: Big XML files processing Really s-l-o-w. Solution?

Nice report! I'll try and remember that the next time I have to parse huge XML files. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Ar

Re: Big XML files processing Really s-l-o-w. Solution?

Here's the update: Jochem's StAX-based solution worked so well -- and it allowed me to re-use existing code since I was already processing xml -- that I didn't bother to consider testing the xml2csv utility. Original code processing a 45mb file yielded an insert time of 90 sec

Re: Big XML files processing Really s-l-o-w. Solution?

On Thu, Feb 17, 2011 at 8:56 AM, Rick Faircloth wrote: > > Good to know! Indeed. Thanks to Marco and Mark. I plan on trying out both this and Jochem's solution starting maybe as soon as tomorrow and certainly through the long U.S. holiday weekend. Maybe try both and see which is faster. I'll

RE: Big XML files processing Really s-l-o-w. Solution?

Good to know! -Original Message- From: Marco Antonio C. Santos [mailto:marcoacsan...@gmail.com] Sent: Thursday, February 17, 2011 10:54 AM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? In our company I found a solution to parse big XML files in

RE: Big XML files processing Really s-l-o-w. Solution?

-Mark -Original Message- From: Marco Antonio C. Santos [mailto:marcoacsan...@gmail.com] Sent: Thursday, February 17, 2011 9:54 AM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? In our company I found a solution to parse big XML files in ColdFusion application

Re: Big XML files processing Really s-l-o-w. Solution?

In our company I found a solution to parse big XML files in ColdFusion applications: 1) using xml2csv(http://www.a7soft.com/xml2csv.html), a very fast application to convert XML to csv file; 2) with SQL Server BULK INSERT to insert in our database Using this approach reduced time in 100 times

RE: Big XML files processing Really s-l-o-w. Solution?

No problem... I haven't done much with XML, myself, so I thought this presented a good opportunity to learn something new, too. Let us know how the solution you're working on pans out. -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Thursday, F

Re: Big XML files processing Really s-l-o-w. Solution?

On Wed, Feb 16, 2011 at 8:08 PM, Rick Faircloth wrote: > Perhaps this will be of some help. Thanks Rick, Interesting stuff. I don't work with xml so much so a lot of this is new, and I hate new :-). I haven't been a full-time programmer for a few years now so I haven't kept

RE: Big XML files processing Really s-l-o-w. Solution?

Hi, Matt... I've been tinkering with parsing the xml file and, though I haven't developed a full solution, I've made some progress that I thought I'd share. I created a MySQL 5 database called, "xmlTest". I created a MySQL 5 database table called, "xmlBlob&qu

Re: Big XML files processing Really s-l-o-w. Solution?

file's CSV-format predecessor. But there are no CR's or LF's in the file so that is out. Thanks very much for that post and your thoughts. Incidentally if anyone is looking for an xml reader/editor that can almost instantly read these kinds of moster files, check out the free fir

Re: Big XML files processing Really s-l-o-w. Solution?

seems to be about 66 hours for a 45 mb file and thats a disaster. Would it help if you split the file into individual records before processing them? http://jochem.vandieten.net/2011/02/17/splitting-large-xml-files-with-coldfusion-and-stax/ Jochem -- Jochem van Dieten http://joc

Re: Big XML files processing Really s-l-o-w. Solution?

ve looked at this link at dev.mysql.com > for a solution to processing your data feed, but I thought I'd > bring it up, just in case you haven't seen it. Looks like it > might be right up your alley. > > > http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.

Re: Big XML files processing Really s-l-o-w. Solution?

records I want to pull in. - I can write CF code to pull the price and currency out of the pricing section, but how would mySQL do something like that where the xml design was made as complicated as humanly possible? (this format is StarStandard.org-based, btw) - Note the ImageAttachmentExtended

RE: Big XML files processing Really s-l-o-w. Solution?

Hi, Matt... I know you might have looked at this link at dev.mysql.com for a solution to processing your data feed, but I thought I'd bring it up, just in case you haven't seen it. Looks like it might be right up your alley. http://dev.mysql.com/tech-resources/articles/xml-in-my

Re: Big XML files processing Really s-l-o-w. Solution?

Hey everybody, we're in a bind here and I pitched the idea to the client of bringing in a ringer. Is there someone out there who is interested in building a direct-to-SQL Server or direct-to-mySQL-based solution? Solution would have to, on a scheduled basis, grab a file in a location on the serv

Re: Big XML files processing Really s-l-o-w. Solution?

Very interesting stuff, guys. Very much appreciated. Should have come here before I did the project as opposed to afterward. You'd think I'd know better by now. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~~~

Re: Big XML files processing Really s-l-o-w. Solution?

insert isn't an > option. > > > On Mon, Feb 14, 2011 at 7:24 PM, Alan Rother > wrote: > > > > > When in doubt, ask Ben Nadel(or check his blog)... Words to live by > > > > I had the same issue, huge variable XML file, lots of variations, had a > >

Re: Big XML files processing Really s-l-o-w. Solution?

That actually looks like a pretty nice solution if bulkinsert isn't an option. On Mon, Feb 14, 2011 at 7:24 PM, Alan Rother wrote: > > When in doubt, ask Ben Nadel(or check his blog)... Words to live by > > I had the same issue, huge variable XML file, lots of variations, ha

Re: Big XML files processing Really s-l-o-w. Solution?

Processing the XML with Java rather than CFML will speed things up. check riaforge.org or cflib.org and the adobe exchange, somewhere there is a XML parser that does just this and may give you the boost you want. Russ On Tue, Feb 15, 2011 at 12:15 AM, Casey Dougall <

Re: Big XML files processing Really s-l-o-w. Solution?

When in doubt, ask Ben Nadel(or check his blog)... Words to live by I had the same issue, huge variable XML file, lots of variations, had a hell of a time making it work in SQL Server due to the complexity Used this, works amazingly well, all things considered, executes very quickly http

Re: Big XML files processing Really s-l-o-w. Solution?

hing simular to BulkInsert where the xml file is on the MySql Server. http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Antholog

  1   2   3   4   5   6   7   8   9   10   >