content/xul/templates/tests/chrome/test_tmpl_storage_bad_parameters_3.xul

<?xml version="1.0"?>
<?xml-stylesheet href="chrome://global/skin" type="text/css"?>
<?xml-stylesheet href="chrome://mochikit/content/tests/SimpleTest/test.css" type="text/css"?>

<!--
    storage listbox with bad query parameters
-->

<window title="XUL Template Tests" width="500" height="600"
        onload="test_template();"
        xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">
  <script type="application/javascript"
          src="chrome://mochikit/content/MochiKit/packed.js"></script>
  <script type="application/javascript"
          src="chrome://mochikit/content/tests/SimpleTest/SimpleTest.js"></script>

  <body xmlns="http://www.w3.org/1999/xhtml" style="height: 300px; overflow: auto;"/>

<script src="templates_shared.js"/>

<script>
<![CDATA[
SimpleTest.waitForExplicitFinish();

var testid ="storage listbox with bad query parameters";
var queryType = "storage";
var isTreeBuilder = false;
var needsOpen = false;
var notWorkingYet = false;
var notWorkingYetDynamic = false;
var expectedOutput = <output></output>;


Components.classes["@mozilla.org/consoleservice;1"]
          .getService(Components.interfaces.nsIConsoleService)
          .reset();

copyToProfile('animals.sqlite');

expectedConsoleMessages.push("Error parsing template: a query parameter cannot be bound to the SQL query");

var changes = [];
]]>
</script>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
                SELECT * FROM animals WHERE species_id = :spec ORDER BY name
            <param name="spec" type="int32">5</param>
            <param>L%</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>

</window>