I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. However, we have a custom installation program that is used to deploy stored procedures to databases, and when this is used, execution of the sp ...
I often see people asking XML/XSLT related questions here that root in the inability to grasp how CDATA works (like this one). I wonder - why does it exist in the first place? It's not that XML could not do without it, everything you can put into a CDATA section can be expressed as "native" (XML-escaped). I appreciate that CDATA potent...
I have a form allowing a user to signup for a news letter which submits back to the page it's sat in for validation and adding the content to the db, however I also need to send an xml file to a third part using the information collected from the form to add to a mailing list. The data sent to the third party seems to need to be sent usi...
I have a huge xml file. And it's being transformed to html table with xsl. In browser it's a single page with vertical scrollbar. But when I want to print the document I can see about 10 pages. I want to add table headers to every printed page. Sample xml: <page> <document> <id>100</id> <name>SomeName</name> <dat...
I'm trying to come up with the best way to handle configuration in an application. At first i just used SimpleXML and put the code in a singleton. I've decided to try to create a way to query the configuration with something like $config->getConfig('/module/name'); Do you have to use xpath to do this or is there any other method that ...
I have the next code which works fine in IE: xml=new ActiveXObject("MSXML2.DOMDocument"); xml.async=false xml.load("docs.xml") How to do the same (without Ajax) in other browsers? ...
I have a network directory that has a dump of all employee pics here at our company. The images are named FirstnameLastinitial.jpg. I ultimately am trying to build a photo browser of these pics in Silverlight but I thought I would start with how to harvest the Pictures from that location. I would imagine that I should generate an XML ...
I'd like to read in the following XML: <node></node> And then write it out, minified, like this: <node/> Obviously this has the same meaning, but the second file is smaller for sending across the wire. I'm trying to find a way to do this in .NET. I can't seem to find an option or setting that would drop unnecessary closing tags. ...
I'm creating an XML document using DocumentBuilderFactory and w3c.org's Document class. I want to validate the resulting structure against an XSD before writing it out to a file. I know that I can set the DocumentBuilderFactory to validate as it is being created but I would prefer not to as I am doing other things with it. Thanks. ...
I wrote a simple package installer in WinBatch that needs to update an XML file with information about the package contents. My first stab at it involved loading the file with Msxml2.DOMDocument, adding nodes and data as required, then saving the data back to disk. This worked well enough, except that it would not create tab and CR/LF wh...
I know there are a lot of questions that have been asked about synchronicity in Flex, but I'm not sure if any cover the same issue I'm having. The title only refers to one possible solution I've been going for with this, but essentially here's my situation: Say I have a Flex application, and I have an XML file with configuration setting...
I'm trying to use Quartz Composer to create a continuous integration build radiator. I put together a simple XML file to describe the projects and the latest success of each of their workflows: <projects> <project> <title>Project A</title> <workflows> <workflow> <title>Build 1.0</title> <status>success</...
I have a root element in my output xml document that has no attributes: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <root> .. </root> I need it to look something like this: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="my.x...
I am rebuilding a nodes children by saving them out to an array as strings, trashing them in the XML, inserting a new child node into the array as a string... now I want to loop through the array and write them back out to the original node. The problem is I can't find anything on how to add a child node using a string. See below for ...
The FuelPathwayCode and PhysicalPathwayCode go into Parent table and transaction-item elements goes into the Child table. Parent table has a primary key and the child table has the related foreign key. The Parent table has FuelNameID and PhysicalPathwayID columns that are related to two lookup tables: FuelName and PhysicalPathway. Th...
I'm planning on using Sinatra for a new tiny webservice (WS) that I need to put together for a client. The WS will only have two methods, one accessed via GET and one via POST. For the POST method, the client will send an XML packet to the sinatra WS which will parse the data and issue either a 200 OK HTTP response or a 40x error code....
Basically, I'm looking to create a simple music playlist platform but in the form of webpages. Users create playlist, add songs to it, and other users can view these playlists. But the website must use SOAP to send and retrieve data. How is this possible? Is this possible? ...
I am retrieving a twitter feed using a php file and it is returning the XML, however the date XML field is.. <created_at>Sun Nov 08 07:26:07 +0000 2009</created_at> I am calling this inside flex from my [Bindable] public var twitterData:XMLList; using {data.created_at} how would I format this to read as a normal date? (i.e Sun Nov ...
I have a big xml file (65 Mo) that I need to feed to a Crystal Report XI. My problem is that I tried running the report and it takes forever to display a single page (about 15 minutes a page). I still cannot see the end result since I am not patient enough to wait 15 days to get the full report. My total report should be around 1500 pag...
I have a table that contains a column of XML Datatype (column name FileContent). I want to create a view that queries the contents of the XML datatype column so that I no longer have FileContent column but two additional columns called FuelPathwayCode and PhysicalPathwayCode from the underlying XML document. Is this possible with SQL S...