
I am getting one value by JSON array, but how can i store multiple values in json array and how can i retieve it by javascript? Any help please
auto.jsp
<script type="text/javascript">
$(document).ready(function() {
$("#combo").change(function() {// after onchange event it goes to combo1.jsp
$.getJSON('combo1.jsp', {count : this.value}, function(responseData) {
var splitValues = responseData.name.split(/,/);
$("#combo1").empty().append ("<option>please select</option>");
for (var idx in splitValues) {
$("#combo1").append(
$("<option></option>").html(splitValues[idx]).val(splitValues[idx])
);
}
});
});
});
</script>
<body>
//first combo box
<select id="combo" name="count">
<option value="">please select</option>
<option value="a">A</option>
</select>
//second combo box
<select id="combo1" name="combo1Val">
// i am getting only "5" here, but i want to show 1,2,3,4,5 as in drop down list
</select>
</body>
combo1.jsp
<%
String count=request.getParameter("count");// by onchange event of first combo, i am
getting value "a" here
if(count.equalsIgnoreCase("a")){
// in my db there are 5 values i.e. 1,2,3,4,5 for single value "a", but while
populating in second combo i am getting only one value "5", how? please ignore my db
connection in jsp
JSONObject arrayObj= new JSONObject();
// by db connection i am fetching 5 values but while printing in javascript i am
getting only last one that is "5" in second combo, how can i populate all values
1,2,3,4,5 as drop down items in second combo box?
// retrieveing 5 datas(1,2,3,4,5) from db where name =a
while(rs.next()){
t1=(String)(rs.getString(1));// there are 5 values in db relating to "a", but i
am getting only last value i.e. "5" in second combo
}
arrayObj.put("name",t1);
response.setContentType("application/json");
response.getWriter().write(arrayObj.toString());
}
%>

Please visit the following links:
http://www.roseindia.net/tutorials/json/ArrayObject-json.shtml
http://www.roseindia.net/tutorials/json/json-javascriptObject.shtml
http://www.roseindia.net/tutorials/json/json-javascriptObject.shtml
http://www.roseindia.net/tutorials/json/parse-message-JSON-JS.shtml
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.