xml

SQL Server 2008 XML query issue

Hello everyone, I am using SQL Server 2008 Enterprise + VSTS 2008 + C# + .Net 3.5 + ASP.Net + IIS 7.0 to develop a simple web application. In my database table, I have a XML type column. The content is like below, I want to get AdditionalInfoList of all rows in the table if Title contains "software engineer" or Info contains "Software ...

Parse XML using a XSD in PHP

I have a XML file and a a bunch of XSD files with schemas. How do I parse the XML file using the correct XSD file and schema in PHP? ...

making the xml spreadsheet readonly

Hi, I'm trying to create a xls from a xml document (Its actually a xml which is created.. I kinda fool the registry to open it in Excel by naming it as .xls). My question being... How do i make this excel read-only? That is.. is there any tags in xml that can make the spreadsheet readonly? Thanks in advance.... ...

Extra parameter for jQuery's ajax success function

I'm fetching an XML file using this code: function getMaps(){ toLoad = loadMaps.length; for (var i = 0; i < loadMaps.length; i++){ $.ajax({ type: "GET", url: loadMaps[i], dataType: "xml", success: processMap }); } } Which works fine, but I want to give processMap an...

Getting Dynamic References To XML Nodes And Setting Text Values In .NET

Hi All, I have a treeview populated from XMLDatasource in .NET. I want to edit the nodes,attributes values and then save the modified xml. The user clicks on the node or attribute or text of the node of the tree and click the edit button on which I provide a text box. He/she can enter the value in the textbox and click the save button ...

Using T-SQL to read an XML feed directly into an XML field in a table?

I see a LOT of resources about producing feeds from T-SQL2005, about parsing XML into a database schema, processing, bulk operations, etc. What I don't see is how to have, for example, a statement/s in a stored proc or function which can simply access a URL for an XML feed, load the XML into a table field or sproc variable and close the...

Exception when serializing class which implements IEnumerable

Hi All, I'm trying to serialize a class using XmlSerializer. This class contains a member of a type which implements IEnumerable. Here is a snippet of the code: [Serializable] public class A{ private A1 m1; privte A2 m2; } [Serializable] public class A1: IEnumerable{ private List _list; } [Serializable] public class A2{ ... } [S...

Obtaining broken XML followed by full XML from webservice

hi friends In my contact management app i am using webservice to get a large xml data, that contains contact details. i use NSURLConnection class for sending requests. But i am facing problem in while getting the XML . First i get a broken XML and then I am getting the whole XML data . Can anyone figure out what is going wrong in my app...

is there a faster way to get a YouTube clip's title than this?

Currently i'm using the following, which seems quite slow for multiple clips: static function get_yt_title($clip_id){ $feedURL = 'http://gdata.youtube.com/feeds/api/videos/' . $clip_id; $entry = @simplexml_load_file($feedURL); if($entry){ $video= new stdClass; $media = $entry->children('http://search.yaho...

Illegal character in Xml

I have a PHP file which produces an Xml sitemap based on data which has been imported from a number of sources. My sitemap is currently not well formed due to an illegal character in one line of the imported data however I am struggling to remove it. The character looks to represent the 'squared' or superscript 2, and is represented a...

What is the difference between Inclusive and Exclusive OR?

I have been studying some Business Process Execution Language (BPEL) and the associated modelling system (BPMN) where the designer needs to learn about inclusive and exclusive gateways for process flow. Thanks very much for any help and a general explanation of the terms would be enough assuming the same rules apply. This is some techn...

Access SQL database from Android?

I understand that to access a SQL database from Android I need to create a web service that will run on the SQL server and will process requests from the Android application, what I need to know is how to create this web service and how to access it from Android. If anyone can point me in the right direction then this would be greatly ap...

Sending XML data from iPhone client to Web Server

I'm looking to keep a high score table for my application in XML format. All I am looking to send is a timestamp, string ID, and value. So my questions are do I have to create anything to receive the data, or can I simply have the app write out to a hosted XML file? If not can I write out new XML files for each message (and compile the...

XMLHttpRequest simple HTTP GET not working?

<html> <body> <SCRIPT type="text/javascript"> var xmlHttp = new XMLHttpRequest(); var async = true; xmlHttp.open("GET", "http://www.google.com", async); if(async) { xmlHttp.onreadystatechange = function() { if(xmlHttp.readyState == 4) { if (xmlHttp.status==200) a...

Using lxml to find order of text and sub-elements

Let's say I have the following HTML: <div> text1 <div> t1 </div> text2 <div> t2 </div> text3 </div> I know of how to get the text and subelements of the enclosing div using lxml.html. But is there a way to access both text and sub elements in an iterative manner, that preserves order? In other words, I want to know where the "fr...

what's the best scenario to use XSLT

I am learning xslt, but don't know the best scenarios for use xml + xsl. ...

Root Element Missing - Creating Xmldocument using XmlTextWriter

Hello I'm having the following code which is spitting 'Root Element Missing' during doc.Load(). MemoryStream stream = new MemoryStream(); XmlTextWriter xmlWriter = new XmlTextWriter(stream, Encoding.UTF8); xmlWriter.Formatting = System.Xml.Formatting.Indented; xmlWriter.WriteStartDocument(); xmlWriter.WriteStartElement("Root"); XmlDocu...

Indentation issues with Staxmate API

I am using Staxmate API to generate XML file. After reading the tutorial: http://staxmate.codehaus.org/Tutorial I tried making the changes in my code. At last I added the call doc.setIndentation("\n ", 1, 1); Which causes the newly generated XML file to be empty! Without this method call entire XML file gets generated as expected. ...

How to read XML into a DataTable when the XML is in a particular namespace

I want to read some XML data into a DataTable - using the ReadXml method like so var dataTable = new DataTable(); XmlReader xmlReader = XmlReader.Create(new StringReader(xmlString)); dataTable.ReadXml(xmlReader); See below for the XML string. The XML includes the schema definition and everything is fine and da...

Approach to upgrade application configuration

Hi All, My application has a xml based configuration. It has also a xsd file. Before my application starts, xmllint will check the configuration against the xsd file. With the growth of my application, the configuration structure has changed a bit. Now I have to face this problem: When I provide a new version of my application to cust...