[ACFUG Discuss] ACFUG meeting location is changing starting this week
Folks, I just want to make sure that those not on the Announcements list hear the news that the ACFUG meetings (starting this Wednesday) will be in a new location. John Mason and the folks at FusionLink have moved out of downtown to a facility near the Perimeter (and 400). In fact, it's the same building in which EchoEleven is located, for those who may know of that. See details on both the location and the meeting topics at http://www.acfug.org/index.cfm?fa=home.home And if you're not on the announcements list and wish you were, you can sign up at: http://www.acfug.org/index.cfm?fa=mailinglists.info /Charlie http://www.carehart.org/blog/ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - <>
[ACFUG Discuss] XML & CF
I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file-Read the length of the data from the XmlChildren array-Loop over the parsed XML to put things into a query-Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg(Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) -To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com-
RE: [ACFUG Discuss] XML & CF
If you have control over the xml format, I would suggest just using the wddx tags to save and call up query info in a xml format that wddx uses. John [EMAIL PROTECTED] _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, January 01, 2007 8:13 PM To: discussion@acfug.org Subject: [ACFUG Discuss] XML & CF I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file -Read the length of the data from the XmlChildren array -Loop over the parsed XML to put things into a query -Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg (Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - smime.p7s Description: S/MIME cryptographic signature
RE: [ACFUG Discuss] XML & CF
If you have control over the xml format, I would suggest just using the wddx tags to save and call up query info in a xml format that wddx uses. John [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]> _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, January 01, 2007 8:13 PM To: discussion@acfug.org Subject: [ACFUG Discuss] XML & CF I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file -Read the length of the data from the XmlChildren array -Loop over the parsed XML to put things into a query -Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg (Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] XML & CF
1. Read the XML file with CFFILE 2. Parse the xml string with xmlParse() --optional, but recommended-- narrow your XML document down to an array of of your data elements using xmlSearch() and the xPath to your data 3. loop over data and do what you will with it (conditionals to check, etc.) 4. write it back to the server or whatever storage space you are using (database, etc.) As far as writing back the whole XML doc, that may be a matter of not using xmlSearch() and working with the whole document instead. I'm not sure if xmlSearch() returns its array by reference or by value. Someone else may be able to clear this up. In the livedocs someone says that searches on the same XML doc are NOT thread-safe within a shared scope. This leads me to think that the array returned by xmlSearch() is returned is a reference to the original xml doc. If that is the case, then you can just manipulate that data in the array that xmlsearch() returns and then write the original xml back to a string with changes intact. I would not write it to an array of structs or a query if you're going to write back as XML to the server or database. Just manipulate the original XML doc and save the processing of conversion. To write it back to the server, you just toString(myXMLObj) within your CFFILE action="write" tag. On Jan 1, 2007, at 8:12 PM, [EMAIL PROTECTED] wrote: I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file -Read the length of the data from the XmlChildren array -Loop over the parsed XML to put things into a query -Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg (Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] XML & CF
Also, I would suggest Jeff Peters' book on the CF XML Object: http://www.cafepress.com/protonarts.50984013 ap On Jan 1, 2007, at 8:31 PM, Andrew Powell wrote: 1. Read the XML file with CFFILE 2. Parse the xml string with xmlParse() --optional, but recommended-- narrow your XML document down to an array of of your data elements using xmlSearch() and the xPath to your data 3. loop over data and do what you will with it (conditionals to check, etc.) 4. write it back to the server or whatever storage space you are using (database, etc.) As far as writing back the whole XML doc, that may be a matter of not using xmlSearch() and working with the whole document instead. I'm not sure if xmlSearch() returns its array by reference or by value. Someone else may be able to clear this up. In the livedocs someone says that searches on the same XML doc are NOT thread-safe within a shared scope. This leads me to think that the array returned by xmlSearch() is returned is a reference to the original xml doc. If that is the case, then you can just manipulate that data in the array that xmlsearch() returns and then write the original xml back to a string with changes intact. I would not write it to an array of structs or a query if you're going to write back as XML to the server or database. Just manipulate the original XML doc and save the processing of conversion. To write it back to the server, you just toString(myXMLObj) within your CFFILE action="write" tag. On Jan 1, 2007, at 8:12 PM, [EMAIL PROTECTED] wrote: I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file -Read the length of the data from the XmlChildren array -Loop over the parsed XML to put things into a query -Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg (Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -