I'm seeing a huge performance hit in our enterprise application when changing the XML schema collection of a given column on a large table. Simplistically put, we're doing something like this: ALTER TABLE HugeTable ALTER COLUMN CustomFields XML (note: CustomFields was previously bound to XML(CustomFieldsSchemaCollection, but of course...
XML date and time are in the format '-'? yyyy '-' mm '-' dd 'T' hh ':' mm ':' ss ('.' s+)? (zzzzzz)? were •'-'? yyyy is a four-or-more digit optionally negative-signed numeral that represents the year; if more than four digits, leading zeros are prohibited, and '0000' is prohibited •the remaining '-'s are separators between parts o...
I have the following XML structure: <row> <field name="Id">1</field> <field name="AreaId">1</field> <field name="Name">ת"א</field> </row> <row> <field name="Id">2</field> <field name="AreaId">4</field> <field name="Name">אבטליון</field> </row> I want to iterate over the name nodes with Linq. I tried this: var items =...
Hiya, I'm trying to parse an XML file and one of the fields looks like the following: <link>http://foo.com/this-platform/scripts/click.php?var_a=a&var_b=b&varc=http%3A%2F%2Fwww.foo.com%2Fthis-section-here%2Fperf%2F229408%3Fvalue%3D0222%26some_variable%3Dmeee</link> This seems to break the parser. i think it might be so...
I have a web service that's serializing a class (class is from the web service) into an MSMQ, then a windows service is checking the queue and deserializing. The windows service has a web reference to get the class. If I deserialize inside the web service, everything comes out fine. However, when I deserialize from the windows service...
When I load an XML document from disk into an XDocument, that XDocument has a ready-only property BaseUri that contains the original XML document's location on disk. In other words, XDocument doc = XDocument.Load(@"c:\temp\doc.xml"); Console.Out.WriteLine(doc.BaseUri); // Outputs "file:///c:/temp/doc.xml" If I create a new XDocument...
I have an xml file sample.xml located in some folder: <?xml version="1.0"?> <!-- Please Enter your frequency value between 10sec to 80sec --> <Time> <Value>80</Value> </Time> this xml file is given to user if any one enters beyond the limit say 8, or 700 it wl send the default value as 80 in the log file(it is windowservice we don...
I'm trying to parse an XML file returned by a webservice with jQuery. Here is the code I have set up, but nothing seems to happen. $.ajax({ type: 'GET', url: 'http://www.sample.com/webservice', dataType: 'xml', success: function(xml){ console.log(xml); $(xml).find('movies').each(function(){ $(this).find('movie').each(function...
How can I remove whitespace on every instance of a particular node which I specify in C#? For example let's say that I have the following XML document: <XML_Doc> <Record_1> <Name>Bob</Name> <ID_Number>12345</ID_Number> <Sample> </Sample> </Record_1> <Record_2> <Name>John</Name> <ID_Number>54321</ID_...
I need to update the GroupID field to a 0. I have figured out how to retrieve the value, I am now running into problems updating it. Any help would ge great! <ProblemProfile> <GroupID>-1</GroupID> <LayoutID>1</LayoutID> <MyQueries>false</MyQueries> </ProblemProfile> Declare @Result xml set @Result = convert(xml,(select Profil...
I have written a chunk of XML parsing which works successfully provided I use an absolute path. I now need to take an XMLNode as an argument and run an xpath against this. Does anyone know how to do this? I tried using relative XPath queries without any success!! Should it be this hard?? ...
Ok, check out this voodoo: This code: $xml = new SimpleXMLElement($xml); $var = $xml->QBXMLMsgsRs->ClassQueryRs; $vars = print_r($var,true); Returns: SimpleXMLElement Object ( [@attributes] => Array ( [requestID] => Q2xhc3NRdWVyeXw1 [statusCode] => 0 [statusSeverity] => Info ...
Hello, I am looking to achieve two things: a) To find a free, whether open-source or not, XML database that is simple to use and b) To access an MS Access DB and convert it to the XML database. If this can be done automatically, so much the better :) Otherwise, what would be the easier way to do this? Thanks! ...
hello everyone, my first time posting here. My question is as follow: I need to build a horizontal scroller like the one in Itunes or like the one that the macs uses in the finder window. http://www.flashcomponents.net/upload/samples/4250/index.html?full=true The client, however wants this to be fed from an xml file and to display html...
My backend program generates some XML data and sends them to the client. The backend response is like this: print $cgi->header("Content-type: text/xml;charset=utf-8"); print "<?xml version='1.0' encoding = 'utf-8'?>"; < correct XML data goes here > When I try to visualize the sent XML in Firefox, It gets the whole thing and everythin...
Hi, This is a doubt in SAX. I want to process the children tags in a XML file,only if it matches the parent tag. For ex: <version> <parent tag-1> <tag 1> <tag 2> </parent tag-1 > <parent tag-2> <tag 1> <tag 2> </parent tag-2> </version> In the above code, I want to match the parent tag f...
I am having trouble trying to pass an array of data to a Nusoap client request to a WSDL server. The spec is a mixture of attribute values and simpleContent values. The WDSL spec looks something like this: <s:complexType name="RequestMessage"> <s:sequence> <s:element minOccurs="0" name="Address" type="s0:MessageAddress"/> <s:...
I have to create one table using XSLT and CSS. The table should look like enter code here ID FNAME 1 AA 2 BB XML: enter code here <students> <studentDetails id="1" fname="AA"/> <studentDetails id="2" fname="BB"/> </students> XSLT so far: I hav...
If I have a string which may contain any characters (including '/', '&',etc...) how do convert it safely into XML that can be stored like this: <myelement>mystring</myelement> Does it need to be CDATA, or can I easily convert it using a ruby function? ...
We have to read data from a aspx page. When we call the page with a query string, it returns an xml document with data that matches the query string. We have an XSD that matches the xml that we get back. I am thinking that we can read the xml document out of the http response. Will this work? How can we "bind" the XML with the XSD, su...