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 Repliesi am trying to link list boxes for a mini intranet. I have created a booking database for our staff to add bookings into for a business and it is all based around dates etc. I want people to be able to select the year in the first box and then in the next list select the month and then the date.
Can you give me a sample code on how to link the lists so that they are dependent? i can get single drop down lists just cant link them.
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 Relatedprovide me a sample code for dependent drop down lists?I need to create a few drop down lists and they are dependent of each other. Their relations are very complex as 1 drop down list may affect 2 drop down lists.
View Replies View RelatedI am trying to create a drop down list that I have populated. But what I want to do is to populated the other drop down based on the selection in the first one, I am getting an error when I try to make the selection. here is the error that I recieved
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/reportrequest/admin/ReportRequest.asp, line 233
and here is my code:
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 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 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 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:
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 RelatedI 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.
Can someone tell me why my "select2" menulist disappears??
Code:
I have a dropdown box getting data from a database, and I send the data to the database on form submition, But, I need to send another data to another column to the database according with the user dropdown box selecion. Example.
Dropdown option 1: DELL Corp.
Dropdown option 2: IBM Corp.
Dropdown option 3: Avante Systems
If the user select DELL Corp., it will send 'DELL Corp.' to the database but I need it to send dell.jpg to another column too. I have the code to send the data, but the relationship of the boxes is 'the thing'.
A solution almost like bellow is what I am looking for, but instead of, the selection in the first combo should point to another selecion in the second combo (so the second combo will have the dell.jpg value): http://forums.aspfree.com/code-bank...own-137839.html
i have a form and i need the selection from the first dropdown to influence the results on the second dropdown.The first dropdown will have a list of guesthouses and based on the guesthouse chosen, the second dropdown will give the rooms available in that chosen guesthouse.
View Replies View Relatedcurrently need to do a dependent checkbox, mean when i choose 1st check box, 2nd check box will become visible and if i never choose it, 2nd checkbox will become blur and unclickable. may i know how to do it?
View Replies View RelatedI have three listboxes
1 : company
2 : department
3 : function
I want the following functionality. when i choose a company all the available departments in that company must appear in listbox2 and when i choose a department all the available functions must appear. how can i do this with Java?
I have a database table called Pumpdata. This table contains all the different pumps available. I had to make 2 other related tables one called pumpType which is just a description of Pump Types. ie.. (single, double, mixer etc..) and the other table is PumpManufacturer which contains a list of Pump Manufacturers.. the 2 tables are related to the pumpdatatable based on the TypeID (in PumpType) and MfgID(in PumpManufacturer)..
Ok the problem I'm faced with Is I need to create a form to get a particular pump based on the Pump Type, The manufacturer, and then the specific Model Number..
The First list box alllows the user to select the Pump Type, The second ListBox allows the user to select the manufacturers based on the pump selection. (Note in the pumpdata table there could be an occurance where a particulatar PumpManufacturer could have several Pumps of the same type (I just need to show one occurance of the PumpManufacturer here). Code:
I have an application in asp; in my form I have a combo and a textbox, the combo is fill in from a database query. I cannot do the following: when selecting an item from the combo, it should send the ID of the combo to a textbox. In other words, when selecting an item, it must send the ID to a query and the result of this query send it to the textbox. I need to do this using vbscript and the onchange method.
View Replies View RelatedI have a set of dynamic dependent list boxes that are populted from a database. When I select the first box the second box is populetd with the correct items. If the first item is the desired selection another option has to be selected and then the first item has to be reselected for the list to work properly to update the next dynamic list box. To include the --Select-- in the second and third list box table would add several thousand rows to the table. If I added the --Select-- in the table it would add several thousand rows to the database.
View Replies View Relatedhow to give dependent listboxes in asp code.
View Replies View RelatedI'm working on a form where if a client makes an entry in one field, it causes another field to become unusable. The fields most likely will be drop-down lists. The form will be filled out online then mailed to me using the post method.
View Replies View RelatedThe 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:
View Replies View RelatedI want to have dependent dynamic dropdown lists where the person can select the state, then county, then zip code, and all 3 of these menus will be populated by a database. I have a page that Ive been working on but I just cant get it. The page I am working on also refreshes when you select the state, then when you select the county it refreshes again but instead of populating the zipcode list it just takes the state name and inserts it into the city menu. Code:
View Replies View Relatedi'm trying to create a dependent dropdown menu based on two objects, packages and steps (the steps dropdown will be dynamically updated/populated when a package is selected). the site uses ASP and since ASP is server-side, i am using JavaScript to handle the client-side "dynamic" change.
i've found several snippets of code that create the dependent dropdown; however, the two examples i have use arrays which are statically defined. the data that will populate the dropdowns is coming from a SQL database, and that data will be updated/changed fairly often. my question is this: is there any way to generate the arrays using ASP (outside javascript tags) and use them in the javascript?
or is there a way to use javascript to generate the correct arrays and fill them with data from my SQL tables? can i use a recordset ojbect in javascript? i have heard that you may use PHP inside javascript tags, but i'm unsure if that is what i want to do.. especially since i am using ASP as the main language for this site. Code:
i have three dependent dropdown list.when select city in first box then 2nd list will show all company for selected city. 3rd will show all jobs of co. any suggestion?
View Replies View RelatedI have a created a cost reporting system which shows a level-breakdown
report. There are three levels in the report the lowest level holds the cost
items that are entered by the user these records also have an Entry Date.
The level above that is a Sum of the lowest level and the top level is the
Sum of the second level. I created the solution using three queries in
Access. I then use the queries in ASP to generate the report. But now I need
to use the Entry Date at the lowest level to re-generate the report with
values from the StartDate to the EntryDate (which is entered by the user).
Question is, can I do this using the construction I use, or do I have to
pull my queries to the ASP code and include the dynamic EntryDate? How do I
solve this?