g118481
asked on
How can I incorporate this 2nd query into my edit page?
I have a JSP page that performs an update to records in my db2 table. This page's record variables are populated with a query to my db2 table. The thing is, I need to query from a second table, in order to populate a dynamic drop down list.
How can I incorporate this 2nd query into my edit page?
How can I incorporate this 2nd query into my edit page?
ASKER
I was hoping to incorporate both queries into one.
but they are doing two separate things? why would you want to make them into one?
or is there something I'm missing?
Ghost
or is there something I'm missing?
Ghost
ASKER
ok, then give me an example of how to run two queries in the same edit form page.
In an edit page one must output the existing record variables for each text box, select box, etc. that is already in the record.
In the output of these in the form how do i break that output of variables and include the output of the 2nd query to the drop down list, as it is in the middle of the output of the variables of the 1st query?
In an edit page one must output the existing record variables for each text box, select box, etc. that is already in the record.
In the output of these in the form how do i break that output of variables and include the output of the 2nd query to the drop down list, as it is in the middle of the output of the variables of the 1st query?
load the queries into 2 different resultSets and then use them
That's what I what I would do
use one of the resultsets to fill in the text box, select box
and the other result set to load the drop down list
Cheers,
Ghost
That's what I what I would do
use one of the resultsets to fill in the text box, select box
and the other result set to load the drop down list
Cheers,
Ghost
ASKER
code example please
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
and what happens when the select list for query 2 is in the middle of your query 1 output?
???wha??
why would you do that..
have two different select statments.. one for the drop down and another for the rest of the stuff
Ghost
why would you do that..
have two different select statments.. one for the drop down and another for the rest of the stuff
Ghost
one for the update
and one to populate the drop down
Ghost