Have a look at the tag lib docu for the name attribute:

name an arbitrary id declared by the user - this id is useful, if the same
data should be used more than once at one jsp page. using this unique name
the system is able to chache the data 


Just change the name of your fields so that data will not be cached.

Regards,
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

Reply via email to