Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>S. Lott's answer is right: you don't encode the end tag, you break it across multiple CDATA sections.</p> <p>How to run across this problem in the real world: using an XML editor to create an XML document that will be fed into a content-management system, try to write an article about CDATA sections. Your ordinary trick of embedding code samples in a CDATA section will fail you here. You can imagine how I learned this.</p> <p>But under most circumstances, you won't encounter this, and here's why: if you want to store (say) the text of an XML document as the content of an XML element, you'll probably use a DOM method, e.g.:</p> <pre><code>XmlElement elm = doc.CreateElement("foo"); elm.InnerText = "&lt;[CDATA[[Is this a problem?]]&gt;"; </code></pre> <p>And the DOM quite reasonably escapes the &lt; and the >, which means that you haven't inadvertently embedded a CDATA section in your document.</p> <p>Oh, and this is interesting:</p> <pre><code>XmlDocument doc = new XmlDocument(); XmlElement elm = doc.CreateElement("doc"); doc.AppendChild(elm); string data = "&lt;![[CDATA[This is an embedded CDATA section]]&gt;"; XmlCDataSection cdata = doc.CreateCDataSection(data); elm.AppendChild(cdata); </code></pre> <p>This is probably an ideosyncrasy of the .NET DOM, but that doesn't throw an exception. The exception gets thrown here:</p> <pre><code>Console.Write(doc.OuterXml); </code></pre> <p>I'd guess that what's happening under the hood is that the XmlDocument is using an XmlWriter produce its output, and the XmlWriter checks for well-formedness as it writes.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs there a way to escape a CDATA end token in xml?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRobert Rossney
    1. USRobert Rossney
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWell, I had an almost "real world" example. I usually load Xml from Flash that contains html markup within CDATA sections. Having a way to escape it could be useful, I guess. But anyway, in that case, the CDATA content is usually valid XHTML, and so the "outer" CDATA could be avoided altogether.
      singulars
      1. PO
      1. USJuan Pablo Califano
    2. COCDATA can nearly always be avoided altogether. I find that people who struggle with CDATA very frequently don't understand what they're really trying to do and/or how the technology they're using really works.
      singulars
      1. PO
      1. USRobert Rossney
    3. COOh, I should also add that the only reason that the CMS I alluded to in my answer used CDATA was that I wrote it, and I didn't understand what I was really trying to do and/or how the technology works. I didn't need to use CDATA.
      singulars
      1. PO
      1. USRobert Rossney
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload