xml

How to parse XML in order to extract data from MySQL Database.

Hello Here is a simple form to send to admin_xml.php <form name="review" action="admin_xml.php" method="post"> <textarea name="xml" cols="40" rows="10"></textarea> <input class="submit" type="submit" value="Submit Request"> </form> Here is the XML which I want to enter into the form to extract Data from MySQL Database. <?xml ver...

How to use XmlDocument and/or XDocument to parse numeric character references encoded in Windows 1252?

I'm working with XML data from an application where we get XML like this: <elt attrib="Swedish: &#228; &#246; Euro: &#128; Quotes: &#145; &#146; &#147; &#148;"> Swedish: &#228; &#246; Euro: &#128; Quotes: &#145; &#146; &#147; &#148; </elt> I want the attribute value and inner text values to be Swedish: ä ö Euro: € Quotes: ‘ ’ “ ” b...

loadXML does not work in Safari?

I'm using Safari for windows. It tells me that document.prototype.loadXML is undefined. What are my other options to create XML document? ...

Is there an easy way to return the FIRST LinqToXML result?

Ok, I have a LinqToXml query that returns a single record (correct terminology?), however, I don't want to use a for.. loop to pull that one record from the query. Is there an easier way? *bonus if you find a better way to write the query (I'm still learning) my xml file: <?xml version="1.0"?> <!-- first draft of LibMappings.xml fi...

Extract an SQL Server 2005 database's structure to XML

This is something I know can be done somehow, because I've done it before, but I can't for the life of me remember how. I want to export the structure of an SQL Server database to an XML file. The one that I have from last time we did this has this kind of structure: <Data> <Details> <Server>Server Name</Server> <D...

jquery parsing xml with \n

I'm using jquery to parse some xml. However, the xml has line breaks and spaces in it. E.g. some item instead of some item When I get the text() of the node, I get "\n some item \n" Is there some way I get either strip this white space after text() or just get jquery to ignore it while parsing? Thanks ...

Displaying an image from a URL returned by an API

I am making an API call that should return something like the following, <?xml version="1.0" encoding="utf-8" ?> <Chart:chart xmlns:Chart="http://www.zillow.com/vstatic/3/static/xsd/Chart.xsd"&gt; <request> <zpid>48749425</zpid> <unit-type>percent</unit-type> <width>300</width> <height>150</height> </r...

Visual C# 2008, reading an XML file and populating a listView

Here is my ultimate goal... to take this xml file.. <?xml version="1.0"?> <Songs> <Song> <Name>Star Spangled Banner</Name> <Artist>Francis Scott Key</Artist> <Genre>Patriotic</Genre> </Song> <Song> <Name>Blankity Blank Blank</Name> <Artist>Something Something</Artist> <Genre>Here here</...

Magento XML layout with custom modules

Hi, I'm trying to include a custom template into the checkout process on the shipping page. I want that template to adopt the functionality of its parent template so I can use any of the shipping variables within the template. However I can't get magento to load the template. Here is my XML (the header scripts are adding successfully...

Convert XML PATH to XML EXPLICIT for SQL 2000

Hi, I have a section of code that runs on a SQL 2005 server as: SELECT e.[ElementName] , ISNULL(ElementValue, ElementDefaultValue) AS Value FROM [cx_Element] e WITH ( NOLOCK ) LEFT JOIN [cx_ReportStyleElements] rse WITH ( NOLOCK ) ON rse.[ElementId] = e. [ElementId] ...

Parse an xml document when namespace is no-longer available.

I have a number rather large, complex xml documents that I need to loop through. An xmlns is defined at the top of the document however the url this points to is no longer available. What's the best way to parse the file to get the important data from it using C#? I tried to load it into a Dataset but would occasionally receive the err...

Generate C# code for Oracle table

I have this XML for a table structure in Oracle (export option in PL/SQL developer). How can I generate code in C# for get entity class? <?xml version="1.0" encoding="utf-8"?> <ROWDATA> <ROW> <Name>ID_TRANSACCION</Name> <Type>NUMBER(12)</Type> <Nullable></Nullable> <Default></Default> <Comments>Identificador unico ...

Complex XPath searches using attributes?

I have some XML which I'm trying to search: <debts> <section id="24" description="YYYYY"> <section id="28" description="xxx"> <section id="31" description="xxx"> <account accountNumber="2312323" creditorId="1" amount="1200" proposedAmount="1000" percentage="11" owner="2"> <foo/> </account> </s...

Pull an xml schema from a sql 2005 database

In Microsoft SQL Server 2005, there is the option to store within the database under "Database -> Type -> XML Schema Collection" a XML schema to validate against if you are viewing the database within SQL management studio. What I need to do is store the schema under the specified path above, and then within code pull that schema out t...

Linq2XSD - Looking for articles, tutorials and experiences of

Only just found out about this. Does anyone have any links to some good sites talking about this? Its features, bugs, limitations. (obviously I have searched, so am looking for info that wont be on page 1 of Google :D ) ...

I know PHP's read, write, and append... but can you insert? or remove last line?

I am trying to create an XML file, but the XML file needs to be wrapped in nodes... hence, not easy to use append. Any help with this would be great!! My XML consists of 2 different node types: <entry id="1_0"> <title>This is the title</title> <description>This is the description...</description> <subName>Publishers Name<...

Magento Template Variables

Hi, Is it possible to pass a variable from a parent template to a child template. For example, if i wanted to put some repeated HTML in a separate template that was included within a foreach loop in its parent template <?php foreach ($items as $item) { echo $this->getChildHtml('item_info'); } ?> I would want to be able to access ...

Non greedy searches with Hpricot?

I'm using Hpricot for traversing an XML packet. For each node I'm on, I want to get a list of the immediate children . However when using (current_node/:section) I'm getting ALL descendant sections, not just the immediate children. How can I get around this? ...

How do you force a WPF ListView to Requery its ItemSource?

I'm rewriting its XML itemSource on the fly and want it to use the new data right away... ...

How to pass XML as POST to an ActionResult in ASP MVC .NET

Hi, I am trying to provide a simple RESTful API to my ASP MVC project. I will not have control of the clients of this API, they will be passing an XML via a POST method that will contain the information needed to perform some actions on the server side and provide back an XML with the result of the action. I don't have problems sendin...