I think this is a Javascript question and i have posted this question in ASP forum my mistakenly.
I am creating an application for official use. This application will be used by employees to take items for official use.
I have a list, presently this list contains three items -
1) Cartridges,
2) Floppy,
3) CD
Note : If a user selects Cartridges then list of printer should display,
And if floppy or CD is selected, then 'purpose' text item should display.
And many many more,
I am got entangled in this problem that how to display list when cartridge is selected and then how to display 'purpose' text item when floppy or cd is selected.
User has choice to select more than one item. If any item is selected, then this item is displayed in a another box. All the selected items are displayed in this box.
My problem is only how to do list item based display of input text.
Thanks and regards,
Vikas
45  2520  
Hi Vikas I give u a example which matches ur criteria from that u just write ur own code.
[HTML]<html>
<head>
<script type="text/javascript">
function doThis()
{
var sel = document.getElementById('mySelect1').selectedIndex ;
// alert(sel);
if(sel==0)
document.getElementById('myDiv').innerHTML="You selected an Apple";
else if(sel==1)
document.getElementById('myDiv').innerHTML="You selected an Orange";
else if(sel==2)
document.getElementById('myDiv').innerHTML="You selected an Mango";
else if(sel==3)
document.getElementById('myDiv').innerHTML="You selected an Grape";
else
document.getElementById('myDiv').innerHTML="You selected an Pine";
}
</script>
</head>
<table>
<tr>
<td>
<select id="mySelect1" size="10" onclick="doThis()">
<option>Apple</option>
<option>Orange</option>
<option>Mango</option>
<option>Grape</option>
<option>Pine</option>
</select>
</td>
<td>
<div id="myDiv">
</div>
</td>
</tr>
</table>
</html>[/HTML]
If any doubts post it back I will try to help u out
Regards
Ramanan Kalirajan
Thanks for very quick response.
I think this example will suit me best. I shall try my best
OK thanks again.
Vikas
Thanks for very quick response.
I think this example will suit me best. I shall try my best
OK thanks again.
Vikas
Ok. No Probs. All the best. If u struck up. pls post it to the forum. I will try to help u out.
Regards
Ramanan Kalirajan
Yes I have done it.
But I can't display input box and
list box which is created dynamically from table.
Yes I have done it.
But I can't display input box and
list box which is created dynamically from table.
Sorry Yaar, I can't get your requirement. In the place of displaying some text u want to display a input box or an list box. Is this your requirement.
Regards
Ramanan Kalirajan
Yes!!! you are right.
For that case u have to go for DOM. You can create an element dynamically, using document.createElement('input'); likewise u can do. If u want I can give u an example for that, which matches ur requirement otherwise surf w3schools to know about it.
Regards
Ramanan Kalirajan
DOM!!!! ?
Document Object Model !!!
How ???
Is it easy to use DOM?
Help !!!
Vikas
I have studied some DOM element but not able to use it.
I am sorry Vikas. Just go through this code if it is useful then no problem otherwise I can give u some other idea
[HTML]<html>
<head>
<script type="text/javascript">
function doThis()
{
var oDiv = document.getElementById('myDiv');
var el = document.createElement('input');
el.type="text";
var sel = document.getElementById('mySelect1').selectedIndex ;
// alert(sel);
if(sel==0)
el.value="I Selected Aplled";
else if(sel==1)
el.value="You selected an Orange";
else if(sel==2)
el.value="You selected an Mango";
else if(sel==3)
el.value="You selected an Grape";
else
el.value="You selected an Pine";
oDiv.appendChild(el);
oDiv.innerHTML=oDiv.innerHTML;
}
</script>
</head>
<table>
<tr>
<td>
<select id="mySelect1" size="10" onclick="doThis()">
<option>Apple</option>
<option>Orange</option>
<option>Mango</option>
<option>Grape</option>
<option>Pine</option>
</select>
</td>
<td>
<div id="myDiv">
</div>
</td>
</tr>
</table>
</html>[/HTML]
Once again I am sorry. Pls let me know you are satisfied with this otherwise I am having an another Idea. If u want i can give u that.
Regards
Ramanan Kalirajan
acoder 16,027
Recognized Expert Moderator MVP
Just a note that this: - var sel = document.getElementById('mySelect1').selectedIndex;
-
// alert(sel);
-
if(sel==0)
-
document.getElementById('myDiv').innerHTML="You selected an Apple";
-
else if(sel==1)
-
document.getElementById('myDiv').innerHTML="You selected an Orange";
-
else if(sel==2)
-
document.getElementById('myDiv').innerHTML="You selected an Mango";
-
else if(sel==3)
-
document.getElementById('myDiv').innerHTML="You selected an Grape";
-
else
-
document.getElementById('myDiv').innerHTML="You selected an Pine";
-
can be replaced by - var selObj = document.getElementById('mySelect1');
-
var val = selObj.options[selObj.selectedIndex].text;
-
document.getElementById('myDiv').innerHTML="You selected " + val;
or if you set the values of the options: - var val = document.getElementById('mySelect1').value;
-
document.getElementById('myDiv').innerHTML="You selected " + val;
Just a note that this:
- var sel = document.getElementById('mySelect1').selectedIndex;
-
// alert(sel);
-
if(sel==0)
-
document.getElementById('myDiv').innerHTML="You selected an Apple";
-
else if(sel==1)
-
document.getElementById('myDiv').innerHTML="You selected an Orange";
-
else if(sel==2)
-
document.getElementById('myDiv').innerHTML="You selected an Mango";
-
else if(sel==3)
-
document.getElementById('myDiv').innerHTML="You selected an Grape";
-
else
-
document.getElementById('myDiv').innerHTML="You selected an Pine";
-
can be replaced by - var selObj = document.getElementById('mySelect1');
-
var val = selObj.options[selObj.selectedIndex].text;
-
document.getElementById('myDiv').innerHTML="You selected " + val;
or if you set the values of the options:
- var val = document.getElementById('mySelect1').value;
-
document.getElementById('myDiv').innerHTML="You selected " + val;
Hi Mr. Acoder, I suggested hime this way first, but his requirement he want that text to be displayed in an Input Text box which should be dynamically created. That's why I have done like this.
Regards
Ramanan Kalirajan
acoder 16,027
Recognized Expert Moderator MVP
OK, your altered code could still be made more efficient. This: - var sel = document.getElementById('mySelect1').selectedIndex;
-
if(sel==0)
-
el.value="I Selected Aplled";
-
else if(sel==1)
-
el.value="You selected an Orange";
-
else if(sel==2)
-
el.value="You selected an Mango";
-
else if(sel==3)
-
el.value="You selected an Grape";
-
else
-
el.value="You selected an Pine";
-
could be changed to: - var selObj = document.getElementById("mySelect1");
-
var val = selObj.options[selObj.selectedIndex].text;
-
el.value = val;
Not only is the code shorter, if you add another option, you don't have to make any changes.
OK, your altered code could still be made more efficient. This:
- var sel = document.getElementById('mySelect1').selectedIndex;
-
if(sel==0)
-
el.value="I Selected Aplled";
-
else if(sel==1)
-
el.value="You selected an Orange";
-
else if(sel==2)
-
el.value="You selected an Mango";
-
else if(sel==3)
-
el.value="You selected an Grape";
-
else
-
el.value="You selected an Pine";
-
could be changed to: - var selObj = document.getElementById("mySelect1");
-
var val = selObj.options[selObj.selectedIndex].text;
-
el.value = val;
Not only is the code shorter, if you add another option, you don't have to make any changes.
Thank You for the suggestion, Mr. Acoder I will improve myself.
Regards
Ramanan Kalirajan
Here each option can have different prompt message. So I think, this is better way to move ahead.
According to my application, if user select 'Cartridge', then it should display all printers available in his department i.e. any user(employee) in a department can request for cartridge. If other options like ('Floppy' or 'CD') selected then only input textbox for the 'Purpose' field should display.
Can I display listbox of printer or input box according to user selection.
Thanks and regards,
Vikas
I am sorry Vikas. Just go through this code if it is useful then no problem otherwise I can give u some other idea
[HTML]<html>
<head>
<script type="text/javascript">
function doThis()
{
var oDiv = document.getElementById('myDiv');
var el = document.createElement('input');
el.type="text";
var sel = document.getElementById('mySelect1').selectedIndex ;
// alert(sel);
if(sel==0)
el.value="I Selected Aplled";
else if(sel==1)
el.value="You selected an Orange";
else if(sel==2)
el.value="You selected an Mango";
else if(sel==3)
el.value="You selected an Grape";
else
el.value="You selected an Pine";
oDiv.appendChild(el);
oDiv.innerHTML=oDiv.innerHTML;
}
</script>
</head>
<table>
<tr>
<td>
<select id="mySelect1" size="10" onclick="doThis()">
<option>Apple</option>
<option>Orange</option>
<option>Mango</option>
<option>Grape</option>
<option>Pine</option>
</select>
</td>
<td>
<div id="myDiv">
</div>
</td>
</tr>
</table>
</html>[/HTML]
Once again I am sorry. Pls let me know you are satisfied with this otherwise I am having an another Idea. If u want i can give u that.
Regards
Ramanan Kalirajan
Is there a future in learning DOM?
Should I learn DOM?
For that case u have to go for DOM. You can create an element dynamically, using document.createElement('input'); likewise u can do. If u want I can give u an example for that, which matches ur requirement otherwise surf w3schools to know about it.
Regards
Ramanan Kalirajan
Here is the problem that I can not display different prompt message for each options. Can I?
Thanks and regards,
Vikas
OK, your altered code could still be made more efficient. This:
- var sel = document.getElementById('mySelect1').selectedIndex;
-
if(sel==0)
-
el.value="I Selected Aplled";
-
else if(sel==1)
-
el.value="You selected an Orange";
-
else if(sel==2)
-
el.value="You selected an Mango";
-
else if(sel==3)
-
el.value="You selected an Grape";
-
else
-
el.value="You selected an Pine";
-
could be changed to: - var selObj = document.getElementById("mySelect1");
-
var val = selObj.options[selObj.selectedIndex].text;
-
el.value = val;
Not only is the code shorter, if you add another option, you don't have to make any changes.
Is there a future in learning DOM?
Should I learn DOM?
See whatever you learn surely it will help you at any apoint of time. If u learn DOM you will be able to create dynamic objects in HTML. Ok did u got the result i.e. are u finished up with ur work
Regards
Ramanan Kalirajan
Ok, thanks
I am still struggling for solution. I one step behind the solution.
Here each option can have different prompt message. So I think, your suggestion is better way to move ahead.
According to my application, if user select 'Cartridge', then it should display all printers available in his department i.e. any user(employee) in a department can request for cartridge. If other options like ('Floppy' or 'CD') selected then only input textbox for the 'Purpose' field should display.
Can I display listbox of printer or input box according to user selection.
Thanks and regards
Vikas
See whatever you learn surely it will help you at any apoint of time. If u learn DOM you will be able to create dynamic objects in HTML. Ok did u got the result i.e. are u finished up with ur work
Regards
Ramanan Kalirajan
Ok, thanks
I am still struggling for solution. I one step behind the solution.
Here each option can have different prompt message. So I think, your suggestion is better way to move ahead.
According to my application, if user select 'Cartridge', then it should display all printers available in his department i.e. any user(employee) in a department can request for cartridge. If other options like ('Floppy' or 'CD') selected then only input textbox for the 'Purpose' field should display.
Can I display listbox of printer or input box according to user selection.
Thanks and regards
Vikas
Surely u can do that. But I give u another logic that would be usefil to you. Rather than confusing yourself more. Look over this code this may be useful for you
[HTML]<html>
<head>
<script type="text/javascript">
function doThis()
{
var sel = document.getElementById('mySelect1').selectedIndex ;
// alert(sel);
if(sel==0)
{
document.getElementById('myText').style.display='n one';
document.getElementById('mySelect2').style.display ='block';
}
else if(sel==1)
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='b lock';
document.getElementById('myText').value="This is a secondary storage device";
}
else
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='b lock';
document.getElementById('myText').value="You can write in this";
}
}
function hideThis()
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='n one';
}
</script>
</head>
<body onload="hideThis()">
<table>
<tr>
<td>
<select id="mySelect1" size="10" onclick="doThis()">
<option>Printer</option>
<option>CD or Floppy</option>
<option>paper</option>
</select>
</td>
<td>
<div>
<select id="mySelect2" size="10" onclick="doThis()">
<option>Epson</option>
<option>Sony</option>
<option>LG</option>
<option>HP</option>
</select>
<input type="text" id="myText">
</div>
</td>
</tr>
</table>
</body>
</html>[/HTML]
Pls post back still u have problem
Regards
Ramanan Kalirajan
Yes, this code suits me very much as per my requirement. When I select 'Printer', a list box is displayed and when I select 'Floppy', an input box is displayed and so on.
But I have to modify the some portion near line no. 81 because prompt message remains the same i.e. 'PRINTER IS NO.'. This does not changes, so I think I should write the line no. from 81 to 91 between <div> tags.
Am I correct? If not then how?.
Now this is my code. - <script type="text/javascript">
-
-
function doThis() {
-
var sel = document.getElementById('myselect1').selectedIndex;
-
if (sel==1) {
-
document.getElementById('myText').style.display='none';
-
document.getElementById('mySelect2').style.display='block';
-
}
-
else if(sel==2) {
-
document.getElementById('mySelect2').style.display='none';
-
document.getElementById('myText').style.display='block';
-
}
-
else if(sel==3) {
-
document.getElementById('mySelect2').style.display='none';
-
document.getElementById('myText').style.display='block';
-
}
-
else {
-
document.getElementById('mySelect2').style.display='none';
-
document.getElementById('myText').style.display='none';
-
}
-
}
-
-
function hideThis() {
-
document.getElementById('mySelect2').style.display='none';
-
document.getElementById('myText').style.display='none';
-
}
-
</script>
-
-
<html>
-
-
<head>
-
<title>Welcome to Computer Consumable Requisition Application</title>
-
<style Type="text/css">
-
A{Color:Black; Font-Size:8pt}
-
</style>
-
</head>
-
<body Bgcolor="#66cdaa" Topmargin="5" onload="hideThis()">
-
-
<div align="center"><center>
-
<table Border="0" width="709">
-
<tr>
-
<td Align="center" Valign="middle" width="76"><img Src="Pp2.gif" width="74" height="79"/></td>
-
<td Align="center" Valign="middle" width="625">
-
<font size="4"><strong><u>OIL REFINERY(IS Department)</u></strong></font><br>
-
<font size="3" color="#FF0000"><strong><u>Consumables Requisition Form</u></strong></font>
-
</td>
-
</tr>
-
</table>
-
</center></div>
-
-
<form Method="POST" Action="main.asp" Name="myform">
-
<table CellSpacing="0" Width="98%" Border="0">
-
<tr>
-
<td width="18%">Employee Number: </td>
-
<td width="22%"><b><u><%Response.Write(Session("UserEmpNo"))%></u></b></td>
-
<td width="12%">Name: </td>
-
<td width="28%">
-
<b><u>
-
<% set rsname=conn.execute("select name from m_fix_employee where empno='"& Session("UserEmpNo") &"'")
-
Response.Write(rsname(0)) %>
-
</u></b>
-
</td>
-
</tr>
-
<tr>
-
<td width="18%" colspan="4"><img src="line.gif" width="747" height="3" alt="line.gif (1558 bytes)"/></td>
-
</tr>
-
</table>
-
<table CellSpacing="0" Width="98%" Border="0">
-
<tr>
-
<th Width="8%" Valign="Middle">Item:</th>
-
<td Width="15%">
-
<select Id="myselect1" Size="1" onclick="doThis()">
-
<option Selected Value=0>Select Item</option>
-
<% Set RSITEM = CON.EXECUTE("SELECT * FROM CONSUM_ITEMS ORDER BY Item_code")
-
Do While Not RSITEM.EOF %>
-
<option Value="<%=RSITEM("Item_code")%>"><%=RSITEM("Item_desc")%></option>
-
<% RSITEM.MoveNext
-
Loop %>
-
</select>
-
</td>
-
<th Width="25%" align="right" Valign="Middle">Printer IS No:</th>
-
<td Width="20%">
-
<select Id="mySelect2" Size="1" onclick="doThis()" >
-
<option Selected Value="NA">Select Printer</option>
-
<% While Not RSISNO.EOF %>
-
<option Value="<%=RSISNO("MIS_No")%>"><%=RSISNO("MIS_No")%></option>
-
<% RSISNO.MoveNext
-
Wend %>
-
</select>
-
<input type="text" id="myText" name="myText"/>
-
</td>
-
<th Width="13%" Valign="Middle">Quantity:</th>
-
<td Width="5%"><input Type="Text" Name="SEL_QTY" Size="3" Value="01"/></td>
-
<td height="30"><input Type="submit" Name="ActionCh" Value="Add" style="width:50px "/></td>
-
</tr>
-
</table>
-
</body
-
</html>
Hello Sir, I am not able to follow your code us u had included some scriptlet also. But one thing in the mySelect2 i.e. (on line No: 83) in the second select why you are using onclick="doThis()" I am not getting that point. Please look over that. wether Onselect of the second select tag any other different function to be triggered.
Regards
Ramanan Kalirajan
But now I got the complete solution, I created two seperate div, one for listbox and second for input box, And then I displayed the div as the technique given by you in place of myText and mySelect.
Thanks for cooperation,
Thanks and regards,
Vikas
Hello Sir, I am not able to follow your code us u had included some scriptlet also. But one thing in the mySelect2 i.e. (on line No: 83) in the second select why you are using onclick="doThis()" I am not getting that point. Please look over that. wether Onselect of the second select tag any other different function to be triggered.
Regards
Ramanan Kalirajan
My modified code is given below
But now I got the complete solution, I created two seperate div, one for listbox and second for input box, And then I displayed the div as the technique given by you in place of myText and mySelect.
Thanks for cooperation,
Thanks and regards,
Vikas
Congratulations Sir, In future any probs pls post it in the forum. I will be there trying to help you out.
Regards
Ramanan Kalirajan
I am very very happy and in relaxed mood now.
Thanks very much
Vikas
Congratulations Sir, In future any probs pls post it in the forum. I will be there trying to help you out.
Regards
Ramanan Kalirajan
One more solution I need.
At present, the solved problem is that
*when I select 'Cartridge' then list of printer is displayed.
*when I select 'Floppy' then input textbox is displayed.
And so on.
Now there is one more requirement.
*when I select 'Cartridge' then list of printer is displayed.
*when I select a printer from list, then a cartridge list is displayed.
[As you know every printer has a cartridge no. which is used by specific printer only, some printer uses 1 cartridge, some uses 2 cartridges and other uses 4 cartridges. To create a list I have cartridge_master table. It contains printer model and cartridge name and color.]
*when I select 'Floppy' then input textbox is displayed.
And so on.
My requirement is changed slightly that when a printer is selected, then a list of cartridge should be displayed.
To solve this problem, I tried to use AJAX technique, but fails. It displays all list and textbox without any condition which was working fine without using AJAX.
How can I do this?
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
I have added this code in between <script type="text/javascript"> and </script> of the above displayed programme. Line no. 27-52 is an AJAX code and line no.114 is calling this function. -
<script type="text/javascript">
-
function doThis() {
-
var sel = document.getElementById('myselect1').selectedIndex;
-
if (sel==1) {
-
document.getElementById('selectdiv').style.display='block';
-
document.getElementById('inputdiv').style.display='none';
-
}
-
else if(sel==2) {
-
document.getElementById('selectdiv').style.display='none';
-
document.getElementById('inputdiv').style.display='block';
-
}
-
else if(sel==3) {
-
document.getElementById('selectdiv').style.display='none';
-
document.getElementById('inputdiv').style.display='block';
-
}
-
else {
-
document.getElementById('selectdiv').style.display='none';
-
document.getElementById('inputdiv').style.display='none';
-
}
-
}
-
-
function hideThis() {
-
document.getElementById('selectdiv').style.display='none';
-
document.getElementById('inputdiv').style.display='none';
-
}
-
- function Cartridge(str) {
-
xmlHttp=GetXmlHttpObject();
-
if (xmlHttp==null) {
-
alert ("Your browser does not support AJAX!");
-
return;
-
}
-
var url="getCartridge.asp?q="+str+"&sid="+Math.random();
-
xmlHttp.onreadystatechange=stateChanged;
-
xmlHttp.open("GET",url,true);
-
xmlHttp.send(null);
-
}
-
-
function stateChanged() {
-
if (xmlHttp.readyState==4)
-
document.getElementById("selectdiv").innerHTML=xmlHttp.responseText;
-
}
-
-
function GetXmlHttpObject() {
-
var xmlHttp=null;
-
try { xmlHttp=new XMLHttpRequest(); } //Firefox,Opera 8.0+, Safari
-
Catch(e) {
-
try {xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");} //Internet Explorer
-
catch (e) {xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");}
-
}
-
return xmlHttp;
-
}
-
</script>
-
-
<html>
-
-
<head>
-
<title>Welcome to Computer Consumable Requisition Application</title>
-
<style Type="text/css">
-
A{Color:Black; Font-Size:8pt}
-
</style>
-
</head>
-
<body Bgcolor="#66cdaa" Topmargin="5" onload="hideThis()">
-
-
<div align="center"><center>
-
<table Border="0" width="709">
-
<tr>
-
<td Align="center" Valign="middle" width="76"><img Src="Pp2.gif" width="74" height="79"/></td>
-
<td Align="center" Valign="middle" width="625">
-
<font size="4"><strong><u>OIL REFINERY(IS Department)</u></strong></font><br>
-
<font size="3" color="#FF0000"><strong><u>Consumables Requisition Form</u></strong></font>
-
</td>
-
</tr>
-
</table>
-
</center></div>
-
-
<form Method="POST" Action="main.asp" Name="myform">
-
<table CellSpacing="0" Width="98%" Border="0">
-
<tr>
-
<td width="18%">Employee Number: </td>
-
<td width="22%"><b><u><%Response.Write(Session("UserEmpNo"))%></u></b></td>
-
<td width="12%">Name: </td>
-
<td width="28%">
-
<b><u>
-
<% set rsname=conn.execute("select name from m_fix_employee where empno='"& Session("UserEmpNo") &"'")
-
Response.Write(rsname(0)) %>
-
</u></b>
-
</td>
-
</tr>
-
<tr>
-
<td width="18%" colspan="4"><img src="line.gif" width="747" height="3" alt="line.gif (1558 bytes)"/></td>
-
</tr>
-
</table>
-
<div style="position:absolute; left:153px; top:140px">
-
<table cellspacing="0" cellpadding="0" border="0">
-
<tr>
-
<th align="left">Item:</th>
-
<td>
-
<select Id="myselect1" Size="1" onchange="doThis()">
-
<option Selected Value=0>Select Item</option>
-
<% Set RSITEM = CON.EXECUTE("SELECT * FROM CONSUM_ITEMS ORDER BY Item_code")
-
Do While Not RSITEM.EOF %>
-
<option Value="<%=RSITEM("Item_code")%>"><%=RSITEM("Item_desc")%></option>
-
<% RSITEM.MoveNext
-
Loop %>
-
</select>
-
</td>
-
</tr>
-
</table>
-
</div>
-
<div id='selectdiv' style="position:absolute; left:100px; top:180px ">
-
<th align="right" >Printer IS No:</th>
-
<td>
-
<select Id="mySelect2" Size="1" style="width:450px " onchange="Cartridge(this)" >
-
<!-- <option selected value="NA">Select Printer</option> -->
-
<% vmis_no=rsisno("mis_no")
-
while not rsisno.eof
-
if rsisno("mis_no")=vmis_no then%>
-
<option value="<%=rsisno("mis_no")%>" selected><%=rsisno("mis_no")%></option>
-
<% else %>
-
<option value="<%=rsisno("mis_no")%>"><%=rsisno("mis_no")%></option>
-
<% end if
-
rsisno.MoveNext
-
wend %>
-
</select>
-
</td>
-
<br><br>
-
<th>     Cartridge : </th>
-
<td>
-
<select id="cartridge" size="1" style="width:450px ">
-
<!-- <option selected value="NA">Select Cartridge</option> -->
-
<% set rsModel=conn1.execute("select c.modelcode modelcode, c.name model from pc_item_transaction_details a, pc_item_procurement_history b, pc_model_master c where a.item_code=b.item_code and a.lot_no=b.lot_no and b.modelcode=c.modelcode and a.mis_no='"&vmis_no&"'")
-
set rsCartridge = con.execute("select item_type, decode(color,'B','Black','C', 'Color', 'Y', 'Yellow', 'M', 'Magenta') color, make_model from cartridge_master where prn_sl_no="&rsModel("modelcode")&" order by prn_sl_no")
-
while not rsCartridge.eof %>
-
<option value="<%=rsCartridge("item_type")%>"><%=rsCartridge("item_type")%> , <%=rsCartridge("color")%> , <%=rsCartridge("make_model")%></option>
-
<% rsCartridge.movenext
-
wend %>
-
</select>
-
</td>
-
</div>
-
<div id='inputdiv' style="position:absolute; left:128px; top:180px ">
-
<th align="right">Purpose :</th>
-
<td>
-
<input type="text" id="myText" name="myText" style="width:450px "/>
-
</td>
-
</div>
-
-
<div style="position:absolute; top:260px; left:132px ">
-
<th>Quantity:</th>
-
<td><input Type="Text" Name="SEL_QTY" Size="3" Value="1"/></td>
-
<td><input Type="submit" Name="ActionCh" Value="Add" style="width:100px "/></td>
-
</div>
-
</form>
-
</body>
-
</html>
-
And code of getCartridge.asp is here -
<html>
-
<head>
-
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
-
</head>
-
-
<body>
-
<%
-
response.expires=-1
-
sql="select cartridge_master where item ='" & request.querystring("q") & "'"
-
-
set conn=Server.CreateObject("ADODB.Connection")
-
set conn1=Server.CreateObject("ADODB.Connection")
-
conn.open "Provider=MSDAORA.1; dsn=intr; Password=intr; User ID=intr; Data Source=intradb; Persist Security Info=True"
-
conn1.open "Provider=MSDAORA.1; dsn=otmon; Password=otmon; User ID=otmon; Data Source=intradb; Persist Security Info=True"
-
set rs = Server.CreateObject("ADODB.Recordset")
-
set rsisno = Server.CreateObject("ADODB.Recordset")
-
rs.Open sql, conn
-
set rsisno = conn1.execute("select mis_no from pc_item_transaction_details where empno in (select empno from otmon.ot_master where dept_cd=(select dept_cd from ot_master where empno='"&session("userempno")&"')) and item_code=31 and withdrawn_yn='N' ")
-
%>
-
<th align="right" >Printer IS No:</th>
-
<td>
-
<select Id="mySelect2" Size="1" style="width:450px " onclick="Cartridge(this)" >
-
<!-- <option selected value="NA">Select Printer</option> -->
-
<% vmis_no=request.querystring("q")
-
while not rsisno.eof
-
if rsisno("mis_no")=vmis_no then %>
-
<option value="<%=rsisno("mis_no")%>" selected><%=rsisno("mis_no")%></option>
-
<% else %>
-
<option value="<%=rsisno("mis_no")%>"><%=rsisno("mis_no")%></option>
-
<% end if
-
rsisno.MoveNext
-
wend %>
-
</select>
-
</td>
-
<br><br>
-
<th>     Cartridge : </th>
-
<td>
-
<select id="cartridge" size="1" style="width:450px ">
-
<!-- <option selected value="NA">Select Cartridge</option> -->
-
<% set rsModel=conn1.execute("select c.modelcode modelcode, c.name model from pc_item_transaction_details a, pc_item_procurement_history b, pc_model_master c where a.item_code=b.item_code and a.lot_no=b.lot_no and b.modelcode=c.modelcode and a.mis_no='"&vmis_no&"'")
-
set rsCartridge = con.execute("select item_type, decode(color,'B','Black','C', 'Color', 'Y', 'Yellow', 'M', 'Magenta') color, make_model from cartridge_master where prn_sl_no="&rsModel("modelcode")&" order by prn_sl_no")
-
while not rsCartridge.eof %>
-
<option value="<%=rsCartridge("item_type")%>"><%=rsCartridge("item_type")%> , <%=rsCartridge("color")%> , <%=rsCartridge("make_model")%></option>
-
<% rsCartridge.movenext
-
wend %>
-
</select>
-
</td>
-
-
</body>
-
</html>
-
Hello Sir, in the case of using Ajax, did you got any output in the Div. In the getCartridge.asp are you maintaing the list for the printers (i.e. cartidges). Can u please clearly explain your requirement
Regards
Ramanan Kalirajan
Hello Sir, in the case of using Ajax, did you got any output in the Div. In the getCartridge.asp are you maintaing the list for the printers (i.e. cartidges). Can u please clearly explain your requirement
Regards
Ramanan Kalirajan
Before using AJAX, my application was working fine.
i.e. When I select 'cartridge', a list of printer is displayed, and a default printer is select and a list of cartridge is displayed for default printer,
When I select 'floppy', an input textbox is displayed and so on.
I am using AJAX only to change cartridge list when I change printer. But after using AJAX, all are displayed simultaneously with out any selecting item.
When I remove AJAX technique procedure, all things work fine. The only pending job left is to change cartridge list when I change printer.
How to acheive ?
Thanks and regards,
Vikas
Before using AJAX, my application was working fine.
i.e. When I select 'cartridge', a list of printer is displayed, and a default printer is select and a list of cartridge is displayed for default printer,
When I select 'floppy', an input textbox is displayed and so on.
I am using AJAX only to change cartridge list when I change printer. But after using AJAX, all are displayed simultaneously with out any selecting item.
When I remove AJAX technique procedure, all things work fine. The only pending job left is to change cartridge list when I change printer.
How to acheive ?
Thanks and regards,
Vikas
Sir, once again this is my suggestion wether are u getting the cartridge from db or from any other external page, why you are going for Ajax. You can do it in the same way u did previously. When the printer is selected over there. Display another select based on the printer selected. If possible i would give a example for that. Pls reply me are u using any dynamic values for the cartridge.
Regards
Ramanan Kalirajan
Sir, once again this is my suggestion wether are u getting the cartridge from db or from any other external page, why you are going for Ajax. You can do it in the same way u did previously. When the printer is selected over there. Display another select based on the printer selected. If possible i would give a example for that. Pls reply me are u using any dynamic values for the cartridge.
Regards
Ramanan Kalirajan
All the data I am getting are from DB.
The first list i.e. Item contains 3 items, 'Cartridge', 'Floppy', 'CD'.
When I select 'Floppy' or 'CD' , an input textbox should display
When I select 'Cartridge', a listbox should display containing list of printers of employee's dept.
Upto this thing works fine. Now when an employee selects a printer, then a list of cartridge should display. To do this, I used AJAX technique. Else I don't have any idea for this. But programme goes to hell. How to achieve this?
Thanks and regards,
Vikas
Just check this code and reply me. wether is this what are u looking for
[HTML]<html>
<head>
<script type="text/javascript">
function doThis()
{
var sel = document.getElementById('mySelect1').selectedIndex ;
// alert(sel);
if(sel==0)
{
document.getElementById('myText').style.display='n one';
document.getElementById('mySelect2').style.display ='block';
doFinal();
}
else if(sel==1)
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='b lock';
document.getElementById('myText').value="This is a secondary storage device";
hideAll();
}
else
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='b lock';
document.getElementById('myText').value="You can write in this";
hideAll();
}
}
function doFinal()
{
var x = document.getElementById('mySelect2').selectedIndex ;
for(var i=0;i<4;i++)
{
ElId = "my"+(i+1);
if(i==x)
document.getElementById(ElId).style.display='block ';
else
document.getElementById(ElId).style.display='none' ;
}
}
function hideThis()
{
document.getElementById('mySelect2').style.display ='none';
document.getElementById('myText').style.display='n one';
hideAll();
}
function hideAll()
{
for(var i=0;i<4;i++)
{
ElId = "my"+(i+1);
document.getElementById(ElId).style.display='none' ;
}
}
</script>
</head>
<body onload="hideThis()">
<table>
<tr>
<td>
<select id="mySelect1" size="10" onclick="doThis()">
<option>Printer</option>
<option>CD or Floppy</option>
<option>paper</option>
</select>
</td>
<td>
<div>
<select id="mySelect2" size="10" onclick="doFinal()">
<option selected>Epson</option>
<option>Sony</option>
<option>LG</option>
<option>HP</option>
</select>
<input type="text" id="myText">
</div>
</td>
<td>
<div>
<select id="my1" size="10">
<option>Epson 200</option>
<option>Epson 210</option>
<option>InkJet 400</option>
<option>Laser 200</option>
</select>
<select id="my2" size="10">
<option>Sony Dot</option>
<option>Sony Color</option>
<option>Sony 400</option>
<option>Sony 200</option>
</select>
<select id="my3" size="10">
<option>LG 200</option>
<option>LG 210</option>
<option>LG 400</option>
<option>LG Color 200</option>
</select>
<select id="my4" size="10">
<option>HP 200</option>
<option>HP 210</option>
<option>HP 400</option>
<option>HP 200</option>
</select>
</div>
</td>
</tr>
</table>
</body>
</html>[/HTML]
Regards
Ramanan Kalirajan
Hi,
Here is no lists are fixed one. All list are dynamical and are retrieved from DB. This is the realy problem that how to retrieve the data for cartridge list when a printer is changed. As you know cartridge is based on printer model and each printer may uses 1 or more cartridges. Here I have cartridge master table which contains printer model name, cartridge name and color.
Now I am telling a procedure of programme.
Employee logs into this Consumable Programme by entering his employee no. in login screen, after this, a list is displayed having 3 items.
When a user select an item 'Cartridge', a printer list is displayed (one printer is made default selection) just beneath item list. And then a Cartridge list is displayed for the default printer just beneath printer list.
Upto here programe works fine. What I want is ....
Now this employee selects a different printer (If his dept. may have more than 1 printer) whose cartridge is required, then Cartridge list is should display cartridge of new selected printer.
This thing I am not able to do?
Thanks and regards,
Vikas
If thats the case, just pass the printer type to the input as the query and retrieve the values and store the values in an array. return the array to the javascript here u can populate a dynamic list with the array value as the option.
But passing it to the db and returning back u have to take care of it. It is possible with Ajax i think so. Just try like this, Have a JavaClass the work of that java class is to accept the printer as the rgument in that class retrieve the associated cartridge values from the db in an array and pass the array to the callback function. It may be quiet difficult I too try some method for this.
Regards
Ramanan Kalirajan
If thats the case, just pass the printer type to the input as the query and retrieve the values and store the values in an array. return the array to the javascript here u can populate a dynamic list with the array value as the option.
But passing it to the db and returning back u have to take care of it. It is possible with Ajax i think so. Just try like this, Have a JavaClass the work of that java class is to accept the printer as the rgument in that class retrieve the associated cartridge values from the db in an array and pass the array to the callback function. It may be quiet difficult I too try some method for this.
Regards
Ramanan Kalirajan
I have to use JavaClass!!!
Ok
I might try
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
No need to use a Java class. Any server-side code will do.
First get your server-side code working. Does the ASP page work without using Ajax?
No need to use a Java class. Any server-side code will do.
First get your server-side code working. Does the ASP page work without using Ajax?
Yes sir, ASP code work without AJAX.
acoder 16,027
Recognized Expert Moderator MVP
The problem is that in your code you're passing this (the select object) to the Cartridge function which is expecting a string. Pass this.value instead.
The problem is that in your code you're passing this (the select object) to the Cartridge function which is expecting a string. Pass this.value instead.
This will not going to solve problem. I have checked this already.
See, here what is happening is that all list items and input box are displayed simultaneously just after running the programme (with AJAX) which was otherwise displayed one by one as we select an item without using AJAX. Without using AJAX, program is working. But only problem is that cartridge list should change immediately when employee select a different printer from list. To do this I tried to use AJAX, but program goes to hell. How to achieve this job?
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
You're returning too much info. from getCartridge.asp. You only need to return the options for the cartridge select - that's it, basically the db connection code and lines 39-45, then in the JavaScript set the innerHTML of the cartridge select element only.
You're returning too much info. from getCartridge.asp. You only need to return the options for the cartridge select - that's it, basically the db connection code and lines 39-45, then in the JavaScript set the innerHTML of the cartridge select element only.
This I know, but I had put printer select list and cartridge select in one div id=selectdiv, thats why both info is used to pass. Else what can I do?
In post number 30, you can see my latest code.
Thanks and regards
You're returning too much info. from getCartridge.asp. You only need to return the options for the cartridge select - that's it, basically the db connection code and lines 39-45, then in the JavaScript set the innerHTML of the cartridge select element only.
Now I think that line no. 63 in post number 30 is not working with AJAX code.
i.e. - <body Bgcolor="#66cdaa" Topmargin="5" onload="hideThis()">
Thats why, on running program, all input textbox and listbox are displayed simultaneously with AJAX code which is not supposed to happen. But without using AJAX, the program works fine as well as line no. 63 in post number 30 also works.
Can any one tell me? I am struggling for solution for many days?
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
If you want to keep something hidden initially, there's no need for the onload call. Just set it to display:none in the style attribute:
[html]<div id='selectdiv' style="position:absolute; left:100px; top:180px; display:none;">[/html]and likewise for inputdiv.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: massimo |
last post by:
Hey,
I wrote this program which should take the numbers entered and sort them
out. It doesnąt matter what order, if decreasing or increasing.
I guess I'm confused in the sorting part. Anyone...
|
by: Rylios |
last post by:
I am trying to make a very basic text editor using a linked list,
fstream, sorting...
This is what i have so far...
|
by: vikas251074 |
last post by:
I am creating an application for official use. This application will be used by employees to take items for official use.
I have a list, presently this list contains three items -
1) Cartridges, ...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
