Thanks for fast reply. disableCache was the easiest way to solve the problem.
> Or use the disableCache attribute!!! > > Henner > > > -----Urspr�ngliche Nachricht----- > > Von: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Im > > Auftrag von Jan Mutter > > Gesendet: Montag, 13. Oktober 2003 19:16 > > An: [EMAIL PROTECTED] > > Betreff: [dbforms] displaying multiple foreign values from > > one foreign table > > > > > > Hi, > > > > I'd like to display two different foreign values from one > > table. This is my > > configuration: > > > > SQL: > > CREATE TABLE TABLE1 ( > > TABLE1_ID NUMBER(10) NOT NULL, > > DESCRIPTION1 VARCHAR2(20), > > DESCRIPTION2 VARCHAR2(20), > > ) > > > > CREATE TABLE TABLE2 ( > > TABLE2_ID NUMBER(10) NOT NULL, > > --this is the foreign key references to TABLE1 > > TABLE1_ID NUMBER(10) NOT NULL, > > ) > > > > Now I'd like to display the contents of TABLE2 while > > displaying the foreign contents DESCRIPTION1 and DESCRIPTION1 > > > > Thus my JSP Code is: > > <db:dataLabel fieldName="TABLE1_ID"> > > <db:tableData > > storeField="TABLE1_ID" > > visibleFields="DESCRIPTION1" > > foreignTable="TABLE1" > > name="TABLE1_ID"/> > > </db:dataLabel> > > <db:dataLabel fieldName="TABLE1_ID"> > > <db:tableData > > storeField="TABLE1_ID" > > visibleFields="DESCRIPTION2" > > foreignTable="TABLE1" > > name="TABLE1_ID"/> > > </db:dataLabel> > > > > Unfortunately the JSP now displays DESCRIPTION1 for both > > db:dataLabel Tags. > > > > I have that one field in the dbforms-config.xml defined: > > <field > > name="TABLE1_ID" > > fieldType="number" > > fkey="true" > > ftable="TABLE1" > > vfield="DESCRIPTION2" > > sfield="TABLE1_ID"/> > > > > I know something is wrong. Maybe I need to define a seconde > > field - but I don't know how... Can you help me? Is this the > > right approach to display foreign keys/values anyway ? > > > > Cheers, > > Jan. > > > > -- > > NEU F�R ALLE - GMX MediaCenter - f�r Fotos, Musik, Dateien... > > Fotoalbum, File Sharing, MMS, Multimedia-Gru�, GMX FotoService > > > > Jetzt kostenlos anmelden unter http://www.gmx.net > > > > +++ GMX - die erste Adresse f�r Mail, Message, More! +++ > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > SourceForge.net hosts over 70,000 Open Source Projects. See > > the people who have HELPED US provide better services: Click > > here: http://sourceforge.net/supporters.php > > _______________________________________________ > > DbForms Mailing List > > > http://www.wap-force.net/dbforms > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > SourceForge.net hosts over 70,000 Open Source Projects. > See the people who have HELPED US provide better services: > Click here: http://sourceforge.net/supporters.php > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > -- NEU F�R ALLE - GMX MediaCenter - f�r Fotos, Musik, Dateien... Fotoalbum, File Sharing, MMS, Multimedia-Gru�, GMX FotoService Jetzt kostenlos anmelden unter http://www.gmx.net +++ GMX - die erste Adresse f�r Mail, Message, More! +++ ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
