Dynamic Select And OnChange
I have a Dynamic drop-down box that is populated based on a ADO query. This works fine. I want to capture the users selection and assign it to a variable for use in another query.
I am using the onChange event to try and capture the users selection but it always passes the last entry in the drop-down list not what the user selects. I am very new to ASPJscriptVbscript. A snippent of the code is below.
<select name="cur_mgr"
<option value=""></option>
<%=Manager%>
</select>
View Replies
ADVERTISEMENT
I have a select box where the user select a branch and using the onchange, show up another select box in the same page, containing all the users within that branch. this sounds easy but I just can't get round to it.
View Replies
View Related
I need to update a variable based on the value that is selected in a drop down. This is nothing special, just cant seem to wrap me head around it.
response.write "<select name=mySelect onChange=???></Select<"
Response.Write CreateInput ("hidden", "Name", lFacilityName, "") & CRLF
I want to change the value of "Name" whenever the value in mySelect changes.
View Replies
View Related
i have a SQL Server (2005) and am attempting to populate 3 combo boxes by using SQL stored procedures.
The problem is that I cannot find out how to link the second combobox to the first using a selectedIndex method and the same with the last in relation to the second box. I can always pass from page-to-page, but that would be extremely inconvenient and time consuming for the user. Here is what I have so far: Code:
View Replies
View Related
I'm having an asp page with a form with an action pointing to itself. The reason for that, it that the asp page depending on changes in any of two select fields with data from 2 different databasetables are going to populate a third select field. Code:
View Replies
View Related
I am trying to learn and use good DHTML concepts and code (assuming they are needed). My current issue concerns how to handle this situation.
I have a Select List box which displays values based on what value is selected in a dropdown list. For example, my dropdown list contains a class name, and the Select list contains all of the students who are registered for that class.
So what I would like to occur, is when the user changes the class from the dropdown box, the Select List is re-created displaying the students who are enrolled in that class.
I thought I could do this without having to reload the page (with DHTML) but here is my problem. Code:
View Replies
View Related
I've got a form that updates a record in a database. A select box is generated based on the values in a separate table. What I'm trying to do is have the current value of the field appear as selected and have the rest of the list populate with the values in the table in case the user wants to change the category. In other words:
<select name="library_subject_1">
<%
While (NOT catalog.EOF)
%>
<option value="<%=(catalog.Fields.Item("library_category").Value)%>"> <%=(catalog.Fields.Item("library_topic_grouping").Value)%> - <%=(catalog.Fields.Item("library_category").Value)%>
<%
catalog.MoveNext()
Wend
If (catalog.CursorType > 0) Then
catalog.MoveFirst
Else
catalog.Requery
End If
%>
</select>
Can someone tell me what I'm doing wrong?
View Replies
View Related
I have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
View Replies
View Related
how can i get a listbox to submit once the user has selected from it (ie without a submit button)
View Replies
View Related
I need to populate two select boxes So that on selecting value from one select box, the values in second select box will be populated. eg
in first select box i m having the list of all project of which a particular user is manager or co-manager.
eg:
Query1 :"select Project from tab1 where manager = ('" & userid & "')"
on selecting any project from this list it should populate the second selectbox with workgroups that are associated with selected project from selectbox one.
eg:
Query :"Select workgroup from tab2 where projectid = "
View Replies
View Related
In my form i have three combo boxes, all the values in combo box comes from database, Second combo box values will come according to the value selected in first combo box, third combo box values will come according to the value selected in second combo box, i think i have explianed it clearly.
eg:-
first combo consists of brands which are in database, according to the brand selected categories(second combo box) values should come from database, according to the category selected products(third combo box) values should come from database
View Replies
View Related
Is there a way to run a SQL script from a onchange event in a form table.
View Replies
View Related
i have this code on my combo to make it reload the page to run the querys onchange='submit();' but i also need to set a variable like var=0 with the onchange function.
View Replies
View Related
I have a list box that has a list of names, and i want when the user selects the name to bring some information from the database and put it below the drop down box. I think i need to use an onchase event but how do i get the page to refresh to show the new data, suggestions or examples woudl be great.
View Replies
View Related
A drop down list is populated with certain values from the database and when the selection is changed the post is posted back to itself and ceratin other processing takes place on the same page, based on the selected value.
I have modified the code to make a default list item selection (using option selected etc. ) when the page loads the 1st time. I also want the onChange event to fire the 1st time (by taking this default selected item) on page load, not just when user makes a selection from the list.
View Replies
View Related
Dynamic select menu, the moment i select the required item i want to populates two textboxes with some other data.
View Replies
View Related
I have several Lists with onchange=submit, so, as you select "Country", the form submits, and "State" list changes, and so onwards.
If I have several lists, How can I know wich list submitted the form in asp? (the list should be the same that was last changed by the user).
View Replies
View Related
I wrote this code:
<%@ Language=VBScript %>
<%
Response.Write "<SELECT id=Customer name=Customer
onchange=""text152='abc'"">"
Response.Write "<OPTION value=1>One"
Response.Write "<OPTION value=2>Two"
Response.Write "<OPTION value=3>Three"
Response.Write "</SELECT>"
Response.Write "<BR>"
Response.Write "<INPUT type=""text"" id=text152 name=text152>"
Response.Write "<BR>"
%>
But change the SELECT,onchange event not been called
View Replies
View Related
When a user changes the value in a select statement, I would like to update the recordset using a onchange event. Could someone please point me in the right direction? Would like to stay away from forms if possible.
<select style="width: 200px; font-size: 10px;" name="selStat" size="1">
<option value="<% = rs("Status") %>"><% =rs("Status") %></option>
<option value="CLOSED">CLOSED</option>
</select></td>
sql="UPDATE dbE SET Status = 'CLOSED' WHERE EMAILid = 25"
View Replies
View Related
I don't think this is possible, but thought I would ask. Is there a way to trigger an onChange event. I have a couple of radio buttons and use ASP to change them at somepoint. When it does I want to trigger the onChange.
View Replies
View Related
I am working on an asp page and am having trouble with several things. First, I connect to Oracle and populate a combobox with the field values. No problem there. The next thing I want to do then using the onchange event is update 2 textboxes with the min and max (on same form) with the min and max values from the database. The form is created dynamically using vbscript. When the user changes the value in the combo box I need the text boxes to automatically update with the min/max values. Thoughts?
View Replies
View Related
i got 3 text field in my program, first, second and sum. user enter in 2 number and sum will automatically displayed in sum text box. i use event onKeyPress to control user enter in number only. and onChange to auto calculate the sum of first and second. Code:
View Replies
View Related
I am trying to take actions using onchange with an option list without success.
I am not able to fully populate the list without a bad bad behavior (the list is not getting populated)
What I am looking for, is being able to call a sub procedure each time a new item in the list is selected (of course after it has been populated)
Below some of the code: ....
View Replies
View Related
I have a drop down menu and it is populated with different subdivisions...Those subdivisions are associated with an ID. I need a drop down box that once the subdivision is selected it will change the ID in a hidden textfield. Any thoughts or ideas on how to do this?
View Replies
View Related
I am trying to use the following code to call a function staffname() and nothing happens when called. What's wrong with my code? What is the proper way to call a function?
<select name="staffname" size="1" onchange="staffname()">
<option value="#"><-- Please select your name --> </option>
<%while not rs_staff.eof%>
<option value="<%=rs_staff("StaffID")%>"><%=rs_staff("StaffName")%></option>
<%
rs_staff.MoveNext
wend
%> </select>
<script language="vbscript">
Function staffname()
alert("hello") End Function
</script>
View Replies
View Related
I have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).
Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.
View Replies
View Related
I have a form with textboxes,and a select option(country)..onchange of select
element,i reload the form because i hit database to get cities of country selected..
whatever info user has entered is being stored in session variables.
my problem..as the form gets submitted onchange event of select user is able to write in textboxes but this info does not get stored in session varibles(but info written in textboxes before select is used does get stored and i am able display again onload of the form). how can i tackle thisproblem.
View Replies
View Related
I'm trying to call a sub procedure with the onchange event of a combobox. Code:
View Replies
View Related
I have a page that pulls 'member' registration information from a table similar to a bulk delete with checkboxes. This works fine, it pulls all of the member info. What I want to do is have the selected records added to a new table known as courses.
Sort of a bulk registration system where I have a list of members, put in the start date, end date, course name and course number once and it populates for all of the members in the new table adding the member info with the course info. Code:
View Replies
View Related
I have an access database and an ASP application. On my add screen I am populating a dropdown box with a field from the database.
I want to use the OnChange event to fill in a textbox below with the corresponding information. I am combining HTML, ASP, and VBScript for my Onchange event.
Below is a working sample of my code, this issue is my RecordSet does not set to the record that is selected in the dropdown box: Code:
View Replies
View Related
I'm brand new to this forum AND learning ASP via problem-based learning (not the easiest or sound way to do so, I know).
In any case, I have a form that uploads an image to my server. It does so via a form action to a new asp page. The new page has a link back to the original page. On the original page, I want the name of the file to appear in a text field e.g. Code:
View Replies
View Related
I can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?
View Replies
View Related
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
View Replies
View Related
