Hi, <1> tableData tag does not need to have the "foreignTable" in the dbforms-config.xml file. So you do not need to declare it! <2> It seems that in your DB does not exists a CLIENTNEEDS_LABEL field, I see that you are useing Oracle (and I don't know it so well). In my case with postgresq I have to use CASE SENSITIVE fields, are you sure that CLIENTNEEDS_LABEL appares with this CASE and name on your database. Tipically the tableData creates a query like
SELECT CLIENTNEEDS_CODE,CLIENTNEEDS_LABEL FROM OTFE_CLIENTNEEDS try this query in a SQL-Query tool agaisnt your db! Or try to see the log of your DBMS. Hope this helps. Regards Ivan Quoting [EMAIL PROTECTED]: > Hi, > > I try to select data from another tables > > <db:message key="Code"/> > <db:select fieldName="CLIENTNEEDS_CODE"> > <db:tableData storeField="CLIENTNEEDS_CODE" > visibleFields="CLIENTNEEDS_LABEL" > foreignTable="OTFE_CLIENTNEEDS" > name="FK_OTFE_PRO_OTFE_NEED_OTFE_CLI"/> > </db:select> > > > my table PRODUCTSERVICES is like this : > > <table name="OTFE_PRODUCTSERVICES" defaultVisibleFields="PRODSERV_CODE"> > <field name="PRODSERV_CODE" Code" fieldType="char" size="20" isKey="true"/> > <field name="CLIENTNEEDS_CODE" fieldType="char" size="21" sortable="true"/> > <field name="PRODSERV_LABEL" fieldType="char" size="100" defaultValue=""/> > <field name="PRODSERV_LANGUAGE" fieldType="char" size="2" defaultValue=""/> > <field name="PRODSERV_DESCRIPTION" fieldType="char" size="4000" > defaultValue=""/> > <field name="PRODSERV_WEBSITE" fieldType="char" size="100" defaultValue=""/> > <field name="PRODSERV_TRANSLATION" fieldType="char" size="1000" > defaultValue=""/> > <field name="PRODSERV_PICTURE_NAME" fieldType="diskblob" > directory="D:\TEMP\upload\productServices\picture" encoding="true" > size="50"/> > <field name="PRODSERV_PICTURE1_NAME" fieldType="diskblob" > directory="D:\TEMP\upload\productServices\picture1" encoding="true" > size="50"/> > <foreign-key name="FK_OTFE_PRO_OTFE_NEED_OTFE_CLI" > foreignTable="OTFE_CLIENTNEEDS" displayType="select"> > <reference local="CLIENTNEEDS_CODE" > foreign="CLIENTNEEDS_CODE"/> > </foreign-key> > > </table> > > > <table name="OTFE_CLIENTNEEDS" > defaultVisibleFields="CLIENTNEEDS_CODE,CLIENTNEEDS_LABEL"> > <field name="CLIENTNEEDS_CODE" fieldType="char" size="20" isKey="true"/> > <field name="CLIENTNEEDS_LABEL" fieldType="char" size="100" defaultValue="" > isKey="true"/> > <field name="CLIENTNEEDS_DESCRIPTION" fieldType="char" size="400" > defaultValue=""/> > <field name="CLIENTNEEDS_TRANSLATION" fieldType="char" size="1000" > defaultValue=""/> > <field name="CLIENTNEEDS_PICTURE_NAME" fieldType="diskblob" > directory="d:/temp/upload" encoding="true" size="50"/> > > </table> > > > it work fine, except that i have this Exception in my consol ! > > [16/06/05 11:42:12:747 CEST] 3fd9863 SqlUtil E > org.dbforms.util.SqlUtil > TRAS0014I: L'exception suivante a été consignée : java.sql.SQLException: > ORA-00904: "CLIENTNEEDS_LABEL": invalid identifier > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Inlined Compiled > Code)) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) > at > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) > at > oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) > at > com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:426) > at org.dbforms.config.Table.getDoSelectResultSet(Table.java:403) > at org.dbforms.config.Table.doConstrainedSelect(Table.java:1681) > at org.dbforms.event.classic.GotoEvent.processEvent(GotoEvent.java:254) > at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:1829) > at > org.apache.jsp._OTFE_5F_PRODUCTSERVICES_5F_single._jspService(_OTFE_5F_PRODUCTSERVICES_5F_single.java:1065) > at > com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > it seems to look for CLIENTNEEDS_LABEL as key of the table CLIENTNEEDS , i > have > also tried to put CLIENTSNEEDS_LABEL whitout isKey="true", but same things > > Does someone have an idea ? > > Pascal > > > > Selon Henner Kollmann <[EMAIL PROTECTED]>: > > > That's a problem of your data. Searching is always case sensitive! > > > > Cheers > > Henner > > > > > -----Ursprüngliche Nachricht----- > > > Von: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Im > > > Auftrag von [EMAIL PROTECTED] > > > Gesendet: Donnerstag, 16. Juni 2005 10:24 > > > An: jdbforms-interest@lists.sourceforge.net > > > Betreff: [dbforms] case sensitive search > > > > > > Hi, > > > > > > I do some search in my list page. > > > i have implemented the search with the scripting vars > > > > > > but the search is case sensitive that i don't want. > > > > > > Does it exist any solution or config to tell to dbforms, to > > > do the search without case sensitive or it's a problem with > > > my Oracle Database. > > > > > > expl : > > > If i search <begin with "ADT"> i have results, if i search > > > <begin with "adt"> i have no result :-( but i would like have > > > the same results. > > > > > > Thanks, > > > Pascal > > > > > > > > > Selon Henner Kollmann <[EMAIL PROTECTED]>: > > > > > > > Seems that the diskblobs resultset is closed to early. Code in > > > > DataSourceJDBC.java looks quite different. > > > > Best would be to copy the code from DataSourceJDBC into the > > > > classic.Delete class. > > > > If you succeed, please send me the patch! > > > > > > > > Thanks > > > > Henner > > > > > > > > > -----Ursprüngliche Nachricht----- > > > > > Von: [EMAIL PROTECTED] > > > > > [mailto:[EMAIL PROTECTED] Im Auftrag > > > > > von [EMAIL PROTECTED] > > > > > Gesendet: Montag, 13. Juni 2005 16:06 > > > > > An: jdbforms-interest@lists.sourceforge.net > > > > > Betreff: [dbforms] delete problem resultset > > > > > > > > > > Hi, > > > > > > > > > > I'm using Websphere(WSAD5.1.2) dbforms2.5, and i have a delete > > > > > button on a list page and on a single page. > > > > > When i want to delete a row of my table i got the exception below > > > > > (ResultSet is closed), but the row is well deleted ! > > > > > i have the same JSP as followUp in my dbforms tag, and my > > > list page > > > > > in my > > > > > > > > > > Does anybody know why ? > > > > > > > > > > [13/06/05 15:14:49:031 CEST] 900bde6 Controller E > > > > > org.dbforms.servlets.Controller TRAS0014I: L'exception > > > suivante a > > > > > été consignée : > > > > > com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: > > > > > ResultSet est fermé. > > > > > at > > > > > com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.runtimeXIfNotClosed( > > > > > WSJdbcResultSet.java:2631) > > > > > at > > > > > com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet > > > > > .java:2418) > > > > > at > > > > > org.dbforms.event.classic.DeleteEvent.processEvent(DeleteEvent > > > > > .java:201) > > > > > at org.dbforms.servlets.Controller.process(Controller.java:309) > > > > > at org.dbforms.servlets.Controller.doPost(Controller.java:107) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > > > > > > > > > > > > > > > Thanks you, > > > > > > > > > > Pascal > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------------- > > > > > This message was sent using IMP, the Internet Messaging Program. > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > This SF.Net email is sponsored by: NEC IT Guy Games. How far can > > > > > you shotput a projector? How fast can you ride your desk > > > chair down > > > > > the office luge track? > > > > > If you want to score the big prize, get to know the little guy. > > > > > Play to win an NEC 61" plasma display: > > > > > http://www.necitguy.com/?r > > > > > _______________________________________________ > > > > > DbForms Mailing List > > > > > > > > > > http://www.wap-force.net/dbforms > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This SF.Net email is sponsored by: NEC IT Guy Games. How > > > far can you > > > > shotput a projector? How fast can you ride your desk chair down the > > > > office luge track? > > > > If you want to score the big prize, get to know the little guy. > > > > Play to win an NEC 61" plasma display: http://www.necitguy.com/?r > > > > _______________________________________________ > > > > DbForms Mailing List > > > > > > > > http://www.wap-force.net/dbforms > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------------- > > > This message was sent using IMP, the Internet Messaging Program. > > > > > > > > > ------------------------------------------------------- > > > SF.Net email is sponsored by: Discover Easy Linux Migration > > > Strategies from IBM. Find simple to follow Roadmaps, > > > straightforward articles, informative Webcasts and more! Get > > > everything you need to get up to speed, fast. > > > http://ads.osdn.com/?ad_idt77&alloc_id492&op=ick > > > _______________________________________________ > > > DbForms Mailing List > > > > > > http://www.wap-force.net/dbforms > > > > > > > > > > > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=cick > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------ Ivan Codarin ============ ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
