Prob in extracting a XML file from database
I have Three Fields in database(SQL SERVER)
PROD_NAME, Docment_Xml, Party_name
Am unable to take it out the Docment_Xml(This field containing a XML files) Field.
Am using below method
val=Recordset.fields("Docment_Xml").value -----> It is giving Empty value
Please Suggest me any solution..
Thanks in Advance.!!
I've run into limits in the ADODB.Connection object where it wouldn't return an XML field from a database if it was larger than 4000 bytes. I had to write a work-around that would convert it to a clob, find the size of the clob, pull 4000 bytes at a time, and then piece it back together. If your field is XML in the database and it's large, you might be hitting the same constraint.