TheVillageIdiot27
Programmer
I am fairly new to the concept of this so please be kind...
I am trying to get the contents of a response to a URL query to a SQL server database set up in a virtual directory into an XMLDOM object.
Feeling very pleased with myself having finally got the database and virtual directory to work with the URL FOR XML AUTO query to give me the disired response I then (rather wrongly) assumed that I could use the URL in the load method of the XMLDOM object.
Having read a bit on the web I understand that it doesn't work like that.
I assume there must be a way of doing this reasonably simply but I certainly can't work it out.
I am trying to get the contents of a response to a URL query to a SQL server database set up in a virtual directory into an XMLDOM object.
Feeling very pleased with myself having finally got the database and virtual directory to work with the URL FOR XML AUTO query to give me the disired response I then (rather wrongly) assumed that I could use the URL in the load method of the XMLDOM object.
Having read a bit on the web I understand that it doesn't work like that.
I assume there must be a way of doing this reasonably simply but I certainly can't work it out.