You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by chuck amadi <ch...@breconbeacons.org> on 2002/05/10 16:53:42 UTC

Dbtags - Multiply inserts within a jsp (two at least)

Hi there , using DBTags can one write multiply insert statements to a 
database within the same jsp page.

As i need to populate a concatenated table with a Primary and Foreign key.
Thus within a select statement i can call a set of data that refers to 
two different tables.

ie i have a volunteer members table and a next of kin table but due to 
the size and number of columns in the  members table need a assoicate 
value .

Thus i am aware of the joins (command line) etc but i need to call from 
a jsp page using the select statement element. And thus view or access 
two tables or if not can  i create a concatenated table with a PK and FK 
value that obviously has value from the two tables in question.

Any ideas

Cheers Chuck Amadi
Systems Programmer
Rhaglennydd Systemau



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>