Solved

How can I incorporate this 2nd query into my edit page?

Posted on 2004-04-28
9
148 Views
Last Modified: 2010-04-01
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?
0
Comment
Question by:g118481
  • 5
  • 4
9 Comments
 
LVL 13

Expert Comment

by:copyPasteGhost
ID: 10942731
just make 2 querys..
one for the update
and one to populate the drop down
Ghost
0
 
LVL 1

Author Comment

by:g118481
ID: 10948227
I was hoping to incorporate both queries into one.
0
 
LVL 13

Expert Comment

by:copyPasteGhost
ID: 10948773
but they are doing two separate things? why would you want to make them into one?
or is there something I'm missing?
Ghost
0
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
LVL 1

Author Comment

by:g118481
ID: 10949062
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?
0
 
LVL 13

Expert Comment

by:copyPasteGhost
ID: 10949548
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
0
 
LVL 1

Author Comment

by:g118481
ID: 10951568
code example please
0
 
LVL 13

Accepted Solution

by:
copyPasteGhost earned 100 total points
ID: 10951664
rs = statm.executeQuery(sqlQueryString);
rs2 = statm.executeQuery(sqlQueryString2);

if(rs.next()) {
int count =1;
do {
  out.println("record " + count + " value " + rs.getString(1));
  count++;
}while(rs.next());

you can do what you want with the results from the resultset
same idea for the rs2

if(rs2.next()) {
out.print("<select name='selectBox'>");
do {
  out.println("<option name='" + rs.getString(1) + "' value='" + rs.getString(1) + "' />";
}while(rs.next());
out.print("</select>");

hope that helps,
Ghost
0
 
LVL 1

Author Comment

by:g118481
ID: 10952036
and what happens when the select list for query 2 is in the middle of your query 1 output?
0
 
LVL 13

Expert Comment

by:copyPasteGhost
ID: 10952312
???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
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
attribute vs parameter and setter vs add method 17 89
Struts tiles for layout structure along with Angular JS. 4 172
iterator example remove 8 75
Java Script nested call 3 87
If you are looking at this article, you have most likely been hit by some version of ransomware and are trying to find out if there is anything you can do, or what way you should react - READ ON!
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question