<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="http://www.fordingbridgeconservation.uk/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="http://www.fordingbridgeconservation.uk/feed.php">
        <title>Bishop&#039;s Pond - dbquery</title>
        <description>Fordingbridge Conservation Group</description>
        <link>http://www.fordingbridgeconservation.uk/</link>
        <image rdf:resource="http://www.fordingbridgeconservation.uk/_media/wiki/logo.png" />
       <dc:date>2026-04-17T00:56:18+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="http://www.fordingbridgeconservation.uk/dbquery/start?rev=1756295731&amp;do=diff"/>
                <rdf:li rdf:resource="http://www.fordingbridgeconservation.uk/dbquery/test1?rev=1756296256&amp;do=diff"/>
                <rdf:li rdf:resource="http://www.fordingbridgeconservation.uk/dbquery/test2?rev=1756296233&amp;do=diff"/>
                <rdf:li rdf:resource="http://www.fordingbridgeconservation.uk/dbquery/test3?rev=1756297612&amp;do=diff"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="http://www.fordingbridgeconservation.uk/_media/wiki/logo.png">
        <title>Bishop's Pond</title>
        <link>http://www.fordingbridgeconservation.uk/</link>
        <url>http://www.fordingbridgeconservation.uk/_media/wiki/logo.png</url>
    </image>
    <item rdf:about="http://www.fordingbridgeconservation.uk/dbquery/start?rev=1756295731&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2025-08-27T11:55:31+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Test query results</title>
        <link>http://www.fordingbridgeconservation.uk/dbquery/start?rev=1756295731&amp;do=diff</link>
        <description>Test query results



Start of test1 table query result

Start of test2 table query result

Start of test3 status query result

End of query results</description>
    </item>
    <item rdf:about="http://www.fordingbridgeconservation.uk/dbquery/test1?rev=1756296256&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2025-08-27T12:04:16+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Test1 table query</title>
        <link>http://www.fordingbridgeconservation.uk/dbquery/test1?rev=1756296256&amp;do=diff</link>
        <description>Test1 table query


SELECT * FROM species;</description>
    </item>
    <item rdf:about="http://www.fordingbridgeconservation.uk/dbquery/test2?rev=1756296233&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2025-08-27T12:03:53+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Test2 table query</title>
        <link>http://www.fordingbridgeconservation.uk/dbquery/test2?rev=1756296233&amp;do=diff</link>
        <description>Test2 table query


SELECT common_name AS &quot;Common name&quot;, scientific_name AS &quot;Scientific name&quot;, date, location, note, id FROM species ORDER BY scientific_name;</description>
    </item>
    <item rdf:about="http://www.fordingbridgeconservation.uk/dbquery/test3?rev=1756297612&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2025-08-27T12:26:52+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Test3 status query</title>
        <link>http://www.fordingbridgeconservation.uk/dbquery/test3?rev=1756297612&amp;do=diff</link>
        <description>Test3 status query


SELECT 
    IIF (lower(common_name) LIKE &#039;%frog%&#039;, &#039;frog&#039;, &#039;notfrog&#039;) AS status,
    common_name AS result
FROM species
WHERE lower(common_name) LIKE &#039;%frog%&#039;
LIMIT 1;


These are the possible status codes

frog


&lt;div style=&quot;background-color: #D5E8D4&quot;&gt;Frog: :result&lt;/div&gt;</description>
    </item>
</rdf:RDF>
