Java Forums

Main Menu
Home
Today's Posts
FAQ
Search
Contact Us

Java Network
Java Tips
Java Tips Blog

Sponsored Links





Welcome to the Java Forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:

  • have access to post topics
  • communicate privately with other members (PM)
  • not see advertisements between posts
  • have the possibility to earn one of our surprises if you are an active member
  • access many other special features that will be introduced later.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-03-2008, 01:41 PM
Member
 
Join Date: Apr 2008
Posts: 1
krazzie25 is on a distinguished road
Need help in JSP
Here is my problem.
What am i suppose to do if given this first drop menu:

<sql:query var="area">
SELECT NAME, COUNTRY, CODE FROM AREA ORDER BY NAME, COUNTRY
</sql:query>


<select name="from" size="1">
<c:forEach var="place" items="${area.rows}">
<option value="${place.code}">${place.name},
${place.country}</option>
</c:forEach>
</select>

the option are from database (let say table a) and this is the 2nd drop menu from table b,

<sql:query var="dest_area">
SELECT NAME, COUNTRY, CODE FROM AREA JOIN LENGTH ON AREA.CODE = LENGTH.DEST_CODE WHERE ORIG_CODE = '?problem?' ORDER BY NAME, COUNTRY
</sql:query>

<select name="to" size="1">
<c:forEach var="place" items="${dest_area.rows}">
<option value="${place.code}">${place.name},
${place.country}</option>
</c:forEach>
</select>

I want to filter the second menu from selected item from first menu.For example if user select 'a' from first menu then the second menu will list only 't' and 'r' on the 2nd menu..not list all value from database..what should i wrote at ?problem? in the sql query???need help plezzz.
Bookmark Post in Technorati
Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +3. The time now is 02:25 PM.


VBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright ©2006 - 2007, www.java-forums.org