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
