[dbforms] search with tableList problems

Alexander Korovin Tue, 17 Aug 2004 23:48:39 -0700

Hello, All!

I've got index.jsp :

   <db:dbform autoUpdate="false" maxRows="*" tableName="ProductRes" followUp="/searchresult.jsp" tableList="Product, ProductCatalog" whereClause="Where Product.ProductCatalogSN=ProductCatalog.ProductCatalogSN">
      <db:header>
      <db:search fieldName="Product.DescShort" searchAlgo="weak"/>
      <db:gotoButton caption="Search" destination="/searchresult.jsp" styleClass="button"/>
        <table cellspacing="2" border="0" >
      </db:header>
      <db:body allowNew="false">
        <tr class="dark">
          <td><db:label fieldName="Product.DescShort"/></td>
          <td><db:label fieldName="ProductCatalog.Description"/></td>
        </tr>
      </db:body>
      <db:footer>
      </table>
      </db:footer>
    </db:dbform>

and searchresult.jsp :

      <db:dbform tableName="ProductRes" maxRows="*" followUp="/index.jsp">
        <db:header>
          <table class="blockLayout" cellspacing="0" width="100%">
            <tbody>
              <tr>
                <td>
                  <table cellspacing="0" class="block" width="100%">
                    <tr class="component">
                      <td colspan="4">
                        <fmt:message key="message.header.resultpage"/>
                      </td>
                    </tr>
                    <tr class="header">
                      <td>CustomerSN</td>
                      <td>ProductSN</td>
                      <td>DescShort</td>
                      <td>DescLong</td>
                    </tr>
        </db:header>
                  <db:body>
                    <tr class="light">
                      <td><db:label fieldName="Product.CustomerSN"/></td>
                      <td><db:label fieldName="Product.ProductSN"/></td>
                      <td><db:label fieldName="Product.DescShort"/></td>
                      <td><db:label fieldName="Product.DescLong"/></td>
                    </tr>
                  </db:body>
                  <db:footer>
                  </table>
                </td>
              </tr>
            </tbody>
          </table>
                  </db:footer>
      </db:dbform>

Why my search does not work? Tomcat message: java.sql.SQLException: General error, message from server: "Table 't1.ProductRes' doesn't exist".

dbforms-config.xml:
    <table name="ProductRes">
        <field name="Product.ProductSN" fieldType="decimal" size="10" isKey="true"/>
        <field name="Product.CreatedBy" fieldType="varchar" size="60"/>
        <field name="Product.CreatedOn" fieldType="datetime" size="19"/>
        <field name="Product.ChangedBy" fieldType="varchar" size="60"/>
        <field name="Product.ChangedOn" fieldType="datetime" size="19"/>
        <field name="Product.ProductGroupID" fieldType="varchar" size="10"/>
        <field name="Product.ProductCatalogSN" fieldType="decimal" size="10"/>
         .

</table>

Any suggestions?
THX

---

Alex

[dbforms] search with tableList problems

Reply via email to