Databases
StackOverflow2013
Postsdbo
POFetch the complete RSS feed content from XML file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFetch the complete RSS feed content from XML file
    primarykey
    data
    text
    <p>Below is my XML file, and I want to fetch the content of <code>Description</code> tag of every <code>Item</code> tag. I tried using a SAX parser, but it did not work. How can I do this?</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;!-- generator="FeedCreator 1.8.0-dev (info@mypapit.net)" --&gt; &lt;rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"&gt; &lt;channel&gt; &lt;title&gt;Latest Happenings&lt;/title&gt; &lt;description&gt;&lt;/description&gt; &lt;link&gt;http://www.bjp.org/&lt;/link&gt; &lt;lastBuildDate&gt;Wed, 25 May 2011 11:28:15 GMT&lt;/lastBuildDate&gt; &lt;generator&gt;FeedCreator 1.8.0-dev (info@mypapit.net)&lt;/generator&gt; &lt;atom:link href="http://www.bjp.org/index.php?option=com_ninjarsssyndicator&amp;amp;feed_id=12&amp;amp;format=raw" rel="self" type="application/rss+xml" /&gt; &lt;item&gt; &lt;title&gt;Meeting of BJP State Presidents, Pradesh Prabharies/Sah-prabharis and State General Secretaries (Org.) at Lucknow&lt;/title&gt; &lt;description&gt; &lt;image&gt;http://www.bjp.org/images/stories/ne_eng_may_05_2011.jpg&lt;/image&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Sun, 05 Jun 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;BJP National Executive Meeting at Lucknow&lt;/title&gt; &lt;description&gt; &lt;image&gt;http://www.bjp.org/images/stories/meeting3062011.jpg&lt;/image&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Sat, 04 Jun 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;BJP National Executive Meeting at Lucknow&lt;/title&gt; &lt;description&gt; &lt;image&gt;http://www.bjp.org/images/stories/meeting3062011.jpg&lt;/image&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Fri, 03 Jun 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;National Conference on RTI Training by RTI Cell&lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;img width="900" src="http://www.bjp.org/images/stories/invitation card new.jpg" /&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Thu, 26 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;BJYM against corruption – Hai Dum To Badhao Kadam, Chhattisgarh&lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;p&gt;]]&gt;&lt;/text&gt; &lt;link&gt;http://www.bjym.org/hai-dum-to-badhao-kadam&lt;/link&gt; &lt;text&gt;&lt;![CDATA[&lt;/p&gt; &lt;p&gt;]]&gt;&lt;/text&gt; &lt;image&gt;http://www.bjp.org/images/stories/bjym_1.jpg&lt;/image&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Mon, 23 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;National Convention on Corruption &amp;amp;amp; Recovery of Black Money by CA Cell&lt;/title&gt; &lt;description&gt; &lt;image&gt;http://www.bjp.org/images/stories/ca1.jpg&lt;/image&gt; &lt;text&gt;&lt;![CDATA[ &lt;div&gt;&lt;br /&gt; &lt;div&gt;]]&gt;&lt;/text&gt; &lt;image&gt;http://www.bjp.org/images/stories/ca1.jpg&lt;/image&gt; &lt;text&gt;&lt;![CDATA[ &lt;/div&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Tue, 17 May 2011 07:20:52 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;All India Lawyer Conference at Lucknow &lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;p style="text-align: center;"&gt;]]&gt;&lt;/text&gt; &lt;image&gt;http://www.bjp.org/images/stories/kamala_2.png&lt;/image&gt; &lt;text&gt;&lt;![CDATA[ &lt;p style="text-align: center;"&gt;&lt;span style="color:#ff6600;"&gt; &lt;span style="font-size: 24pt;"&gt;&lt;strong&gt;Bharatiya Janata Party&lt;/strong&gt;&lt;strong&gt;&lt;em&gt;&lt;br /&gt;&lt;br /&gt;&lt;/em&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;span style="color: #008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &lt;p style="text-align: center;"&gt;&lt;span style="color:#008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;strong&gt;&lt;span style="font-family: 'arial black', 'avant garde';"&gt;All India Lawyer Conference &lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="color:#008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;strong&gt;&lt;span style="font-family: 'arial black', 'avant garde';"&gt;at Lucknow (Uttar Pradesh)&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: 'arial black', 'avant garde'; color:#008000; font-size: large;"&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt; &lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-family: andale mono,times;"&gt;&lt;em&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color:#ff0000;"&gt;of&lt;/span&gt;&lt;/span&gt;&lt;/em&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color: #000080;"&gt;&lt;strong&gt;BJP President Shri Nitin Gadkari&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt; &lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color:#ff0000;"&gt;&lt;strong&gt;on&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color: #ff0000;"&gt;May 15, 2011 (Sunday)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/p&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Sun, 15 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;Border Darshan: Commemorating 110th Birth Anniversary of Dr. Syama Prasad Mookerjee&lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;p&gt;]]&gt;&lt;/text&gt; &lt;link&gt;http://borderdarshan.com/&lt;/link&gt; &lt;text&gt;&lt;![CDATA[&lt;/p&gt; &lt;p&gt;&lt;img width="900" src="http://www.bjp.org/images/stories/border_darshan_delhi-without pic-shri tarun vijaybalaptenew.jpg" /&gt;&lt;/p&gt; &lt;p&gt;&lt;img src="http://www.bjp.org/images/stories/border_darshan_delhi-without pic-shri tarun vijaybalaptenew.jpg" /&gt;&lt;/p&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Sat, 14 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;BJP SC Morcha National Executive Meeting at Andhra Pradesh&lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;p style="text-align: center;"&gt;]]&gt;&lt;/text&gt; &lt;image&gt;http://www.bjp.org/images/stories/kamala_2.png&lt;/image&gt; &lt;text&gt;&lt;![CDATA[ &lt;p style="text-align: center;"&gt;&lt;span style="color:#ff6600;"&gt;&lt;span style="font-size: 24pt;"&gt;&lt;strong&gt;Bharatiya Janata Party&lt;/strong&gt;&lt;strong&gt;&lt;em&gt;&lt;br /&gt;&lt;br /&gt;&lt;/em&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;span style="color: #008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="color: #008000;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="color: #008000;"&gt;BJP SC Morcha National Executive Meeting &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="color: #008000;"&gt;at &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="color: #008000;"&gt;Andhra Pradesh&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: 'arial black', 'avant garde'; color:#008000; font-size: large;"&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-family: andale mono,times;"&gt;&lt;em&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color:#ff0000;"&gt;of&lt;/span&gt;&lt;/span&gt;&lt;/em&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color: #000080;"&gt;&lt;strong&gt;ST Morcha National President&lt;br /&gt;Shri Faggan Singh Kulasthe&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt; &lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color:#ff0000;"&gt;&lt;strong&gt;on&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color: #ff0000;"&gt;May 12, 2011 (Thursday&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;strong&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color:#ff0000;"&gt;)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/p&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; anurag.pathak@bjp.org (Anurag Pathak)&lt;/author&gt; &lt;pubDate&gt;Thu, 12 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;item&gt; &lt;title&gt;Mukhyamantri Sammelan at Constitution Club, New Delhi&lt;/title&gt; &lt;description&gt; &lt;text&gt;&lt;![CDATA[&lt;p style="text-align: center;"&gt;]]&gt;&lt;/text&gt; &lt;image&gt;http://www.bjp.org/images/stories/kamala_2.png&lt;/image&gt; &lt;text&gt;&lt;![CDATA[ &lt;p style="text-align: center;"&gt;&lt;span style="color:#ff6600;"&gt;&lt;span style="font-size: 24pt;"&gt;&lt;strong&gt;Bharatiya Janata Party&lt;/strong&gt;&lt;strong&gt;&lt;em&gt;&lt;br /&gt;&lt;br /&gt;&lt;/em&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;span style="color: #008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;strong&gt;&lt;span style="color:#008000;"&gt;&lt;span style="font-size: 18pt;"&gt;Mukhyamantri Sammelan &lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;strong&gt;&lt;span style="color:#008000;"&gt;&lt;span style="font-size: 18pt;"&gt;at&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;strong&gt;&lt;span style="color:#008000;"&gt;&lt;span style="font-size: 18pt;"&gt;Constitution Club, New Delhi&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;span style="color: #008000;"&gt;&lt;span style="font-size: 18pt;"&gt;&lt;strong&gt;&lt;span style="font-family: 'arial black', 'avant garde';"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-family: andale mono,times;"&gt;&lt;em&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color:#ff0000;"&gt;of&lt;/span&gt;&lt;/span&gt;&lt;/em&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-family: arial black,avant garde;"&gt;&lt;span style="font-size: 14pt;"&gt;&lt;span style="color: #000080;"&gt;&lt;strong&gt;BJP President Shri Nitin Gadkari&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt; &lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color:#ff0000;"&gt;&lt;strong&gt;on&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-size: 12pt;"&gt;&lt;span style="color: #ff0000;"&gt;May 9-10, 2011 (Monday)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/p&gt;]]&gt;&lt;/text&gt; &lt;/description&gt; &lt;author&gt; pritam.sharma@bjp.org (Pritam Sharma)&lt;/author&gt; &lt;pubDate&gt;Mon, 09 May 2011 00:00:00 GMT&lt;/pubDate&gt; &lt;/item&gt; &lt;/channel&gt; &lt;/rss&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdmon
    1. USDEVANG SHARMA
    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. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFetch the complete RSS feed content from XML file
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POFetch the complete RSS feed content from XML file
      1. USPushpendra Kuntal
      1. VTFavorite
    3. VO
      singulars
      1. POFetch the complete RSS feed content from XML file
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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