Re: [dbforms] Re: [Jdbforms-developers] Join tables support

[Shawn]

Please send to [EMAIL PROTECTED]
Hello, Shawn!
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"/>
         .
         .
         .
        <field name="ProductCatalog.ProductCatalogSN" fieldType="decimal" size="10" 
isKey="true"/>
        <field name="ProductCatalog.CreatedBy" fieldType="varchar" size="60"/>
        <field name="ProductCatalog.CreatedOn" fieldType="datetime" size="19"/>
        <field name="ProductCatalog.ChangedBy" fieldType="varchar" size="60"/>
        <field name="ProductCatalog.ChangedOn" fieldType="datetime" size="19"/>
        <field name="ProductCatalog.SupplierSN" fieldType="decimal" size="10"/>
        <field name="ProductCatalog.CurrencyID" fieldType="char" size="3"/>
        <field name="ProductCatalog.LanguageID" fieldType="varchar" size="4"/>
        <field name="ProductCatalog.StateID" fieldType="varchar" size="10"/>
        <field name="ProductCatalog.ProductCatalogID" fieldType="varchar" size="20"/>
        <field name="ProductCatalog.Description" fieldType="varchar" size="100"/>
        <field name="ProductCatalog.ValidFrom" fieldType="datetime" size="19"/>
        <field name="ProductCatalog.ValidTo" fieldType="datetime" size="19"/>
        <field name="ProductCatalog.Version" fieldType="varchar" size="10"/>
        <field name="ProductCatalog.GeneratedOn" fieldType="datetime" size="19"/>
        <field name="ProductCatalog.URL" fieldType="text" size="65535"/>
    </table>
Any suggestions?
THX
---
Alex


--
Shawn
Karma is immutable, so act accordingly!

-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms