XMl caching data/ Recordet Save

webmasterbeta

New Member
Hello List!I am using the following methods to get my xml to the client:strSQL = "SELECT DATA FROM TABLE"set oRs = Server.CreateObject("ADODB.Recordset")oRs.CursorLocation = 3oRs.Open strSQL, oConnoRs.Save Response, adPersistXMLand the following methods to load it:set XMLDocPlan = CreateObject("microsoft.xmldom")' Not an Asynchronous OperationXMLDocPlan.async=false' Load Data from ServerXMLDocPlan.load "test_chart_plan.asp"everything appears to work fine initially I can traverse the rs:data andget my client side control loaded with the data, but the XML returned aftera couple reloads starts to return duplicate records, and multiple sets whenthere should only be one (verified via the database). I have expired thecalled data generator and used the usual 'cache no more' tricks. Is theresomething in XML specifically to ensure this weird behavior stops? Thanksin advance.Andy <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
 
Back
Top