im 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.
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 need to have three list boxes automatically populating each other, (ie when region is selected from the first listbox, it will populate automatically the second one which is the TOWNS and when the town is selected is should populate the third one AREA) all data is in the database in one table.
Can someone point to an example where dynamic drop-downs are populated? I would like to execute a sql statment and populate the items in dropdownbox1. I would also like to retrieve all possible values for dropdownbox2 and use Javascript to build an array that holds these values.
Then, I would like to scroll thru the array to select the correct values for dropdownbox2 based in the selection made in dropdownbox1. At last I would like to save the selected values for dropdownbox1 and dropdownbox2 to the database. I would appreciate very much if someone can give me code examples for each of the things listed above.
I'm orking on an online Catalogue, users are to select from a dropdown menu the finish they wish there goods in. The way I was thinking of doing this is have the finishes availiable stored in a column in the database - lets say 'finish' and the column would contain the finishes seperated by commas.. like red,blue,green,yellow etc, so the pull down menu would need to dynamically populate with these values.. is there an easy way of doing this, or am I going about it the wrong way?
I am trying to populate a drop down so that it shows the current date, plus the previous 6 days. Here is some pseudocode. I can't get it to work from here.
<SELECT name=Date> <% Dim d d = Date() for i=1 to 7 %> <option><%=d-i%></option> <% end for %> </SELECT>
I have a recordset full of a list of courses.I want to create a search page, where the user can select the course from a drop down box, hit go and be taken to a page on that course. But some courses have 3 versions of that course, so for example I have 3 IT courses. so in the list it says
IT IT IT
How can I limit this to just display the value once in the drop down?
I am trying to populate the drop down boxes. There should be two one for the begin date and the other for the end date. here is my code. The problem is that it wont create the drop downs. Code:
I'm trying to pass information using POST. The first screen the user selects a company, and that variable is passed to the second page. On the second page, I am trying to populate a drop down list of usernames, but only those usernames that have the same company as the one selected on the prior page.
For some reason, the drop down list does not fill up with any names, and the rest of the form comes up blank(i.e. password, login, reset). Are there any glaring errors in this code? Code:
I was wondering if someone could help me with finding out how to populate a drop-down box with values queried from a database.
Also, I was also wondering if someone could help me with figuring out a way to place field-values retrieved from a table into a text field. This would be for the purpose of editing a record that has previously been entered.
Placing the information in a texbox field so that the user can easily type over it seems like the best thing to do.
I 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 am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
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.
I 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.
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 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:
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?
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:
I 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.
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
I have two recordsets that I want to populate within an array.
The array will always have two columns, but the number of rows is unknown (sometimes 2 rows other times 200 rows). I'm not too familiar working with arrays.
I want populate the array using a loop. How would I define and populate the array within loop so that I don't lose values and each new set of values are populated into the array through each iteration of the loop? Code:
I need to dynamicaly create my javascript as the page loads because as persons add items I need to increase my layers based upon the number of records returned from a recordset. Code:
I am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table). I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve. On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table. Now my problems is... 1) how can I know which checkbox user selected ? 2) Are there someway to get the value of checkbox without making form ?
I have a check box, when selected it needs to trigger "something" to populate two drop down lists with default values. I haven't done this before, so I was hoping to see if somebody had a good example willing to share.
I was doing a research now and realized that I also need to mention it needs to populate values straight away not on the submission.
I need to populate a dropdownlistfrom a form and fill it with the numbers from 1 -1000. Obviouly, this would take a considerable amount of time doing it manually so how does one go about populating this list from an array of some sort?
These entries will be stored in a database so would it be better to just populate this form from a database? After mentioning the above situation(s)... (a)How do you fill the dropdownlist from an array? (b) How do you fill the dropdownlist from database explained in it most simplest form?
I am trying to make a page to display a comparison chart. say we have 15-30 products... these products are all similar and we would like to compare them to each other
I would like to have an image (or whatever) of each product and then a check box next to each one. Below the products is a table (with say... 5 columns) with all of the attibutes of the products (this table is EMPTY otherwise)
when the user checks the check box.. the first empty column populates with the info (from a file??) and the user can continue checking boxes until the 5 columns are populated, or the user can uncheck and have the column unpopulate
i have a LITTLE (very little) asp.net exp. but i understand the concept (same with SQL) and plenty of HTML and such... can someone help me put somthing like this together?
