XML / XSL

thanks, I actually got there in the end, I did try w3schools first actually but they didn't have an example that fit how I wanted.

#import generated ATL code throws _com_error exceptions When all else fails, consult the documentation[^] led mike

Sorry, Just looking for help I am new. Learning to Code

Thanks a bunch. It did the trick it seems. :)

don't worry folks, i fixed by myself. just have to put tags like this: exec spCreateTimeCardSession @TimeCardID, '

Yes, you are clever.I used it.The link given is very useful to me. Thanks a lot.

Both your allNodes object and the ChildNodes property of allNodes is a XMLNodeList. Thus, both allNodes and ChildNodes have a Count property that you can check to verify if GetElementByTagName returned any nodes or if ChildNodes contains any nodes. "We make a living by what we get, we make a life by what we give." --Winston Churchill

Do you know what a Root Element is? "We make a living by what we get, we make a life by what we give." --Winston Churchill

izzy87 wrote: but I don't know how to setup two primary nodes. That does not explain your problem. Maybe you should try again, and remember, we cannot read your mind. led mike

Sorry For not mentioned the Macors Sub sameoldcalvin() ' ' Macro3 Macro ' Dim i As Long Dim SearchRange As Range Dim FindRow As Range Dim pp As String Range("G1").Select Start: Do ' Whole process loop counter = do it 9000 times i = i + 1 ActiveCell.Offset(1, 0).Range("A1").Select pp = ActiveCell.Value Set SearchRange = Range("G:G") Set FindRow = SearchRange.Find(pp, LookIn:=xlValues, lookat:=xlWhole) If FindRow.Row = ActiveCell.Row Then GoTo Start Else Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select ActiveCell.Offset(0, 4).Range("A1:B1").Select Selection.Cut ActiveCell.Offset(-1, 0).Range("A1").Select Selection.End(xlToRight).Select ActiveCell.Offset(0, 1).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, -2).Range("A1").Select 'delete ActiveCell.Rows("1:1").EntireRow.Select ActiveCell.Activate Selection.Delete Shift:=xlUp ActiveCell.Offset(-1, 3).Range("A1").Select End If Loop Until i = 9000 End Sub

Great, thanks for the reply! I'll take a look at the link. Regards, mav -- Black holes are the places where God divided by 0...

ok, cool, i just realise this, thanks to mention that to me.

Try this - check the comment written by Mark[^] Erik Westermann - wWorkflow.net - BizTalk Consulting Services SOA * ESB * BPI * SaaS ... forget the alphabet soup - get the main course with our consulting services! wWorkflow.net or +1 416-809-1453

Hello, OK I have worked out the below code to return the 'EN' string if I supply the string code, say "1000". What I need to know is understand how to search for the string and return the string code. If I would use a wildcard in this it would be great. Any Thoughts??? Private Sub XPathSearch(ByVal XMLPath As String) Dim xmlNI As XPathNodeIterator Dim xpathDoc As XPathDocument Dim xmlNav As XPathNavigator Try xpathDoc = New XPathDocument(XMLPath) xmlNav = xpathDoc.CreateNavigator() xmlNI = xmlNav.Select("/MOMLANG/STRING[@code='" & stringValue & "']/LANG[@code='EN']") While (xmlNI.MoveNext()) 'Me.RichTextBox1.AppendText(xmlNI.Current.Name + " : " + xmlNI.Current.Value & vbCrLf) Me.RichTextBox1.AppendText("String value: " + xmlNI.Current.Value & vbCrLf) End While Catch ex As XPathException System.Console.WriteLine("XMLException: " + ex.Message) Catch ex As Exception System.Console.WriteLine("Exception: " + ex.Message) End Try End Sub When people make you see red, be thankful your not colour blind.

From what I can see, you have a couple of problems: * Everything is in lower-case, so complextype is not the same as the (correct) complexType. (This also applies to complexcontent/complexContent, etc) * The complexType 'transactions' contains a sequence that contains a choice. You cannot limit a choice in this way. Here is the right way: So I removed the choice to get it to work. For reference, here is what the final schema looks like:

The schema location attribute in the root node is wrong, since you don't have a namespace in your instance. Here is an instance that works: Also make sure that your schema actually exists at the specified location and is valid. Here's some more information: http://msdn.microsoft.com/en-us/library/ms256139(VS.85).aspx Erik Westermann - wWorkflow.net - BizTalk Consulting Services SOA * ESB * BPI * SaaS ... forget the alphabet soup - get the main course with our consulting services! wWorkflow.net or +1 416-809-1453

Just use entity references: < > and & It might be messy to go through an entire XML doc to convert values containing these special characters so, in the past, I used to just load the XML into a XML DOM object and then get it again - the DOM object does the conversion for you! (ignore the HTML tags in my sig - I turned off HTML so that the entity references show up) Erik Westermann - wWorkflow.net - BizTalk Consulting Services SOA * ESB * BPI * SaaS ... forget the alphabet soup - get the main course with our consulting services! wWorkflow.net or +1 416-809-1453

Well, in case anyone is interested, I solved my problem. Schema validation turned out to be too limited to handle all cases, so now I use schema validation combined with rules in the BizTalk Rules Engine (this was part of a larger BizTalk-based solution). So, schema validation catches more obvious, structural issues whereas the Business Rules make it easier to validate based on regular expressions, etc. Erik Westermann - wWorkflow.net - BizTalk Consulting Services SOA * ESB * BPI * SaaS ... forget the alphabet soup - get the main course with our consulting services! wWorkflow.net or +1 416-809-1453

led mike wrote: you now have two posts and ZERO questions. :laugh: