Parse only unique values from an XML response using XMLDOM...???
Posted on 2006-10-23
I'm parsing an XML response like so:
'open the XML document
Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")
xmlDoc.Async = false
'parse data from response
Set RecordsNode = xmlDoc.selectNodes("/fmresultset/resultset/record")
For Each recordNode In RecordsNode
EmailAddress = TryNode(recordNode, "field[@name='Leads_Clients::Email_Address']/data")
Response.Write(EmailAddress & "<br>")
Set RecordsNode = Nothing
It works great, however, many of the email addresses returned in this are for the same person. (the request grabs all emails for customers who have purchased a particular item from us, and many have purchased multiple similar items.)
I need to parse out only unique values, so basically I need the equivalent of a SQL SELECT DISTINCT.
Is there a way to do that from within XMLDOM? Any information would be greatly appreciated. thanks!