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.
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.
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:
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:
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:
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>
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.
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 = "
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
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.
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.
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.
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.
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.
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?
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:
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?
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>
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.
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.
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:
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:
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:
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:
