Subject:SQL/XML Syntax within DB to XML Author:Jim Byrne Date:03 Dec 2004 10:35 AM
I have a copy of Jonathan Robie's SQL/XML, XQuery, and Native XML Programming Languages but when trying to use specific elements, they simply do not exist or the fire errors within DB to XML's SQL/XML editor. For instance XMLRoot(), XMLForest, XMLComment I cannot get to execute. I can run subqueries so I'm thinking the tool is powerful enough, I'm just missing something. Any examples, assistance would be most appreciated.
Here's the result:
<COMMENT>
<NoteComment1>01:57 PM (jbyrne)
JIM: Ms. Smith called back to say that Steve is better, he has less trouble, but still has a problems. They said that he could come here, but they were not given a directions. I explained the way here meant going through town and that I w</NoteComment1>
<NoteComment2>ould be happy to contact the authorities.</NoteComment2>
</COMMENT>
If only I could get just the notes concatenated together under the <Comment> tag without the additional <NoteComment1> and <NoteComment2> tags all would be right in the world.
I am simply trying to concat two or more fields of 255 characters together to build a comment with possible 3000 characters. DirectData's Sequelserver ver5.4 apparently does not like memo fields comming out of MS Access.
Subject:SQL/XML Syntax within DB to XML Author:Jim Byrne Date:03 Dec 2004 02:30 PM
Ivan,
That did it! Thanks much!
Do you happen to have a resource of choice for the syntax of SQL/XML of the "strict" variety suitalbe for use within Stylus Studio?
Thanks also for the quick responses. I think the application to this project is going to synch my purchase of SS6 but we would have been doing a find/replace and searching for another tool if not for the prompt replies. Me and my clients certainly appreciate it.