Here's the sample SQL: SELECT xml_data.field FROM (SELECT sys.XMLType(source_table.data).extract('//source_node/text()') AS field FROM source_table )xml_data GROUP BY to_clob(xml_data.field) The error only appears when I use GROUP BY to do a count. When it is removed I get the error ORA-22806: not an object or REF 22806. 00000 ...
I have a simple xml file that is a list of attributes (Name/Value pairs): <?xml version="1.0" encoding="ISO-8859-1"?> <Attrs> <Attr N="IsValid" V="true" /> <Attr N="ID" V="99099" /> </Attrs> I want to create an XSLT file that outputs the values but I cant seem to get it to return the Value for the attribute Here is my xslt: ...
I've been using JDOM for general XML parsing for a long time, but get the feeling that there must be something better, or at least more lightweight, for Java 5 or 6. There's nothing wrong with the JDOM API, but I don't like having to include Xerces with my deployments. Is there a more lightweight alternative, if all I want to do is rea...
Hi All, Having a bit of a headache with Unity XML configuration and generics. I have these files: public interface IRepository<T> {} public class OrderRepository : IRepository { } public class DispatchOrderProcess { public DispatchOrderProcess(IRepository<Order> repository) { } } I would like to inject the Order Repository in...
hi i want to replace a module with another in magento how can i do this (means i want to put Community Poll module to the left ) is there anything like joomla im a newbie in magento so plz be descriptive with your answer ...
I'm trying to update a series of xml files by changing names that they reference. I have a table of names that have changed, column for the current name and a column for the name to replace with. I looked for ways to script search and replace and found sed. It seemed like a good choice until I ran my first attempt. On inspecting the fi...
I would like to parse an Atom Feed and create an Atom-compliant cache of each Entry. The problem is that some feeds (this one for example) have many namespaces other than the Atom one. Is it possible to keep intact all Atom nodes and remove each node that belongs to another namespace? Something like this: valid_nodes = entry.find('a...
I use the following XPATH Query to list the object under a site. "ListObject[@Title='SomeValue']". SomeValue is dynamic. This query works as long as SomeValue does not have an apostrophe ('). I use C#. Tried using escape sequence also. Didn't work. What am I doing wrong? ...
I have a flash swf that accesses XML data that is generated "on the fly" by a PHP script. Some users are viewing it with no problems at all and some cannot seem to retrieve the XML data. I cannot determine if there is a common denominator. has anyone else encountered this problem and have you found a solution/cause? Thanks, ...
Hi there, Say I have the following XML <?xml version="1.0" encoding="utf-8"?> <Person> <FirstName>Bjorn</FirstName> <LastName>Ellis-Gowland</LastName> </Person> That is 'governed' by the following XSD (XML Schema) <?xml version="1.0" encoding="utf-8" ?> <xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.or...
I want to extract only the leaf nodes from an XML document (i.e., only elements that have no children). Has anyone written an xslt to do this? ...
Hi all, I'm trying to get my head around wcf and have a test scenario where i want to recieve an unsigned SOAP message process it and return a signed SOAP message, where the body is signed. Therefore, how do i add a public/private key pair to the WCF service for it to utilise in signing? Secondly, how would i add a digital signature t...
I have a manually created array that already works example below: var PartsData = { 179: { ref:"", partNum: "201-2007-C00-00", descript: "System Monitor Card (Tracewell Only)", cage: "39764", qty: "1", SMR: "XBOZZ...
I have a stored procedure where i am passing a simple XML : '<Products><ProductId>1</ProductId><ProductId>2</ProductId></Products>' I have a @temp table in SQL which has a ProductId Column: DECLARE @Temp TABLE( ProductId NVARCHAR(10) ) I need to write an insert statement which will loop through the ProductId's in the ...
I am trying to execute this (standalone) SQL : Declare @test XML SET @test = '<Products><ProductId>1</ProductId><ProductId>2</ProductId></Products>' DECLARE @Temp TABLE( ProductId NVARCHAR(10) ) INSERT INTO @Temp(ProductId) SELECT tab.col.value('./ProductId[1]','NVARCHAR(10)') AS 'ProductId' FROM @test CROSS APPLY xml_d...
My XML: <root> <child> <childOfChild> <anotherLostChild> <currentSelectedNode> SOME TEXT </currentSelectedNode> </anotherLostChild> </childOfChild> </child> </root> I selected the node currentSelectedNode using: xpath.SelectSingleNode("//currentSelectedNode") But How...
Hi, I am building a comparison shopping site that takes in multiple xml feeds and displays the best deals. I use PHP Simplexml and then sort them using php when the page loads. I use a library like this: http://www.developertutorials.com/blog/php/parallel-web-scraping-in-php-curl-multi-functions-375/ to process the feeds in parallel...
I moved some variables into classes in my workflow. Unfortunately, now the rules fail, I've been trying to set the Type, but keep getting this error. Activity 'ifRequestComplete' validation failed: Property "Condition" has invalid value. Condition expression is invalid. The type name specified ("Request, ApprovalWorkflow")...
I am building an HTML Gui builder and this involves round-tripping HTML pages from the browser to the server and back again. On the back-end I have an xml parser which expects well-formed tags. I kick off by writting well-formed HTML - for example: <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> ...
We have a web-service within an existing ASP.NET website which works fine when accessed via other ASP.NET bits. I'd like to get Excel 2007 and 2003 to call the w-s and refresh part of a worksheet with the results using VBA. Ideally I'd like a vanilla version of Excel to be able to do this (ie without the client having to install extra b...