How to display data in textbox

[ma-la]

I want to fetch data from mysql and display in textbox when I click the corresponding item in listbox. I used SQL JSTL to fetch data for listbox. Please help me how to display data in textbox?

[rangana]

You can use the value method available on the textbox element.

Please show us the generated markup of your listbox (select element) so we could help you have a script of your desire.

[ma-la]

My listbox has some product names
LG
Sanyo
like this
When I click LG item in listbox corresponding data should be displayed in the textbox

I tried

<input style="WIDTH: 83px; HEIGHT: 23px" size="10" name="Quantity">
<c:forEach var="row" items="${list.rows}">
<c:set var="quantity ">"{row.quantity }"
</c:set>
<option>
<c:out value="{row.quantity }"/>
</option>
</c:forEach>

All datas are displayed.But I want to display one data. Please help me

[rangana]

Please show the generated markup.

The one that you see when you view the source.

[ma-la]

I am not getting what you are asking

I used

<sql:query var="list" dataSource="${dataSource}">
select user_id,name,sum(quantity) as quantity from Product GROUP BY name;
</sql:query>

I have Name Listbox and quantity textbox

The values are displayed as 200,400,800..outside the textbox

I want to display the corresponding value in the textbox when I click the name in the listbox

Please help

[rangana]

The code you're showing is a server-side script (or better yet a raw file).

I'm asking for the generated markup.

The one you see when you view the page's source.

Hope that makes sense.

[ma-la]

<table cellspacing="0" cellpadding="3" width="40%" align="left" border="0">

<tr>
<td>&nbsp; Stock Code</td>
<td><select size="1" name="name">

<option>
LG
</option>


<option>
Samsung
</option>


<option>
Sony
</option>




</select></td></tr>
<tr>
<td>&nbsp; Quantity</td>
<td><input style="WIDTH: 83px; HEIGHT: 23px" size="10" name="Quantity">



<option>
20200
</option>



<option>
12000
</option>



<option>
200
</option>





</td>
</tr>

[rangana]

I see. You're second select element is erroneous.

You should contain option element inside select element:

Code: Select all

<option>
20200
</option>



<option>
12000
</option>



<option>
200
</option>


Which of the two select element are you wanting its selectedIndex texts be shown on the textbox?

[ma-la]

I don't want to list all quantity data in the listbox. If I use option inside select ,all values will be listed in the listbox.

[rangana]

That doesn't makes sense.

Anyway, how about a response to my question?