RE: xml question
Seamus I think your problem is that you have coldfusion tags inside the string being set to tempxml and is thus being ignored instead of interpreted. What version of cf are you using? If you are using CF5 you can use cfsavecontent to wrap the output instead of using cfset. In CFMX I think there are some XML functions which should allow you to do this more cleanly. Finally It may sound silly but double check that the query actually returns multiple rows. HTH Kola >> -Original Message- >> From: Seamus Campbell [mailto:[EMAIL PROTECTED]] >> Sent: 11 December 2002 11:02 >> To: CF-Talk >> Subject: xml question >> >> Hi >> I'm grappling with some xml >> I want to export data from my database in an xml file but I only get the >> 1st record >> I'm doing this: (but I can't see how to loop over each record) >> >> >> SELECT tblWEBSTOCKLEVEL.CustomerID, tblWEBSTOCKLEVEL.ProductCode, >> tblWEBSTOCKLEVEL.ProductDescription, tblWEBSTOCKLEVEL.StockLevel >> FROM tblWEBSTOCKLEVEL >> WHERE (((tblWEBSTOCKLEVEL.CustomerID)=1)); >> >> >> >> >> >> #trim("#XMLFormat(get_data.CustomerID)#")# >> >> >> > ProductCode=""#trim("#XMLFormat(get_data.ProductCode)#")#"" >> ProductDescription=""#trim("#XMLFormat(get_data.ProductDescription)#")#" " >> StockLevel=""#trim("#XMLFormat(get_data.StockLevel)#")#""/> >> >> >> >> "> >> >> Can anyone help me please with the looping needed to get each record >> rather >> than just the first one. >> Many thanks >> Seamus >> >> >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: xml question
Thanks Kola, I have checked that the query returns multiple records - and it does. I am using CF5. I can write & read the xml file - but as you suggest the is getting ignored (I think). This is my xml file - - 1 - - Any help gratefully received (I tried cfsavecontent but can't get the stuff within the cfloop to get interpreted) At 22:27 11/12/02 , you wrote: >Seamus > >I think your problem is that you have coldfusion tags inside the string >being set to tempxml and is thus being ignored instead of interpreted. >What version of cf are you using? If you are using CF5 you can use >cfsavecontent to wrap the output instead of using cfset. > >In CFMX I think there are some XML functions which should allow you to >do this more cleanly. > >Finally It may sound silly but double check that the query actually >returns multiple rows. > >HTH > >Kola > > >> -Original Message- > >> From: Seamus Campbell [mailto:[EMAIL PROTECTED]] > >> Sent: 11 December 2002 11:02 > >> To: CF-Talk > >> Subject: xml question > >> > >> Hi > >> I'm grappling with some xml > >> I want to export data from my database in an xml file but I only get >the > >> 1st record > >> I'm doing this: (but I can't see how to loop over each record) > >> > >> dbtype="ODBC"> > >> SELECT tblWEBSTOCKLEVEL.CustomerID, tblWEBSTOCKLEVEL.ProductCode, > >> tblWEBSTOCKLEVEL.ProductDescription, tblWEBSTOCKLEVEL.StockLevel > >> FROM tblWEBSTOCKLEVEL > >> WHERE (((tblWEBSTOCKLEVEL.CustomerID)=1)); > >> > >> > >> > >> > >> > >> #trim("#XMLFormat(get_data.CustomerID)#")# > >> > >> > >> >> ProductCode=""#trim("#XMLFormat(get_data.ProductCode)#")#"" > >> >ProductDescription=""#trim("#XMLFormat(get_data.ProductDescription)#")#" >" > >> StockLevel=""#trim("#XMLFormat(get_data.StockLevel)#")#""/> > >> > >> > >> > >> "> > >> > >> Can anyone help me please with the looping needed to get each record > >> rather > >> than just the first one. > >> Many thanks > >> Seamus > >> > >> > >> > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: xml question
Seamus I noticed a few things which may stop it from working. First Cfsavecontent still requires ## around variables you want displayed and the call to cfsavecontent needs to be wrapped in cfoutput tags Second I don't think you need to escape the double quotes, if you do, Use single quotes instead this should make the code more readable Also you had quotes where they're not needed e.g. when using the trim function if the value is a function call or a variable you do not need the quotes. Finally the line.. #trim("#XMLFormat(get_data.CustomerID)#")# will always return one as this is not inside the loop so it will always refer to the first record not sure if that's what you wanted. I have cleaned the code up a little below let me know if this works.. SELECT tblWEBSTOCKLEVEL.CustomerID, tblWEBSTOCKLEVEL.ProductCode, tblWEBSTOCKLEVEL.ProductDescription, tblWEBSTOCKLEVEL.StockLevel FROM tblWEBSTOCKLEVEL WHERE (((tblWEBSTOCKLEVEL.CustomerID)=1)); #trim(XMLFormat(get_data.CustomerID))# HTH Kola >> -Original Message- >> From: Seamus Campbell [mailto:[EMAIL PROTECTED]] >> Sent: 11 December 2002 12:23 >> To: CF-Talk >> Subject: RE: xml question >> >> Thanks Kola, >> I have checked that the query returns multiple records - and it does. >> I am using CF5. >> I can write & read the xml file - but as you suggest the is >> getting ignored (I think). >> This is my xml file >> - >> >> - >> 1 >> - >> - >> > StockLevel="4992" /> >> >> >> >> >> >> Any help gratefully received >> >> (I tried cfsavecontent but can't get the stuff within the cfloop to get >> interpreted) >> >> >> >> >> At 22:27 11/12/02 , you wrote: >> >Seamus >> > >> >I think your problem is that you have coldfusion tags inside the string >> >being set to tempxml and is thus being ignored instead of interpreted. >> >What version of cf are you using? If you are using CF5 you can use >> >cfsavecontent to wrap the output instead of using cfset. >> > >> >In CFMX I think there are some XML functions which should allow you to >> >do this more cleanly. >> > >> >Finally It may sound silly but double check that the query actually >> >returns multiple rows. >> > >> >HTH >> > >> >Kola >> > >> > >> -Original Message- >> > >> From: Seamus Campbell [mailto:[EMAIL PROTECTED]] >> > >> Sent: 11 December 2002 11:02 >> > >> To: CF-Talk >> > >> Subject: xml question >> > >> >> > >> Hi >> > >> I'm grappling with some xml >> > >> I want to export data from my database in an xml file but I only get >> >the >> > >> 1st record >> > >> I'm doing this: (but I can't see how to loop over each record) >> > >> >> > >> > >dbtype="ODBC"> >> > >> SELECT tblWEBSTOCKLEVEL.CustomerID, tblWEBSTOCKLEVEL.ProductCode, >> > >> tblWEBSTOCKLEVEL.ProductDescription, tblWEBSTOCKLEVEL.StockLevel >> > >> FROM tblWEBSTOCKLEVEL >> > >> WHERE (((tblWEBSTOCKLEVEL.CustomerID)=1)); >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> #trim("#XMLFormat(get_data.CustomerID)#")# >> > >> >> > >> >> > >> > > >> ProductCode=""#trim("#XMLFormat(get_data.ProductCode)#")#"" >> > >> >> >ProductDescription=""#trim("#XMLFormat(get_data.ProductDescription)#")# " >> >" >> > >> StockLevel=""#trim("#XMLFormat(get_data.StockLevel)#")#""/> >> > >> >> > >> >> > >> >> > >> "> >> > >> >> > >> Can anyone help me please with the looping needed to get each record >> > >> rather >> > >> than just the first one. >> > >> Many thanks >> > >> Seamus >> > >> >> > >> >> > >> >> > >> > >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: xml question
I think if you reference the DTD in the XML document won't IE display it the way it should look? I usually just use the MS XML parser and walk through it doing what I need to do with each node. J. John Wilker "Codito, ergo sum" Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked "Do you know DOS?" The reply was: "No, but I met Tom and Drew a few minutes ago." -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 10:51 AM To: CF-Talk Subject: xml question If i have a DTD for an xml document that i am getting back, as a response from a webservice, whats the easiest way to take that xml feed that i get back, and format for a web page (using that DTD?) and i dont have cfmx, just cf 5.0 thanks! ..tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml question
how does one reference a dtd in an xml doc? ive looked, and im coming up shortthanks. tony -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 2:42 PM To: CF-Talk Subject: RE: xml question I think if you reference the DTD in the XML document won't IE display it the way it should look? I usually just use the MS XML parser and walk through it doing what I need to do with each node. J. John Wilker "Codito, ergo sum" Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked "Do you know DOS?" The reply was: "No, but I met Tom and Drew a few minutes ago." -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 10:51 AM To: CF-Talk Subject: xml question If i have a DTD for an xml document that i am getting back, as a response from a webservice, whats the easiest way to take that xml feed that i get back, and format for a web page (using that DTD?) and i dont have cfmx, just cf 5.0 thanks! .tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml question
so i have this http://localhost/clients/cx_WebServiceApp/xml_123/CXout.dtd";> but it still shows the doc as xml not html? any ideas? thanks tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 2:50 PM To: CF-Talk Subject: RE: xml question how does one reference a dtd in an xml doc? ive looked, and im coming up shortthanks. tony -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 2:42 PM To: CF-Talk Subject: RE: xml question I think if you reference the DTD in the XML document won't IE display it the way it should look? I usually just use the MS XML parser and walk through it doing what I need to do with each node. J. John Wilker "Codito, ergo sum" Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked "Do you know DOS?" The reply was: "No, but I met Tom and Drew a few minutes ago." -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 10:51 AM To: CF-Talk Subject: xml question If i have a DTD for an xml document that i am getting back, as a response from a webservice, whats the easiest way to take that xml feed that i get back, and format for a web page (using that DTD?) and i dont have cfmx, just cf 5.0 thanks! tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml question
> If i have a DTD for an xml document that i am > getting back, as a response from a webservice, whats > the easiest way to take that xml feed that i get > back, and format for a web page (using that DTD?) I think you're misunderstanding the purpose of a DTD, which is not to provide formatting instructions, but rather to validate a given XML document that references the DTD. A DTD lists all of the possible elements, their possible attributes, and the hierarchical relationship between those elements. An XML parser can then parse the XML document. If the document can be parsed by the XML parser, it is said to be "well-formed", meaning that it adheres to the generic syntactical rules of XML. The XML parser may then check the document against the DTD, to make sure that it follows the rules specified in that DTD. If the document passes that test, it is said to be "valid". None of this has anything to do with formatting; the main point of XML (to greatly oversimplify things here) is to separate data from device-specific formatting, which is the problem with HTML. If you want to format an XML document for display on a specific device, such as an HTML browser, you'd typically transform the XML document into another language, like XHTML. The standard way to do this is to write an XSL transform, which is basically an XML document itself, which contains rules for converting a document in one XML language to some other format. Most XML parsers are capable of taking an XML document and applying an XSL transformation to that document. In CF MX, you'd use the XMLTransform function for this. In CF MX, you'd use whatever XML parser you're already using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml question
ok , got that, that made/makes sense...i had sorta figgered that out, when i had already hit "Send"...so then, dave, whats ur take on using css-2 to format that xml doc, into html? or would you use xsl to transform the xml to html? tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 3:45 PM To: CF-Talk Subject: RE: xml question > If i have a DTD for an xml document that i am > getting back, as a response from a webservice, whats > the easiest way to take that xml feed that i get > back, and format for a web page (using that DTD?) I think you're misunderstanding the purpose of a DTD, which is not to provide formatting instructions, but rather to validate a given XML document that references the DTD. A DTD lists all of the possible elements, their possible attributes, and the hierarchical relationship between those elements. An XML parser can then parse the XML document. If the document can be parsed by the XML parser, it is said to be "well-formed", meaning that it adheres to the generic syntactical rules of XML. The XML parser may then check the document against the DTD, to make sure that it follows the rules specified in that DTD. If the document passes that test, it is said to be "valid". None of this has anything to do with formatting; the main point of XML (to greatly oversimplify things here) is to separate data from device-specific formatting, which is the problem with HTML. If you want to format an XML document for display on a specific device, such as an HTML browser, you'd typically transform the XML document into another language, like XHTML. The standard way to do this is to write an XSL transform, which is basically an XML document itself, which contains rules for converting a document in one XML language to some other format. Most XML parsers are capable of taking an XML document and applying an XSL transformation to that document. In CF MX, you'd use the XMLTransform function for this. In CF MX, you'd use whatever XML parser you're already using. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml question
> ok , got that, that made/makes sense...i had sorta figgered > that out, when i had already hit "Send"...so then, dave, whats > ur take on using css-2 to format that xml doc, into html? > or would you use xsl to transform the xml to html? I'd probably use XSL. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: xml question
Unless you have some very complex, varied, or large xml documents, you may want to simply convert your xml into a CF datatype (a structure) and get a lot more flexibility as far as your design goes. SOXML can do this. If this is going to be running on a CF platform, why not use it? Either that, or if you are doing DOM parsing, use the XML DOM object to choose which parts to display as John suggested. CSS and XSL really tackle two different problems. XSL is used to transform the particular XML doc into something else, using various bits of logic. CSS is just CSS, it's just has to do with the display of elements, just as when you style html elements. CSS has no way to do any kind of testing on the element (other than IE's css expressions...), XSL does. The two technologies complement each other. -- jon mailto:[EMAIL PROTECTED] Saturday, August 10, 2002, 3:47:23 PM, you wrote: TW> ok , got that, that made/makes sense...i had sorta figgered that TW> out, when i had already hit "Send"...so then, dave, whats ur take TW> on using css-2 to format that xml doc, into html? or would you use xsl TW> to transform the xml to html? TW> tony __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Question
If you're on NT you could use a com object, or use some of the other freely available tools. MS has a set of com-based xml tools. Depending on your app, you might be able to write it in JavaScript. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, May 22, 2000 7:22 PM To: [EMAIL PROTECTED] Subject: XML Question Ok I get the gist on how to use WDDX, but how would I read in an XML document? Same prinipal, 3rd party utility? Bob Everland -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: XML Question
Bob, I wrote an article on using the MS XMLDOM COM object with CF to parse conventional XML files; it's at: http://www.sys-con.com/xml/archives/0102/gassner/index.html Take a look and email me off-list if you need any clarification. David > -Original Message- > From: Robert Everland III [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 22, 2000 7:22 PM > To: [EMAIL PROTECTED] > Subject: XML Question > > > Ok I get the gist on how to use WDDX, but how would I read in an XML > document? Same prinipal, 3rd party utility? > > > Bob Everland > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: XML Question
David, The "Tech Note" you are refering to " www.allaire.com/handlers/index.cfm?ID=14244&Method=Full#1020244 " does not work. I have an open incident with Allaire, wherein they are trying to figure out why. Evidently after they fix the problem they are going to update the knowledge base article. - Original Message - From: "David Gassner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 23, 2000 7:29 AM Subject: RE: XML Question > Bob, I wrote an article on using the MS XMLDOM COM object with CF to parse > conventional XML files; it's at: > > http://www.sys-con.com/xml/archives/0102/gassner/index.html > > Take a look and email me off-list if you need any clarification. > > David > > > -Original Message- > > From: Robert Everland III [mailto:[EMAIL PROTECTED]] > > Sent: Monday, May 22, 2000 7:22 PM > > To: [EMAIL PROTECTED] > > Subject: XML Question > > > > > > Ok I get the gist on how to use WDDX, but how would I read in an XML > > document? Same prinipal, 3rd party utility? > > > > > > Bob Everland > > > > -- > > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: XML Question
Check out http://www.xmltree.com. James Carlyle has set up an excellent resource for XML content. If you search the discussion forums you will find a lot of great information on handling XML with CF. HTH, Steve -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, May 22, 2000 10:22 PM To: [EMAIL PROTECTED] Subject: XML Question Ok I get the gist on how to use WDDX, but how would I read in an XML document? Same prinipal, 3rd party utility? Bob Everland -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: XML Question
Interesting; I never actually tested Allaire's approach, but included the reference in my article for the sake of completeness. My article focuses on parsing xml file's document object model, rather than translation with xls (which the knowledgebase article deals with). Side note: I've been playing with IBM's java-based xerces processor from and have been having some good results. David > -Original Message- > From: Sean Renet [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 23, 2000 11:09 AM > To: [EMAIL PROTECTED] > Subject: Re: XML Question > > > David, > The "Tech Note" you are refering to " > www.allaire.com/handlers/index.cfm?ID=14244&Method=Full#1020244 " > does not > work. I have an open incident with Allaire, wherein they are trying to > figure out why. Evidently after they fix the problem they are going to > update the knowledge base article. > - Original Message - > From: "David Gassner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 23, 2000 7:29 AM > Subject: RE: XML Question > > > > Bob, I wrote an article on using the MS XMLDOM COM object with > CF to parse > > conventional XML files; it's at: > > > > http://www.sys-con.com/xml/archives/0102/gassner/index.html > > > > Take a look and email me off-list if you need any clarification. > > > > David > > > > > -Original Message- > > > From: Robert Everland III [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, May 22, 2000 7:22 PM > > > To: [EMAIL PROTECTED] > > > Subject: XML Question > > > > > > > > > Ok I get the gist on how to use WDDX, but how would I read in an XML > > > document? Same prinipal, 3rd party utility? > > > > > > > > > Bob Everland > > > > > > -- > > > > > > Archives: http://www.eGroups.com/list/cf-talk > > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > > _talk or send a message to [EMAIL PROTECTED] with > > 'unsubscribe' in the body. > > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: XML Question
yes, you would think someone would have tested the knowledge base article. I though it necessary to point this out as you directed someone that asked how to parse an XML file into CFML to your article which references this doc as the means to do such. - Original Message - From: "David Gassner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 23, 2000 11:27 AM Subject: RE: XML Question > Interesting; I never actually tested Allaire's approach, but included the > reference in my article for the sake of completeness. My article focuses on > parsing xml file's document object model, rather than translation with xls > (which the knowledgebase article deals with). > > Side note: I've been playing with IBM's java-based xerces processor from > and have been having some good results. > > David > > > -Original Message- > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 23, 2000 11:09 AM > > To: [EMAIL PROTECTED] > > Subject: Re: XML Question > > > > > > David, > > The "Tech Note" you are refering to " > > www.allaire.com/handlers/index.cfm?ID=14244&Method=Full#1020244 " > > does not > > work. I have an open incident with Allaire, wherein they are trying to > > figure out why. Evidently after they fix the problem they are going to > > update the knowledge base article. > > - Original Message - > > From: "David Gassner" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 23, 2000 7:29 AM > > Subject: RE: XML Question > > > > > > > Bob, I wrote an article on using the MS XMLDOM COM object with > > CF to parse > > > conventional XML files; it's at: > > > > > > http://www.sys-con.com/xml/archives/0102/gassner/index.html > > > > > > Take a look and email me off-list if you need any clarification. > > > > > > David > > > > > > > -Original Message- > > > > From: Robert Everland III [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, May 22, 2000 7:22 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: XML Question > > > > > > > > > > > > Ok I get the gist on how to use WDDX, but how would I read in an XML > > > > document? Same prinipal, 3rd party utility? > > > > > > > > > > > > Bob Everland > > > > > > > > -- > > > > > > > > Archives: http://www.eGroups.com/list/cf-talk > > > > To Unsubscribe visit > > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > > > _talk or send a message to [EMAIL PROTECTED] with > > > 'unsubscribe' in the body. > > > > > > > > -- > > > > > Archives: http://www.eGroups.com/list/cf-talk > > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > > > > -- > > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: XML Question
Sean, I got Allaire's example working. I found these problems based on the version I copied from the Allaire website: 1. If you copy the example XSL file from the website, the tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl processor to fail completely. Instead of doing the transformation, it was just outputting the content of the original xsl file. The namespace needs to be in a continuous line, as follows: http://www.w3.org/1999/XSL/Transform"> 2. The printWriter class wasn't being closed, so the file containing the wddx was never being flushed to disk. I added the following to the end of the code: 3. The resulting processed file wasn't being read into a CF variable, so I added: 4. Next, when I tried to run to transform the wddx to a structure, I got: Error Diagnostic Information unknown exception condition TagCFWddx::execute There was an error in the XSL file: the "item" element was being mapped to a named structure; since it was a structure within an array, it couldn't take a name, causing the WDDX parser to fail. I corrected the XSL file, and everything now works. Here's my corrected XSL file: http://www.w3.org/1999/XSL/Transform"> I'll pass this info to the folks at Allaire. --David > -Original Message- > From: Sean Renet [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 23, 2000 5:53 PM > To: [EMAIL PROTECTED] > Subject: Re: XML Question > > > yes, you would think someone would have tested the knowledge base article. > I though it necessary to point this out as you directed someone that asked > how to parse an XML file into CFML to your article which > references this doc > as the means to do such. > - Original Message - > From: "David Gassner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 23, 2000 11:27 AM > Subject: RE: XML Question > > > > Interesting; I never actually tested Allaire's approach, but > included the > > reference in my article for the sake of completeness. My > article focuses > on > > parsing xml file's document object model, rather than > translation with xls > > (which the knowledgebase article deals with). > > > > Side note: I've been playing with IBM's java-based xerces processor from > > and have been having some good results. > > > > David > > > > > -Original Message- > > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, May 23, 2000 11:09 AM > > > To: [EMAIL PROTECTED] > > > Subject: Re: XML Question > > > > > > > > > David, > > > The "Tech Note" you are refering to " > > > www.allaire.com/handlers/index.cfm?ID=14244&Method=Full#1020244 " > > > does not > > > work. I have an open incident with Allaire, wherein they are > trying to > > > figure out why. Evidently after they fix the problem they > are going to > > > update the knowledge base article. > > > - Original Message - > > > From: "David Gassner" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 23, 2000 7:29 AM > > > Subject: RE: XML Question > > > > > > > > > > Bob, I wrote an article on using the MS XMLDOM COM object with > > > CF to parse > > > > conventional XML files; it's at: > > > > > > > > http://www.sys-con.com/xml/archives/0102/gassner/index.html > > > > > > > > Take a look and email me off-list if you need any clarification. > > > > > > > > David > > > > > > > > > -Original Message- > > > > > From: Robert Everland III [mailto:[EMAIL PROTECTED]] > > > > > Sent: Monday, May 22, 2000 7:22 PM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: XML Question > > > > > > > > > > > > > > > Ok I get the gist on how to use WDDX, but how would I > read in an XML > > > > > document? Same prinipal, 3rd party utility? > > > > > &g
Re: XML Question
Thanks David, I will give it a go. You the man. - Original Message - From: "David Gassner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 23, 2000 9:30 PM Subject: RE: XML Question > Sean, I got Allaire's example working. I found these problems based on the > version I copied from the Allaire website: > > 1. If you copy the example XSL file from the website, the > tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl > processor to fail completely. Instead of doing the transformation, it was > just outputting the content of the original xsl file. The namespace needs > to be in a continuous line, as follows: > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > > 2. The printWriter class wasn't being closed, so the file containing the > wddx was never being flushed to disk. I added the following to the end of > the code: > > > > 3. The resulting processed file wasn't being read into a CF variable, so I > added: > > file="[path]wddx_test.wddx" >variable="wddx"> > > 4. Next, when I tried to run to transform the wddx to a structure, > I got: > > Error Diagnostic Information > unknown exception condition > TagCFWddx::execute > > There was an error in the XSL file: the "item" element was being mapped to a > named structure; since it was a structure within an array, it couldn't take > a name, causing the WDDX parser to fail. I corrected the XSL file, and > everything now works. Here's my corrected XSL file: > > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > match="firstName|lastName|street|city|state|zip|country|voice|fax|email| > description|currency"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I'll pass this info to the folks at Allaire. > --David > > > -Original Message- > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 23, 2000 5:53 PM > > To: [EMAIL PROTECTED] > > Subject: Re: XML Question > > > > > > yes, you would think someone would have tested the knowledge base article. > > I though it necessary to point this out as you directed someone that asked > > how to parse an XML file into CFML to your article which > > references this doc > > as the means to do such. > > - Original Message - > > From: "David Gassner" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, May 23, 2000 11:27 AM > > Subject: RE: XML Question > > > > > > > Interesting; I never actually tested Allaire's approach, but > > included the > > > reference in my article for the sake of completeness. My > > article focuses > > on > > > parsing xml file's document object model, rather than > > translation with xls > > > (which the knowledgebase article deals with). > > > > > > Side note: I've been playing with IBM's java-based xerces processor from > > > and have been having some good results. > > > > > > David > > > > > > > -----Original Message- > > > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, May 23, 2000 11:09 AM > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: XML Question > > > > > > > > > > > > David, > > > > The "Tech Note" you are refering to " > > > > www.allaire.com/handlers/index.cfm?ID=14244&Method=Full#1020244 " > > > > does not > > > > work. I have an open incident with Allaire, wherein they are > > trying to > > > > figure out why. Evidently after they fix the problem they > > are going to > > > > update the knowledge base article. > > > > - Original Message
Re: XML Question
How would you handle the XML tag attributes using XSL? ie: 12.2 I FINALLY got allaire's example to work (thanks David), but I don't even know where to start when it comes to the attributes. Any suggestions? (If it helps, I'm trying to convert cXML to WDDX) Thanks in advance, Brian Kohnen At 01:21 AM 5/24/00 -0700, you wrote: >Thanks David, I will give it a go. You the man. >- Original Message - >From: "David Gassner" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, May 23, 2000 9:30 PM >Subject: RE: XML Question > > > > Sean, I got Allaire's example working. I found these problems based on >the > > version I copied from the Allaire website: > > > > 1. If you copy the example XSL file from the website, the > > > tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl > > processor to fail completely. Instead of doing the transformation, it was > > just outputting the content of the original xsl file. The namespace needs > > to be in a continuous line, as follows: > > > > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > > > > 2. The printWriter class wasn't being closed, so the file containing the > > wddx was never being flushed to disk. I added the following to the end of > > the code: > > > > > > > > 3. The resulting processed file wasn't being read into a CF variable, so >I > > added: > > > > >file="[path]wddx_test.wddx" > >variable="wddx"> > > > > 4. Next, when I tried to run to transform the wddx to a >structure, > > I got: > > > > Error Diagnostic Information > > unknown exception condition > > TagCFWddx::execute > > > > There was an error in the XSL file: the "item" element was being mapped to >a > > named structure; since it was a structure within an array, it couldn't >take > > a name, causing the WDDX parser to fail. I corrected the XSL file, and > > everything now works. Here's my corrected XSL file: > > > > > > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > match="firstName|lastName|street|city|state|zip|country|voice|fax|email| > > description|currency"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I'll pass this info to the folks at Allaire. > > --David > > > > > -Original Message- > > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, May 23, 2000 5:53 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: XML Question > > > > > > > > > yes, you would think someone would have tested the knowledge base >article. > > > I though it necessary to point this out as you directed someone that >asked > > > how to parse an XML file into CFML to your article which > > > references this doc > > > as the means to do such. > > > - Original Message - > > > From: "David Gassner" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 23, 2000 11:27 AM > > > Subject: RE: XML Question > > > > > > > > > > Interesting; I never actually tested Allaire's approach, but > > > included the > > > > reference in my article for the sake of completeness. My > > > article focuses > > > on > > > > parsing xml file's document object model, rather than > > > translation with xls > > > > (which the knowledgebase ar
RE: XML Question
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFCA95.BF5DC120 Content-Type: text/plain; charset="iso-8859-1" do a search at microsfot.com for beginning XSL. they have a pretty simple example on how to use XSL. Shawn Regan --_=_NextPart_001_01BFCA95.BF5DC120 Content-Type: text/html; charset="iso-8859-1" RE: XML Question do a search at microsfot.com for beginning XSL. they have a pretty simple example on how to use XSL. Shawn Regan --_=_NextPart_001_01BFCA95.BF5DC120-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: XML question
Might be stating the obvious, but have you used cfdump to do a visual check of your struct outhere ? > -Original Message- > From: Andres [mailto:[EMAIL PROTECTED]] > Sent: Friday, 1 March 2002 12:50 pm > To: CF-Talk > Subject: XML question > > > This a rather long email... > > i am trying to query the USPS international rate calculator via their > API. Their response is an XML document which i am parsing via SOXML. > This is a great tool! > > an example of the xml that i receive from USPS is as > follows..== > > > > Currency of the Albanian State > Bank (Banknotes in lek). > Extravagant clothes and other articles contrary to Albanians' taste. > Items sent by political emigres. > Hunting arms require an import > permit. Medicines for > personal use are admitted provided the addressee has a medical > certificate. > 1. Letter packages may not > contain dutiable articles. 2. > Parcel post service extends only to: Berat Konispol Milot > Bilisht Korce > Peqin > Postal Union Mail (LC/AO): PS > Form 2976 or 2976-A (see > 123.61) Parcel Post: PS Form 2976-A inside 2976-E > (envelope) > Country Code AL Reciprocal Service > Name EMS Required > Customs Form/Endorsement 1. For correspondence and business > papers: PS > Form 2976, Customs - CN 22 (Old C 1) and Sender's Declaration (green > label). Endorse item clearly next to mailing label as BUSINESS > PAPERS. > Tirana. > > 2 > 0 > Package > ALBANIA > 87 > See Service > Guide > Global Express > Guaranteed (GXG) Document > Service > Max. length 46", depth > 35", height 46" and max. girth > 108" > 22 > > > 2 > 0 > Package > ALBANIA > 96 > See Service > Guide > Global Express > Guaranteed (GXG) Non-Document > Service > Max. length 46", depth > 35", height 46" and max. girth > 108" > 22 > > > == > > I am very new using XML, but the way soxml parses it is by using > cfscript and looping thorugh the array for each main object > in the xml > doc. > > Following the xml2cf section, i basically loop through the array of > objects in the xml doc as follows: > == > >to="#ArrayLen(outhere.IntlRateResponse.Package)#"> > > sProhivitions = > outhere.IntlRateResponse.Package[package_pointer].Prohibitions.value; > sRestrictions = > utoutherehere.IntlRateResponse.Package[package_pointer].Restri > ctions.valu > e; > sObservations = > outhere.IntlRateResponse.Package[package_pointer].Observations.value; > sCustomsForms = > uthouthereere.IntlRateResponse.Package[package_pointer].Custom > sForms.valu > e; > sExpressMail = > outhere.IntlRateResponse.Package[package_pointer].ExpressMail.value; > sAreasServed = > outhere.IntlRateResponse.Package[package_pointer].AreasServed.value; > > > > sProhivitions = > outhere.IntlRateResponse.Package[package_pointer].Prohibitions.value; > sRestrictions = > utoutherehere.IntlRateResponse.Package[package_pointer].Restri > ctions.valu > e; > sObservations = > outhere.IntlRateResponse.Package[package_pointer].Observations.value; > sCustomsForms = > uthouthereere.IntlRateResponse.Package[package_pointer].Custom > sForms.valu > e; > sExpressMail = > outhere.IntlRateResponse.Package[package_pointer].ExpressMail.value; > sAreasServed = > outhere.IntlRateResponse.Package[package_pointer].AreasServed.value; > > == > > > This, so far, works fine. However, the problem i enconter is > when i try > to utilize the second object: "Service". Whe i run the > following code, > > > >to="#ArrayLen(outhere.IntlRateResponse.Service)#"> > > //Lets grab the nodes of the information we want to display > sPounds = > outhere.IntlRateResponse.Service[service_pointer].Prohibitions.value; > sOunces = > utoutherehere.IntlRateResponse.Service[service_pointer].Restri > ctions.valu > e; > sMailType = > outhere.IntlRateResponse.Service[service_pointer].Observations.value; > sCountry = > uthouthereere.IntlRateResponse.Service[service_pointer].Custom > sForms.valu > e; > sPostage = > outhere.IntlRateResponse.Service[service_pointer].ExpressMail.value; > sSvcCommitmen
Re: XML question
I'd bet that it's same the problem I ran into when using MSXML via cfobject to grab the UPS XML, which is essentially what soxml does. CFObject apparently doesn't understand the nulls that MSXML passes back when an XML element is empty, and bombs. If you are running an older version of msxml you may want to upgrade it as 4.0 is out, that may fix some problems, as 4.0 is the first solid release imo. Have you tried the cf_usps tag? It handles pretty much everything for you. http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5-83F300508B94F85A&method=Full If you want to do it via soxml here is a real simple custom tag sample that I did that just returns the country information that usps passes back. Expanding upon this to do full rates would be pretty easy, but that's what the above tag goes anyway... services = 'PACKAGE'; APIstr = 'IntlRate'; XMLstr = ''; XMLstr = XMLstr & ' 0 1 Package #Attributes.country# '; XMLstr = XMLstr & ''; jon ps For anyone who cares, FEDEX is finally planning on releasing an XML API withing the next two months. It's already been delayed once from Q4 2001 though, so I'm not getting my hopes up though. Andres wrote: > This a rather long email... > > i am trying to query the USPS international rate calculator via their > API. Their response is an XML document which i am parsing via SOXML. > This is a great tool! > > > CF throws an error saying that it cannot resolve the parameter > outhere.IntlRateResponse.Service. Even though this does exist and indeed > is to be an array since there are two of them. > > Any help would be much appreciated! > > Thank you > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML question
Jon, Thank you for your help on this. Do you know if msxml will somehow affect CF's wddx implementation? i dont know if the two relate to each other... but i am using wddx to export some data to other systems, and dont want to interfere with those elements. Thanks! Andres -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thu 2/28/2002 8:45 PM To: CF-Talk Cc: Subject: Re: XML question I'd bet that it's same the problem I ran into when using MSXML via cfobject to grab the UPS XML, which is essentially what soxml does. CFObject apparently doesn't understand the nulls that MSXML passes back when an XML element is empty, and bombs. If you are running an older version of msxml you may want to upgrade it as 4.0 is out, that may fix some problems, as 4.0 is the first solid release imo. Have you tried the cf_usps tag? It handles pretty much everything for you. http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5-83F300508B94F85A&method=Full If you want to do it via soxml here is a real simple custom tag sample that I did that just returns the country information that usps passes back. Expanding upon this to do full rates would be pretty easy, but that's what the above tag goes anyway... services = 'PACKAGE'; APIstr = 'IntlRate'; XMLstr = ''; XMLstr = XMLstr & ' 0 1 Package #Attributes.country# '; XMLstr = XMLstr & ''; jon ps For anyone who cares, FEDEX is finally planning on releasing an XML API withing the next two months. It's already been delayed once from Q4 2001 though, so I'm not getting my hopes up though. Andres wrote: > This a rather long email... > > i am trying to query the USPS international rate calculator via their > API. Their response is an XML document which i am parsing via SOXML. > This is a great tool! > > > CF throws an error saying that it cannot resolve the parameter > outhere.IntlRateResponse.Service. Even though this does exist and indeed > is to be an array since there are two of them. > > Any help would be much appreciated! > > Thank you > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML question
Andres, Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX functionality is built into CF and there are defined tags for using it. HTH. Rey... - Original Message - From: "Andres" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 11:34 PM Subject: RE: XML question > Jon, > Thank you for your help on this. > > Do you know if msxml will somehow affect CF's wddx implementation? i dont know if the two relate to each other... but i am using wddx to export some data to other systems, and dont want to interfere with those elements. > > Thanks! > > Andres > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Thu 2/28/2002 8:45 PM > To: CF-Talk > Cc: > Subject: Re: XML question > > > > I'd bet that it's same the problem I ran into when using MSXML via > cfobject to grab the UPS XML, which is essentially what soxml does. > CFObject apparently doesn't understand the nulls that MSXML passes back > when an XML element is empty, and bombs. If you are running an older > version of msxml you may want to upgrade it as 4.0 is out, that may fix > some problems, as 4.0 is the first solid release imo. > > Have you tried the cf_usps tag? It handles pretty much everything for you. > http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5 -83F300508B94F85A&method=Full > > If you want to do it via soxml here is a real simple custom tag sample > that I did that just returns the country information that usps passes > back. Expanding upon this to do full rates would be pretty easy, but > that's what the above tag goes anyway... > > > > > > > services = 'PACKAGE'; > APIstr = 'IntlRate'; > XMLstr = ' PASSWORD="#attributes.password#">'; > > XMLstr = XMLstr & ' > 0 > 1 > Package > #Attributes.country# > '; > XMLstr = XMLstr & ''; > > > > URL="#attributes.server#?API=#APIstr#&XML=#urlencodedformat(XMLstr)#" > method="GET" resolveurl="false" timeout="45"> > > > action="XML2CF" >input="#xmlResp#" >output="countryData" >type="Variables" > > > > > > jon > > ps For anyone who cares, FEDEX is finally planning on releasing an XML > API withing the next two months. It's already been delayed once from Q4 > 2001 though, so I'm not getting my hopes up though. > > Andres wrote: > > This a rather long email... > > > > i am trying to query the USPS international rate calculator via their > > API. Their response is an XML document which i am parsing via SOXML. > > This is a great tool! > > > > > > > CF throws an error saying that it cannot resolve the parameter > > outhere.IntlRateResponse.Service. Even though this does exist and indeed > > is to be an array since there are two of them. > > > > Any help would be much appreciated! > > > > Thank you > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML question
wddx is just another form of an xml document. you can reference the dtd for wddx here: http://www.wddx.org i am not sure of your question though, they are two different sets of technologies that have XML in common. cheers, Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:40 PM To: CF-Talk Subject: Re: XML question Andres, Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX functionality is built into CF and there are defined tags for using it. HTH. Rey... - Original Message - From: "Andres" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 11:34 PM Subject: RE: XML question > Jon, > Thank you for your help on this. > > Do you know if msxml will somehow affect CF's wddx implementation? i dont know if the two relate to each other... but i am using wddx to export some data to other systems, and dont want to interfere with those elements. > > Thanks! > > Andres > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Thu 2/28/2002 8:45 PM > To: CF-Talk > Cc: > Subject: Re: XML question > > > > I'd bet that it's same the problem I ran into when using MSXML via > cfobject to grab the UPS XML, which is essentially what soxml does. > CFObject apparently doesn't understand the nulls that MSXML passes back > when an XML element is empty, and bombs. If you are running an older > version of msxml you may want to upgrade it as 4.0 is out, that may fix > some problems, as 4.0 is the first solid release imo. > > Have you tried the cf_usps tag? It handles pretty much everything for you. > http://devex.macromedia.com/developer/gallery/info.cfm?ID=9C9C2AB9-7F93-11D5 -83F300508B94F85A&method=Full > > If you want to do it via soxml here is a real simple custom tag sample > that I did that just returns the country information that usps passes > back. Expanding upon this to do full rates would be pretty easy, but > that's what the above tag goes anyway... > > > > > > > services = 'PACKAGE'; > APIstr = 'IntlRate'; > XMLstr = ' PASSWORD="#attributes.password#">'; > > XMLstr = XMLstr & ' > 0 > 1 > Package > #Attributes.country# > '; > XMLstr = XMLstr & ''; > > > > URL="#attributes.server#?API=#APIstr#&XML=#urlencodedformat(XMLstr)#" > method="GET" resolveurl="false" timeout="45"> > > > action="XML2CF" >input="#xmlResp#" >output="countryData" >type="Variables" > > > > > > jon > > ps For anyone who cares, FEDEX is finally planning on releasing an XML > API withing the next two months. It's already been delayed once from Q4 > 2001 though, so I'm not getting my hopes up though. > > Andres wrote: > > This a rather long email... > > > > i am trying to query the USPS international rate calculator via their > > API. Their response is an XML document which i am parsing via SOXML. > > This is a great tool! > > > > > > > CF throws an error saying that it cannot resolve the parameter > > outhere.IntlRateResponse.Service. Even though this does exist and indeed > > is to be an array since there are two of them. > > > > Any help would be much appreciated! > > > > Thank you > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML question
I have a funny feeling Rey knows all about wddx already ;-) It's openwddx.org now though. jon - Original Message - From: "Tim Stadinski" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 6:46 PM Subject: RE: XML question > wddx is just another form of an xml document. you can reference the dtd for > wddx here: http://www.wddx.org > > i am not sure of your question though, they are two different sets of > technologies that have XML in common. > > cheers, > Timothy Stadinski > Senior Software Engineer > Afternic.com > [EMAIL PROTECTED] > > > > -Original Message- > From: Rey Bango [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 28, 2002 11:40 PM > To: CF-Talk > Subject: Re: XML question > > > Andres, > > Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component > is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX > functionality is built into CF and there are defined tags for using it. > > HTH. > > Rey... > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML question
Does anyone know of a online source with some examples of accessing WDDX packets from within a VB application? I know Forta's book has one example of this and the SDK for WDDX has a little bit, but that is about all I have been able to find. Like how it is www.openwddx.org now but the SDK points to www.wddx.org still, sure does instill confidence in me. ;) Snipe - - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 6:32 PM Subject: Re: XML question > I have a funny feeling Rey knows all about wddx already ;-) > It's openwddx.org now though. > > jon > - Original Message - > From: "Tim Stadinski" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, March 01, 2002 6:46 PM > Subject: RE: XML question > > > > wddx is just another form of an xml document. you can reference the dtd > for > > wddx here: http://www.wddx.org > > > > i am not sure of your question though, they are two different sets of > > technologies that have XML in common. > > > > cheers, > > Timothy Stadinski > > Senior Software Engineer > > Afternic.com > > [EMAIL PROTECTED] > > > > > > > > -Original Message- > > From: Rey Bango [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 28, 2002 11:40 PM > > To: CF-Talk > > Subject: Re: XML question > > > > > > Andres, > > > > Microsoft's XMLDOM component won't interfere w/ WDDX. The XMLDOM component > > is a COM object which needs to be invoked using the CFOBJECT tag. The WDDX > > functionality is built into CF and there are defined tags for using it. > > > > HTH. > > > > Rey... > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML Question
> What am I missing when trying to > access the pattern node? cfdump. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML Question
This works just fine for me and returns 1. returntype="numeric"> file="C:\inetpub\wwwroot\temp\ev.xml" variable="event"> ArrayLen(variables.calEvents.events.event.XmlChildren) /> #readXml()# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML Question
The best advice I can give, hopefully you are on MX, is . When I was learning to parse an XML file, I just used starting at the root, working down until I got to the right piece. I'm not sure, but for some reason, I just could never get it right if I just tried to jump right to the node, I always missed some piece of the syntax. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML Question
Do an xml search for the attribute with XPath.. xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); Or Iterate through the node to find "id=2" Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 10, 2003 8:15 PM > To: CF-Talk > Subject: XML Question > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > where 2 falls in the xml object. All I know is I want to insert a child > under the page with ID "2". > > Any ideas? > > Thanks, > > Brad > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: XML Question
Let me re-ask my question... What's the best way to insert a child element under , when you don't know where it's at in the XML doc? All you know is that it has an attribute "id" and the value is "2". Another thought (along the same lines), if you wanted to show the ancestors of a specific element, how would this be accomplished? An example would be displaying "breadcrumbs". Again, all you would know is the page id. Would this require a recursive udf/tag? And if so, how do you get the parent element of a given element. I can't find this anywhere in the docs (or web). Get the children of an element, easy... get the parent of an element, I have no clue... Thanks, Brad -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:28 AM To: CF-Talk Subject: RE: XML Question Do an xml search for the attribute with XPath.. xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); Or Iterate through the node to find "id=2" Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 10, 2003 8:15 PM > To: CF-Talk > Subject: XML Question > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > where 2 falls in the xml object. All I know is I want to insert a child > under the page with ID "2". > > Any ideas? > > Thanks, > > Brad > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: XML Question
> Get the children of an element, easy... get the parent of an > element, I have > no clue... CFMX allows basic xml parsing in the simplest form(i.e array and structs) If you are trying to accomlish XML Parsing in the Popular or Best ways.. I suggest you use XML DOM Parsing with Java. You have alot functions like getParentNode(), getChildNode etc to accomplish tasks easier.. Here is some documentation on XML Node http://java.sun.com/j2se/1.4.1/docs/api/org/w3c/dom/Node.html Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:29 AM > To: CF-Talk > Subject: RE: XML Question > > > Let me re-ask my question... > > What's the best way to insert a child element under id="2">, when you > don't know where it's at in the XML doc? All you know is that it has an > attribute "id" and the value is "2". > > Another thought (along the same lines), if you wanted to show the > ancestors > of a specific element, how would this be accomplished? An > example would be > displaying "breadcrumbs". Again, all you would know is the page > id. Would > this require a recursive udf/tag? And if so, how do you get the parent > element of a given element. I can't find this anywhere in the docs (or > web). > > Get the children of an element, easy... get the parent of an > element, I have > no clue... > > Thanks, > > Brad > > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:28 AM > To: CF-Talk > Subject: RE: XML Question > > > Do an xml search for the attribute with XPath.. > xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); > > Or Iterate through the node to find "id=2" > > Joe Eugene > > > > -Original Message- > > From: Brad Roberts [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 10, 2003 8:15 PM > > To: CF-Talk > > Subject: XML Question > > > > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > > where 2 falls in the xml object. All I know is I want to insert a child > > under the page with ID "2". > > > > Any ideas? > > > > Thanks, > > > > Brad > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: XML Question
Cool! I'd love to be able to take advantage of these methods, but I don't know squat about Java. So, how do you call these methods from within CF? Any examples you can point me to? -Brad -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:02 AM To: CF-Talk Subject: RE: XML Question > Get the children of an element, easy... get the parent of an > element, I have > no clue... CFMX allows basic xml parsing in the simplest form(i.e array and structs) If you are trying to accomlish XML Parsing in the Popular or Best ways.. I suggest you use XML DOM Parsing with Java. You have alot functions like getParentNode(), getChildNode etc to accomplish tasks easier.. Here is some documentation on XML Node http://java.sun.com/j2se/1.4.1/docs/api/org/w3c/dom/Node.html Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:29 AM > To: CF-Talk > Subject: RE: XML Question > > > Let me re-ask my question... > > What's the best way to insert a child element under id="2">, when you > don't know where it's at in the XML doc? All you know is that it has an > attribute "id" and the value is "2". > > Another thought (along the same lines), if you wanted to show the > ancestors > of a specific element, how would this be accomplished? An > example would be > displaying "breadcrumbs". Again, all you would know is the page > id. Would > this require a recursive udf/tag? And if so, how do you get the parent > element of a given element. I can't find this anywhere in the docs (or > web). > > Get the children of an element, easy... get the parent of an > element, I have > no clue... > > Thanks, > > Brad > > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:28 AM > To: CF-Talk > Subject: RE: XML Question > > > Do an xml search for the attribute with XPath.. > xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); > > Or Iterate through the node to find "id=2" > > Joe Eugene > > > > -Original Message- > > From: Brad Roberts [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 10, 2003 8:15 PM > > To: CF-Talk > > Subject: XML Question > > > > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > > where 2 falls in the xml object. All I know is I want to insert a child > > under the page with ID "2". > > > > Any ideas? > > > > Thanks, > > > > Brad > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: XML Question
> Cool! I'd love to be able to take advantage of these methods, but I don't > know squat about Java. > > So, how do you call these methods from within CF? Any examples you can > point me to? Well, in order to turn an XML string into a DOM object you could use this: http://www.cfmentor.com/code/index.cfm?action=script&id=127 Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: XML Question
Have you looked into using XMLSearch function? On Mon, 31 Jan 2005 10:38:16 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote: > Hello, > I'm new to using XML parsing in coldfusion so I hope I'm phrasing this > question properly. I was wondering if it's possible to query a xml doc > and return all of the attribute names (Name, Address, City). I have a > long list of them and I would like to make my form as dynamic as > possible. > > Thanks, > - Charles > > >Charles >123 Main St. >Livermore > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML Question
Well to start with, in your code example, name, address and city are child notes, not attributes. Charles 123 Main St. Livermore If your document was formatted like this, they would be attributes. So for the former; name, address and city are part of the XMLchildren's array. #xmlVAR.service.XMLchildren[i].xmlName# = #xmlVAR.service.XMLchildren[i].xmlText# #i# = #xmlVAR.SERVICE.XmlAttributes[i]# HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-Original Message- ...From: Charles Heizer [mailto:[EMAIL PROTECTED] ...Sent: Monday, January 31, 2005 10:38 AM ...To: CF-Talk ...Subject: XML Question ... ...Hello, ...I'm new to using XML parsing in coldfusion so I hope I'm phrasing this ...question properly. I was wondering if it's possible to query a xml doc ...and return all of the attribute names (Name, Address, City). I have a ...long list of them and I would like to make my form as dynamic as ...possible. ... ...Thanks, ...- Charles ... ... ... Charles ... 123 Main St. ... Livermore ... ... ... ... ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML Question
Thanks, This works great! - Charles On Jan 31, 2005, at 11:05 AM, Ian Skinner wrote: > > #xmlVAR.service.XMLchildren[i].xmlName# = > #xmlVAR.service.XMLchildren[i].xmlText# > http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54