read to MSXML object from blob
Posted on 2009-03-30
This should be a simple process. Yet I've checked over 500 web sites in the last two hours and still have not seen one page that explains how this is done. I am querying a BLOB field from an Oracle Database that contains an XML file. I want to read the contents of the BLOB to the an XML object held in memory that will then be parsed using one of the MSXML objects. This must be done in classic ASP. It is obvious that you create a recordset that includes the blob field. The next steps are unclear. Can you read the rs field contents directly to one of the objects in the MSXML object model, if so which object using which method. Or is it necessary to read the rs field to an object that has been server created as ado stream object which the msxmml object will then load. Again what object and method would be used for this? I don't know why I can't find a reference to this object library (MSXML2) anywhere, with advice on what object to use in what circumstances. In the project I am updating I have seen used DOMDocument, ServerXMLHTTP, XMLHTTP and they all seem to do the same thing; store an XML document in memory.