Dynamic Dependent Dropdown Lists?
I 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
ADVERTISEMENT
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 Related
I have found in the forum examples or 2 dropdown lists and 3 dropdown list. Does anyone have any idea how to do 4 or more dropdown list? I tried to modify it from an example script found here but failed. Code:
View Replies
View Related
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
View Replies
View Related
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
View Replies
View Related
i'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:
View Replies
View Related
Is it possible to sort dropdown lists alphabetically via a recordset without using SQL statements?
View Replies
View Related
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:
View Replies
View Related
I 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 Related
I have a form with two drop down list. I need the list items to vary by what I select. Ok..short and sweet. I have a list of dates in one....in the other I have a list of events. If I select a date in the first drop down I only wanna see the events for that day. Also if I select an event I only wanna see the dates for that event! What is the best way to go about doing this....and please dummy it down for me...I suck at sql to be honest.
View Replies
View Related
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.
View Replies
View Related
Does anyway know the best way (preferably usinge ASP and avoiding the use of Arrays) how to achieve the following:
I have an ASP page. In it, I have a FORM that contains 2 Radio Buttons and a Drop Down List. I need to have the values of the Drop Down List change depending on which Radio Button is selected by the User.
(I thought that maybe some sort of code acting on the OnChange action for the Radio Buttons might work??).
View Replies
View Related
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:
View Replies
View Related
Basically, I have 2 separate drop-down lists, we'll call them List1 and List2.
Say List1 contains:
Fruits
Months
Sex
Now, I would like all 2 lists to be on the same page. A user would proceed to select something from List1, say "Fruits". Upon clicking on the drop down list for List2, the list items should automatically be updated to predefined items, say "Apples", "Oranges" and "Pears".
if the user changes his mind and goes back to select "Months" from List1, List2 should immediately display stuff pertaining to List1 items, say "January", "February", "March" etc etc....
View Replies
View Related
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:
View Replies
View Related
I have a table called tblParts. The are 3 fields: PartID, PartNumber and Price. I have a dropdown box on my ASP page that is dynamically populated with PartNumbers from the database.
I have a text field for the price. I want it when the user selects a part number from the dropdown to display the correct price in the textbox for that part. I "DO NOT" want the page to reload.
View Replies
View Related
I want to create a system of dynamic dropdowns for a site I'm working on.To add an entry a user first has to select a Category which then populates the Subcategory dropdown which inturn populates the Subsubcategory dropdown.
An example can be viewed on the Nvidia and ATI sites when you download drivers.
View Replies
View Related
is hard or easy to create a dynamic dropdown?I have sorted my previous query with the array and now i want to perform a dynamic dropdown from one of the options given in the first?
View Replies
View Related
i want to make two dynamic dropdown lists that get data from sql server database using classic asp.when user select a value from dropdown list1 (country) the values in dropdown list2 (city) should automatically be changed.in the database the relation is one to many (country table with city table).
View Replies
View Related
i have form on asp page that recalls data from the recordset and populates all fields except the dynamic dropdown box that doesn't, just shows default value. How do I make it populate based on the entry in the db?
View Replies
View Related
I'm trying to build a asp dynamic list were you can select a option in the first list and depeding on that value the second list will change to match. For instance I choose a customer in the first list, the second list then has to give all the codes from that customer. The list is variabel, as the value;s are from a database.
If tried some stuff with ASP and Javascript, but the page reloads after selecting one option, but because it reloads, it delete's the text that is written in the rest of the form.
View Replies
View Related
Does anyone have a snippet to hand where i can create a dynamic dropdown for a credit card page, basically i need to dynamically create a drop-down populated with this year as 2006 and go back 4 years?
View Replies
View Related
just a quick question that I need to now the answer to before I try is it possible to create a dynamic dropdown menu containing values that are not stored in your database.
Ok so I'm working on a schedualer that searches for time slots that are not free and displays these vaues if they are not contained in the database Quick example:
1st sept 10:00 taken
1st sept 11:00 free
but 1st sept 11:00 free will not be stored in the database therefore the dynamic dropdown will not be populated from a recordset.
View Replies
View Related
I have a dropdown that is dynamically populated. The value = a numeric code which I save in the DB. The text = the description. I know how to get the value of the selected item but I need the text of the selected item. I know how to do this in javascript but where I need to gather the text is during an ASP routine.
How do you get the text portion of a dropdown? I saw one post where you can add the numeric code and description together and then use split() to seperate them. I'd rather not do it this way. Is there another way?
View Replies
View Related
I have a dynamic drop down menu created from an Access 97 database. The munu contains numbered indexes. Is there a way to have Index 10 displayed after Index 9 instead of after Index 1.
View Replies
View Related
I have a dynamic dropdown list that has info brought in from my SQL database. Based on the user's selection, I want to create a message box that informs a user that an additional step must be taken first before the form can be submitted. For instance:
Drop down list contents -
Estimate
Repair
Maintenance
Renovation
New Build
If a user selects "New Build" from the dynamic drop down, a messgae box would appear to let the user know that they need to have a permission form filled out before they can submit the work order. Something to that affect. Can this be done based on a selection in the list or do I need to use check boxes instead.
View Replies
View Related
I've been pulling my hair out over this. I've been looking at it so long I'm probably just not seeing it. I'm trying to populate a dropdown list based on a user's leagueID contained in a Access database. Here's my code:
View Replies
View Related
I have a page pulling some data from an MS Access DB, one of my columns is a "Application" column.
I have a dynamic dropdown pulling various Application names from a separate "Application" table in my DB. What I'd like to do now is to be able to select one specific Application from that dropdown and click the GO button to have it only show records with that Application name in them. Code:
View Replies
View Related
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 .....
View Replies
View Related
Can someone tell me why my "select2" menulist disappears??
Code:
View Replies
View Related
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 Related
currently 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 Related
I 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?
View Replies
View Related