Parsing Information Using Onchange In Two Select Fields
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 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 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.
My problem is this: This database has a field called "b_name" which contains the first, middle (if any) and last names of registered users. The table also has corrosponding other demographics pertaining to each registered user.
I've used the code below to parse the full names in "b_name" in the original table and put the names in another new table which has 3 fields, "FirstName" "MiddleName" & "LastName".
My problem is the fact that the way the names are stored in the original table and the parsed names in the new table do not correspond. 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 have a file which is performing a mail merge. It grabs data from the database and then merges with the bookmarks in a template document if the fields are present.
I have set write permissions on the docs folder it should be saving the file to but when I redirect to the file its not being saved.
Not sure whats happening here....hope someone can shed some light or help me in building another script. The main feature i need to add to the mail merge is the ability to only add information if the fields are present. Code:
I have table that list some companies, when the user selects the company a form comes up that list all the company info, where they can view it and also update some info. One of the fields they update is a drop down list. I'm having trouble populating the menu with the value from the company it comes up blank. Here is the code:
I have 4 tables first table category (category_id and category name in it) second table artist (artist_id, category_id, artistname in it) third table album (id, artist_id, album_title in it) forth table song (id, album_id, title in it)
I'm selecting category in first page I'm selecting artist in second page I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page 2- artist name when I was selected in second page 3- album name when I was selected in third page
I have downloaded and installed an ASP Calendar offered for free by Manohar Kamath from his website. I've modified it to accept two new fields (sStart_Time & sEnd_Time). I want to be able to have drop down selections for the time entry, but do not know how to accomplish this.
Please take a look and tell me if this can be done using the <% =Server.HTMLEncode(sStart_Time) %>"> value for this piece or if there is some other way to accomplish this, please let me know.
If I leave it as the following, it works OK, but I want to make it easier for people who are adding to the database: Code:
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 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 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: