Re: MS XML Parse

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

Re: MS XML Parse

2011-05-06 Thread John M Bliss
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 ): cfstoredproc procedure=BulkInsert cfprocparam type=In cfsqltype=CF_SQL_LONGVARCHAR value=#varContainingXML# /cfstoredproc PROCEDURE

Re: MS XML Parse

2011-05-06 Thread Russ Michaels
stick it inside a cfsavecontent -- 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*

MS XML Parse

2011-05-03 Thread Torrent Girl
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: cfset getJobs = 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml' cfhttp url=#getJobs# method=GET timeout=1/cfhttp !--- Read the file and

RE: MS XML Parse

2011-05-03 Thread DURETTE, STEVEN J (ATTASIAIT)
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 always

Re: MS XML Parse

2011-05-03 Thread Mark Drew
Maybe it's too big a file this time. the XMlParse function isn't the best when it gets to large documents, time to drop into java :) SAX parsers work even better for large documents. I looked at it and it seems to be a rather big file BTW. Regards Mark Drew On 3 May 2011, at 12:14,

Re: MS XML Parse

2011-05-03 Thread Ian Skinner
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = '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

2011-05-03 Thread Torrent Girl
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = '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

Re: MS XML Parse

2011-05-03 Thread Ian Skinner
On 5/3/2011 10:18 AM, Torrent Girl wrote: Actually, I can dump the contents of the cfhttp.filecontent return with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when

Re: MS XML Parse

2011-05-03 Thread Torrent Girl
On 5/3/2011 10:18 AM, Torrent Girl wrote: Actually, I can dump the contents of the cfhttp.filecontent return with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when