- Could you post the whole sql statement? - Which version do you use? - Why do you use this difficult free form select and not the query type? - At what time do you get the error? During the call to the main page or the searchResults? - If you use the table ProductRes in the searchpage you can not define fields in your config file which belongs to an different table To overcome this define a query inside your config file!
Cheers, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Alexander Korovin > Gesendet: Mittwoch, 18. August 2004 08:46 > An: [EMAIL PROTECTED] > Betreff: [dbforms] search with tableList problems > > 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"/> > . > . > . > <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 > > ------------------------------------------------------- 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
