I have a form with 2 drop down menus. the first is populated via a database query and the second gets populated based on the selection made in the first box. (Category/Sub Category)
I am having a difficult time keeping the initial item selected after the page reloads. I thought that this statement would work: Code:
This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:
View Replies View RelatedI have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies View RelatedIm getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:
View Replies View RelatedI have a form that will add a device to a database. What I am having a problem with is that I have two drop down boxes. One is a building number and the other one is a room name. Because there are many room names that are the same in many of the buildings and some room names that are not in all of the buildings, I have created a table called buildings and another table called rooms.
I have a drop down menu that displays all the building numbers and what I want to be able to do is when I select the specific building number, another dropdown box appears showing all the room names for that specific building. I also what to be able to keep the information already on the form intact. As an example, a user puts in information on the form such as the machine name, username and then selected a building name, which would then show the rooms in that specific building, maintaining the information of the machine name and username on the form. There are seven items on the form, which the user must include prior to submission of the form.
I have been looking through the forum trying to find an example but with no luck! I have three drop down boxes for displaying a date i.e. day, month, year. I have an edit page which I want to allow the user to update their details. When the choose to edit their page the date stored in the database is split into the three values i.e. day, month, year.
I want to set the selected property for each of the three drop downs boxes based on the date already stored. My question is "Is this possible?" or do I just have to display the dropdowns with default values selected i.e. 1 Jan 1970.
I have a form, all the drop down boxes are populated from fields in tables in a database ive made. This part is working fine. The fields are for IT components and each one has a price in a seperate field.
Im trying to store the price to a session when the user selects. When the page loads and the drop down lists are populated I am loading the price values in also but not displaying them. So far my code for it is this: Code:
I am creating a search form on my website. The user will be able to search via zip code, county or state. If the user selects the state option from the drop down box, I would like another dropdown box to appear on the page with all the states listed. I think you have to use javascript but i'm not sure.
View Replies View Relatedim looking at populating a drop down box with database values when a user selects a value from another drop down box.I have a drop down list that populates from database values, it is a list of manufactures. When a user selects a manufacture i want it to display all the systems for that manufacture which will be stored in a table. I understand that because asp is server side that once an option is selected the page would have to submit and then load the values in.
View Replies View RelatedI am now on the write track for detecting and acting on a variables value. Could someone please have a look over it and see where it is falling out. The help really would be appreciated.
The reason for vTime = vTimex + VTimex1 etc... is because once I get the first part working I will then continue to add up the value until it reaches four. I believe once I get the first part working I can adapt it for the second part. Code:
I've gotten the dependent drop down boxes to work except, when I fill out the form, and get to where I click the first drop down box and make a selection, the page refreshes and all of the fields turn blank, except for the second drop down box, which displays the correct records based on what was chosen in the first box in the entire form. Also the first drop down box returns to the first record in the list.
View Replies View RelatedI have two drop down boxes that are linked via an ID and a parent_id.
I would like to choose my first option and then have the second drop down box load everything that is under that ID without refreshing the page.
I am strugling to make a Multi Drop Down Search boxes. The main concept is to be able to make a search following some pre-defined dropdown boxes. I would like to search for a specific event in mathematics (for exampel) from a specific time (between different centurie).
- boex1 has a series of categories (Doctors, mathematicians..)
- BoxA has a range of centuries from 1500 to 2000 (1500- 1600...)
- BoxB has a range of centuries from 1500 to 2000 (1500- 1600...)
I have an ASP site where users select employee skills from a one drop down box and the level from another drop down box.
However what i iwsh to do is provide an add button where uses can add more drop down boxes onclick. I have tried looking for help on how to do this but dont seem to be able to find any. I'm guessing i would have to use javascript to do?
I am trying with very little success to populate two drop down boxes in the same form when i do i get an error saying page cannot be displayed.
They do not need to be linked to each other in any way but they get the data from the same table I am new to ASP so this might be pretty easy to resolve.
i have been asked to create text boxes dynamically on a web site, the user can click a button and a new set of text boxes will appear. The user can add as many boxes as many times as he wants, I have created the text boxes already using the following code.
function inserttextboxs() {
var tab = document.getElementById("Difference")
var tr = tab.insertRow()
var tc = tr.insertCell("") tc.innerHTML = '< input type=text id=text1 name=text1>';
}
The problem is I don't if this how I should be doing it when I submit the form all the elements have the same id, I need to create something with unique id's so I can retrieve the different values
how do get dynamic content to a drop down text box from a db. For example:
There are two drop down boxes. First one continents Second one countries.
The user selects content from the first drop down box and using the onChange javascript function the data on the second drop down should show the countries related with that content.
I've tried doing this tutorial on Macromedia's site, but can't get it to work.
http://www.macromedia.com/cfusion/kn...fm?id=tn_19117
I'm using VBscript server side script.
I've been farting around with trying to make some dropdown boxes populate based on the value selected from the first drop down box..
I have 3 DropDowns..
1)PumpType
2)PumpMfg
3)PumpModel
the first one takes all the pump types from a database table called pumptypes and populates it
the second dropdown gets its values from an sql query to a second database table called pumpdata that puts all the manufacturers that have that have a pump that matches the type selected in the first dropdown.
the third box does essentially the same thing but looks for all the models based on the values of the first 2 dropdowns..
whats happening is when I select the pump type it goes to the next page without allowing me to select the other 2 boxes.
heres the code I have .....
I have this form which the user will fill online.Now the form has 3 checkboxes giving a user the option of selecting which person/persons out of the three listed should get the form email when he hits submits.
So the form has three checkboxes and each checkbox will have a name of a person next to it.The user just needs to check it (one name or all names out of three) and after he hits enters a mail shud go to the respective selected people.I was thinking of using CDONTS to send mail..but i cant figure out how i shud do it with this mutliple checkbox scenrio?
I am having trouble with the ordering page. I would like a dynamic form list to look at a database and when the user selects a product code, the text boxes containing description and price change too to reflect the product code.
The user will be entering in their contact details, so I dont want the page to reload too because I will lose that info. Code:
I am working on a survey form. I need to create multiple-multiple dependent istboxes...I need to allow the user to make multiple selection from a categoryListbox and as the user select from categoryListbox must display and add available subcategories into the subCategoryListbox and allow to select multiple subcategoris.
View Replies View RelatedThe user can search the database when they put in a date, that works fine, but when i put in another text box to search the database for a certain date range Code:
View Replies View RelatedI am working with an ASP app that creates reports based on data in an SQL Server 200 database. There is a web form with select boxes for the user to select their criteria, and based on that an SQL SELECT statement is generated.
One of the requirements is that some fields need to be multiple selections. The output of these fields are in CSV format (One, Two, Three). These values are all alphanumeric, NOT just numeric....
i have two drop down boxes: student id and student name on a web form.
a database (ms access) has the student id and student name fields in a table.
the drop down boxes should get their values from the table's fields respectively.
i am ok with that (using asp) but my requirement is as follows:
once i select a studentid from textbox1 then automatically the textbox2 should be selected with the corresponding student name.
how can i do this using asp? or can javascript do the job too?
I have a form I'm building in Dreamweaver. On my form I have a drop down list that is populated by a table in my Access Database. I won't to add a second drop down list but have the contents of it vary by what I select in my first drop down list. Let me explain further. Lets say I have a database of Movies. And The name of the movies are in a table and that table is used to populate my first drop down list. Now I have another table that has the actors in the movies. I have a junction table to make them relate in my database.....now how can I select a movie in the first drop down list...and the actors from that movie popluate the second drop down list?
View Replies View RelatedI want to create two drop down menu. one is for the Main Category and second is for Sub Category. Both value should be come from the database.
when i choose the Main cat. say business then it should load sub cat of business in second drop down menu but is should be done without refreshing the page.
I hope this is the right group. I am very new to ASP so this is
probably a stupid question. I have some vbscript that query's AD and
populates a recordset. I know the recorset contains the information I
want by doing a Response.write. I am having problems dynamically
creating a drop down list from the data in the recordset. The drop down
is created but it is empty. Code:
I need advice how to reduce the size of my drop down list which is created dynamically using a field from my database. If you visit this link you'll see as the box is too long it's knocked out the whole look of the page. Other than shortening the names of the businesses, is there anything else I can do?
My concern is that next year sometime after this site has gone live, it will be maintained with a content manager by people with no IT expertise.
i want to retrieve the value from Mircrosoft Access database into the drop down list..it works.. so its dynamically..
but the problem is.. how could i redirect from the dynamic drop down list to other page.actually this page mostly like a search page.
I have two drop downs. Both dropdowns are dynamic and data is send from a db for both,
Depending on what is selected in the first drop down i want to populate the second drop down. I know and have done this using XMLHTTPScripts but as this is for a website i dont want to go down this route.
I have an form/application that requires several pages of steps to be completed. On page4 (income school info) I have a dynamic drop down list that builds itself from the database based on member names that the person has entered on the previous pages. When the person filling out the form gets to the end they have the chance to edit their data if something is wrong on page5a.
When they click on the edit icon the member name is passed back to page4 in the querystring. Based on what the member name is in the querystring, I want the dynamically built drop down list to select whatever name is in the querystring. Code:
I have to populate a drop down list from the database depending on the values of another drop down list. And the thing is it should also be able to add more dynamic dropdown lists to it.
Basically is a survey result page for which the one trying to look at the survey has to figure out different criteriaz.
Suppose he's looking for a group of people who are interested in buyin a stuff and then he wants to find if their age is above or below 50 and then further he decides to see if they are employed or not...
I did try a couple of things such as populating a dropdown list in a new page depending on the values passed on by previous one... but was hoping to find a better solution as the one i m workin is tooo complex and tooo complicated.