Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-04-28
9
Medium Priority
?
154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 400 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
Let's take a look into the basics of ransomware—how it spreads, how it can hurt us, and why a disaster recovery plan is important.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

609 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