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
