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*
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 document.
EXEC sp_xml_prepared
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");
location = XmlSearch(myxm
>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 occ
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
> 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 structure (which
>
> will be seve
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 methodology, the ent
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, Torren
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 u
9 matches
Mail list logo