I have create form as below - - <table>
-
<tr>
-
<td align="right">VLAN Name : </td>
-
<td>
-
<select name="vlan_name" style="width:150px ">
-
<% set rs = conn.execute("select vlan_name from vlan_master order by vlan_name")
-
do while not rs.eof%>
-
<option value="<%=rs("vlan_name")%>"><%=rs("vlan_name")%></option>
-
<% rs.movenext
-
loop%>
-
</select>
-
</td>
-
</tr>
-
<tr>
-
<td align="right">Item : </td>
-
<td>
-
<select name="item" style="width:150px ">
-
<% set rs = conn.execute("select item, item_desc from network_item order by item_desc")
-
do while not rs.eof
-
if rs("item") = "PC" then%>
-
<option value="<%=rs("item")%>" selected><%=rs("item_desc")%></option>
-
<% else%>
-
<option value="<%=rs("item")%>"><%=rs("item_desc")%></option>
-
<% end if
-
rs.movenext
-
loop%>
-
</select>
-
</td>
-
</tr>
-
<tr>
-
<td align="right">IP Address : </td>
-
<td align="left"><input type="text" name="ip_address" style="width:150px "/></td>
-
</tr>
-
<tr>
-
<td align="right">MIS No : </td>
-
<td>
-
<select name="mis_no" style="width:250px ">
-
<% set rs = conn.execute("select a.mis_no, a.seq_no, a.lot_no, b.item_description from item_procurement_history_dtl a, item_master b where a.status = 'D' and b.item_code = a.item_code order by a.item_code, substr(mis_no, instr(mis_no, '/', -1)+1)")
-
do while not rs.eof%>
-
<option value="<%=rs("mis_no")%>"><%=rs("mis_no")%></option>
-
<% rs.movenext
-
loop%>
-
</select>
-
</td>
-
</tr>
-
<tr>
-
<td align="right">Employee name : </td>
-
<td align="left"><input type="text" name="emp_name" style="width:300px "/></td>
-
</tr>
-
</table>
I am using two table 1) Item_master and 2) IP_Address.
The field of IP_Address is given below
1) Item, IP_Address, EmpName
Here Item and IP_Address field is filled with fixed set of ip addresses and item. And if any ip address is assigned to anybody , then empname is filled, if ip address is released then empname field against that ip address is deleted.
If user select Computer in Item field, then the second field IP Address should be display the first available ip address from table automatically. How can I achieve this?
Thanks and regards,
Vikas
17  2773  acoder 16,027
Recognized Expert Moderator MVP
Note first of all that JavaScript cannot connect to the database directly.
You have two ways (at least) in which you can do this:
1. set all the IP address values in an array using ASP during page load. In the select onchange, you can check which value matches and display the corresponding IP.
2. Use Ajax to connect to the database using an ASP script which returns the IP address to display in the text box.
I will prefer to use 2nd method.
Please give me the code for connection to the oracle database. I know very little about AJAX. I shall oblige you sir
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP Here's a quick example to get you started. Also check out some of the links in the Offsite Links sticky thread at the top of this forum for some useful beginner tutorials.
To study ajax, I try following code -
This file name is 'ajax.asp'. It has 3 fix list value. When I select a value, it displays details of value. It used a script named 'selectcustomer .js' of which coding is given below this programme. - <html>
-
<head>
-
<script src="selectcustomer.js"></script>
-
</head><body><form>
-
Select a Customer:
-
<select name="customers" onchange="showcustomer(this.value)">
-
<option value="66788">Sanjay Pandey
-
<option value="71955">Asis Das
-
<option value="77581">T.A. Sazid
-
</select>
-
</form><p>
-
<div id="txtHint"><b>Customer info will be listed here.</b></div>
-
</p></body>
-
</html>
This file name is 'selectcustomer .js' - <%
-
var xmlHttp
-
-
function showcustomer(str){
-
xmlHttp=GetXmlHttpObject();
-
if (xmlHttp==null) {
-
alert ("Your browser does not support AJAX!");
-
return;
-
}
-
var url="getcustomer.asp";
-
url=url+"?q="+str;
-
url=url+"&sid="+Math.random();
-
xmlHttp.onreadystatechange=stateChanged;
-
xmlHttp.open("GET",url,true);
-
xmlHttp.send(null);
-
}
-
-
function stateChanged() {
-
if (xmlHttp.readyState==4)
-
{ document.getElementById("txtHint").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;
-
}
-
%>
This file name is 'getcustomer.as p' -
<html>
-
<head>
-
</head>
-
<%
-
response.expires=-1
-
sql="SELECT * FROM hba_empmast where empno="
-
sql=sql & "'" & request.querystring("q") & "'"
-
-
set conn=Server.CreateObject("ADODB.Connection")
-
conn.open "Provider=MSDAORA.1; dsn=ipis; Password=ipis; User ID=ipis; Data Source=isap2000; Persist Security Info=True"
-
set rs = Server.CreateObject("ADODB.Recordset")
-
rs.Open sql, conn
-
-
response.write("<table>")
-
do until rs.EOF
-
for each x in rs.Fields
-
response.write("<tr><td><b>" & x.name & "</b></td>")
-
response.write("<td>" & x.value & "</td></tr>")
-
next
-
rs.MoveNext
-
loop
-
-
response.write("</table>")
-
%>
-
<body>
-
</body>
-
</html>
-
Here problem is that when I select a value from list. details of that value is not displayed. The error message is 'object required' in line no. 6 of 'ajax.asp'.
Thanks and regards,
Vikas
When the content of selectcustomer. js is copied to ajax.asp within <script type="text/javascript"> tag then it display the details on selecting a value. But why not programme run earlier. Can u explain. me?
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
I would guess the problem would be the ASP tags <% and %> which are not recognised by JavaScript. Remove them and the linked file should also work.
Yes sir, I did exactly like that, I removed the ASP tag <% %>. but the same. Anyway it works when content of selectcustomer. js is copies to ajax.asp. But my main problem is to display second list value as soon as the first list value is selected. How can I do this?
Thanks and regards,
Vikas
acoder 16,027
Recognized Expert Moderator MVP
Select what in the second list? Can you explain clearly with an example?
Yes sir,
Suppose two list
1) Country
2) State
If country is 'India', then state field should have list of all indian state.
And so on ....
Thanks and regards,
Vikas
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: William Wisnieski |
last post by:
Hello Everyone,
I have a main form with a datasheet subform that I use to query by form.
After the user selects two criteria on the main form and clicks the
cmdShowResults button on the main form, the subform returns the records
based on the two criteria. The criteria used on the main form are values
selected in two list boxes. When the user clicks on the first list box
(lstCollege), it returns values in the second list box...
|
by: arthur-e |
last post by:
How can you select records based on more than one combo box -
I have a combobox that selects records based on name
(I'm sure this has been asked a thousand times - web site answer/link
could be helpful too; but I'm so bad with syntax that specifics will
be MOST helpful)
SELECT DISTINCT .,
. FROM
Union Select "<ALL>" , NULL From
;
|
by: Stephen Miller |
last post by:
When I dynamically populate a HtmlSelect combo box, the Value property
consistently fails to return the item selected, defaulting instead to
the first item in the list. For example:
Protected WithEvents Fruits As System.Web.UI.HtmlControls.HtmlSelect
Protected WithEvents Results As System.Web.UI.WebControls.Label
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
…
Private Sub Page_Load(ByVal sender As System.Object, ByVal...
|
by: Zlatko Matiæ |
last post by:
Hello.
How to reference selected values from a multi-select list box, as a
criteria in a query ?
Is it possible at all?
Regards,
Zlatko
|
by: Greg Scharlemann |
last post by:
I'm not sure the best way to accomplish this... my hunch is with
javascript, but I'm not sure if using server side code (PHP) would be
easier.
I'm adding people to a database. People have a first name, last name,
and a undetermined number of Cities and States with which they can be
associated. I've got a drop down box that I would like to use to
display the number of inputs to allow for city/state entry. I would
like to dynamically...
| | |
by: mso5 |
last post by:
Hi,
I am trying to build a small form with a list of countries and regions by each country (yes, the classical one), and I'm stuck with it. I'm using AJAX also, and I manage to get the correct value from the selection, but it does not modify the second list based on the first selection. Can anyone tell me what am I doing wrong in this code? I am not a programmer..
Thank you!
<script language="javascript" type="text/javascript">
<!--
|
by: ramchml |
last post by:
i have two select boxes.based on the selected value in one select box it show the maximum options in the other select box in next page.i used javascript onclick function.for first time it shows correct options in the second select box if i go back and change the value in the 1st select box it shows me the previous value in the 2nd select box,the value not get changed.it is happening only in opera9 all the other browsers its working fine.it seems...
|
by: hello2008 |
last post by:
Hi,
I have just started coding in PHP. I have coded a web page using HTML, JS, and PHP. An HTML table has to be populated dynamically using the data from the backend.
Presently I have 5 records in the backend table so I get 5 HTML-table rows. I have created a session object starting from the login page. The requirement is that as soon as I log in and my request gets forwarded to the foll PHP page I should be seeing the foll. dynamically...
|
by: godkrishna |
last post by:
Hi Guys.. I am new to javascript.. pls bare with me :)
In my form, i have a table with two columns. first column has checkboxes and second has dropdown lists.
On check of each check box.. certain 'options' are addded/removed from its corresponding dropdown list.
My problem is, after adding/removing the 'options' dynamically, if I select the newly added option and submit the form, the corresponding value for the newly added option is...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
