I could not solve for the past 3 days. I am try to build a website using ASP and VBscript. I am still a newbie to it.Let's get to the problem. What I am trying to do is to have multiple dropdown list. Each list menu ( except the 1st) dependes on the choice made in the one above.
I am using dreamweaver, it did generate a the form and everything and I was able to filter the results. The problem is that I don't know HOW TO REFRESH THE LIST. In other words, I can't figure out how to change the list menu options when the choices above change. I have tried to find some tutorial about it, but all I found was with JavaScript and I don't wanna mix VBS with JS.
Does anyone know how to make it so that when someone clicks on certain menu item on one list it automatically updates a second list with values.For example,if i click the Make of a car in one list, i want the second list to automatically update with the relative Models.
I've seen it done on various sites such as www.autotrader.co.uk but can't think how its done. So far i'm populating the first list dynamically with a database but don't know what the next step is to get the second one to do it.
I currently have an "Add customer" page on my site. On this page you can choose multiple "brands" from a list box. (These brands are dynamic and come from a seperate table in my db). These brands are split up into an array and each added as a row to a database table.
Now I am working on a "Modify customer" page. It has all the same fields as my Add page except that the fields are already filled in with information from the db. I can't seem to figure out how to have my list box have multiple items selected when you first come to the page.
I need to create a page which updates a products information within a record.
the tables are, products (ID,CatID,sID) supplier (sID,sName), category (CatID, CatName)
The above tables supplier and category have relationships to products by using the sID and CatID
I need to update the product details by having a select/option for a supplier and category but if not changed by the user the value already within products table stays the same, therefore the list must be dynamic so that the first item in the list is the one relating to the value in the products table. Also the value must be the ID numbers but must display the names not the ID's to the users within the select/option.
I have a form page in ASP where the first menu/list function as a filter of the second menu list. Once I select an item form the first combo I get the second menu full of options. This is correct. My probem is that the first combo gets the default value again and I do not see what I did choose.
I have been searching for tutorials everywhere on how I could make a menu that is multi levels but that can be updated dynamically through asp...so basically when I add a link in the database it will update the menu...now I know how to pretty much pull links from the database for a basic menu...but lets say there is a link called about us and under about us there is more options to choose from.
How would i code this so the menu would know which ones were parents and which ones where childs? And does anyone know of a good tutorial, or of an example. and basically I want this because I would like to create a content manager...but I don't understand how the menu would work when pulling data from a database.
I have a serious question here. Two websites: www.morepoweracing.com and neil.morepowerracing.com.
I am trying to build a menu system which is dynamic, and the live site, www.morepoweracing.com is what is going on right now. The test site is neil.morepowerracing.com and I am trying to make my menu dynamic so it feeds off the sql database. Secondly, I need to have a .5 second delay just like windows XP, becuase when your mouse is scrolling over from one button to the other, it tends to dissappear the menu you are looking at. Also, all severs are in house, so if you need me to copy the code down
How could I make a menu have many sub-menus, note that the menu and sub-menus items come from database.
Ex: a menu have items like:
Products | Auctions | Orders
the menu items above all come from a table in a DataBase,and if On Mouse Over or On Click events happens for any item,the specific submenu for this item appear which is also come from database.Do anyone know how could i do this?
I am building up a web application which should have a two level dynamic (ASP) css menu. My problem is that I do not know how I could make id="active" to show on pages that are on certain folder. I should be able to do this because I have to use following code on sub menu: Code:
<% if Request.ServerVariables("URL") = "/yourpage.asp" then response.write "id=""active"" end if %>
One of my tables is used for two purposes so there are blanks in the column I'm filtering. I tried using an IF statement but it still put the blanks in the list menu. Any idea how to remove the blank items? Code:
I 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 am trying to create a menu for asp.net page. The menu-detail list display, when mouse hovers over the main menu list, like you see in regular windows apps.
When the detail-menu-list window displays, it goes 'behind' combo box (sent to back). For other controls, like textbox, it is fine. Can some explain, how can I send the list box (<asp:listbox>) to become the underneath and not display on top?
I am doing server side asp form validation, the form posts to itself and if all the values are accepted the values are inserted into an access db...
I have several list/menu with static value options.
The problem is when I submit the form and another value is incorrect, each list/menu is reset to the initially selected value as defined in dreamweaver (in my case 'Please Select').
With text inputs I can easily set the value to the value passed through the form, however it's not as simple for a list/menu.
Is it possible to change the 'selected' option based on the variable passed?
It's annoying in the sense that even though the user has selected an option, if they make a mistake elsewhere they always have to reselect their list/menu choice...
The database is used for referencing filename, there located folder, id, order shown, but also there are some fields say "location_1" up to "location_4" which have a 0 , 1 or 2 in them. 0 means that file not needed for that section. 1 means needed for that section, and 2 means mandantory (must be seen before exit).
firstly selecting a location from a html radio box, drop down menu (not decided yet) will return whats needed so not showing pages what aint needed and wasting time.
Here it is though in order on the left i wish it to build a menu, but more advanced than plain links would be good. drop down like windows explorer etc. Code:
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.
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?
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour 2. user selects minute 3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
Let's say I have a dynamic list/menu, which gets its values from a database table, for example a list of contact people where the value is an ID number and the label is the name. However, if the value the user wants is not in the list I would like to place a hyperlink which will...
(1) open a small window, with an ASP form to allow the user to add a new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about. I don't like the idea of forcing the user to leave the current screen, go to some other form, add the entry they need to the lookup table, then come back; this seems like a logical approach, but just wondering how to make it work.
This seems like a common enough situation; anyone have any code samples or suggestions about how to do this?
I've writen the code below which displays a drop down select menu and can be displayed by writing the variable 'sjobs'. The code works fine as it is and the menu is populated with the requested info from the database ok. The problem I'm having is adding url links to the menu values. Code:
I am trying set up a page where the user can view records chosen by the year. I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
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....
I have 2 radio buttons: A and B. I also have a menu/list/dropdown.
When 'A' is selected, I want the menu/list/dropdown to fill up with all values from a database WHERE column = A (for example) and the same to apply when I choose B... I want the menu/list/dropdown to fill up with all values from a database WHERE column = B.
I have a dynamic list box in which I am calling data from my database too and having when the user submits the form it takes a value and submits it into one column of my table but i need one select to submit a value into that column and a value into another column at the same time depending on what they picked from the drop down list.
there are four options in the list and each one has a different Type value and also a DES value that both need to be submited into two different columns depending on what is picked.
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?
I am working on a page to display providers of services in my SQL Server 2000 Database. Visitors to the page choose a category and type then a dynamic list of available services that meet the specified criteria is displayed in a select field. My problem comes in with this list.
You can choose multiple services from the list. I want to then use the chosen services and a payment type to query a different table and display providers that meet the criteria specified. I am using the following code to read the choices from the select field. Code:
