On Friday, Oct 18, 2002, at 18:03 US/Pacific, Brook wrote: > Interesting, well maybe I can use a combination of the two. Store the > XML > data and then when needed parse section of it into arrays or what not > and > then work with the resulting objects in CF. And then save it back into > the > XML document? Insert it back in I guess? I need to brush up on the > CFMX XML > features and their limitations.
You don't say which database you are thinking of... If you're looking at Oracle 9iR2, they have some really sweet SQL/XML stuff in there. You can mix relational and XML data and mix your queries too. I blogged this: http://www.corfield.org/blog/2002_10_01_archive.html#82676535 A lot would depend on what usage you really have inside the app. If the document doesn't change much, you could load it, parse it and cache the DOM representation in a shared scope. From the DOM it's easy to reconstruct structs and arrays. If your app changes the document frequently, you might need to take another approach. As always, so many options... "I can smell your brains!" -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
