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.
I would like to display 15 items (lines) in the dropdown list, but by default the list displays only 11 lines. How can I have all the 15 items displayed in my dropdown list
This is probably really stupid, but I cannot figure it out, and none of the references I've found seem quite right for what I'm trying to do. How do I do the below, but have the option values and Option Choice Text Description pull from the db instead of requiring manual data entry?
<option value="1" <%If (Not isNull((RS.Fields.Item("ID").Value))) Then If ("1" =CStr((RS.Fields.Item("ID").Value))) Then Response.Write("SELECTED") : Response.Write("")%>>Option Choice Text Description</option>
I need to include a variable value that I am getting from the URL into a dropdownlist selection.
<% Dim strFlagCode 'Holds the vessel Flag Code strFlagCode = request.QueryString("flag")
'-- Variables we are using dim objConn, objRS, strSQL '-- Define our objects Set objConn = Server.CreateObject("ADODB.Connection") Set objRS = Server.CreateObject("ADODB.Recordset") '-- Database path and Data provider objConn.ConnectionString = Server.MapPath("Static.mdb") objConn.Provider = "Microsoft.Jet.OLEDB.4.0" objConn.Open .....
the problem is tat i have two dropdown list, i have to select an option from one of them and the result will display it in another drop down list base on wad i selected earlier.
Then after clicking the submit button it will insert all this information into the database. but for right now it is inserting all the information once i select the option in my first dropdown list without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()" which is to submit the values from my first drop down list and display it to another dropdown list.
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --") { alert ("You can not select this option.") teamForm.newMember.focus(); return false; }
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of the dropdown with the value from the database. The value in the database is either new, trial, maint., employee, beta, or null. I need to set the dropdrown to one of these values. An example of the select;
i have this error in my form. okay i have two dropdown list which i have to slect an option in one of the drop down list an it will display the result in another drop down list and then by clicking the submit button it will display all the information into the database. but right now, the problem is tat after selecting an option frok the first dropdown list it is submitting into the database without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()" which will submit the values and retrieve sum other values and display it into the other dropdown list. i cant take this code away.
I have a drop down list on an asp page. Can I have tooltips for each item so when the user scrolls odwn through the drop down I display a tooltip (as some options are long and I do not want to incrase the width of my drop down).
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user has selected one value from the dropdown it should show values from (tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a button "GO" it should show all the value's from the database that been selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
I have what I thought was a simple script but I cant figure it out. Anyway, I want to set the selected item of a drop down list with information i am recieving from request.querystring. Seems like this is a case of when learning asp.net first is a hindrance to what i want to do. Im looking for something to the effect of,
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.
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.
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?
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).
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?
What I want is for an action to be triggered when a user selects something on a dropdown box.
The something would actually be two variables. One 'static' in that the drop down would be 1, 2, 3, 4 the other being a variable in the true sense e.g. if selection A is 2 and selection B was 3 then the variable is 5 and this variable is the one I want to use to trigger events.
Using themes I could maybe do it but I am hoping there is a easier, more dynamic way to do it.
I have managed to populate a dropdown box with a list of all files in the current folder and even filtered them by the extension so that it only displays the .mdb files. However, the menu seems to be holding all of the items in the folder and displaying only the .mdb.
This seems to be a problem with the way I am defining the size of the array. If I add my .mdb filter to the array loop I get an 'out of range' error for the n variable?? Can anyone suggest a solution??
We have dropdown on ASP page. The problem is we have about 900 items in the dropdown. Users scrolling through the list have become very frustrated in the past.
Can someone suggest if there is another way of implement a dropdown where the datalist is as big as ours.
I am looking for something like a listbox in VB where you can start typing the characters and the databelow moves accordingly until you have found what you want.
Is there anything in ASP/HTML to achieve a similar functionality.
This is just a test before i apply to my system. I have a student:
Table: Pelajar pelCode : 1001 (datatype: Number) pelName : Michael Lee (datatype: Text) countryCode : US (datatype: Text)
Table: Negara countryCode : US (datatype: Text) countryName : United States (datatype: Text)
i want to display this student's country name in the dropdown list as a selected country name and at the same time, populate all country names in the dropdown list. but, i can't make it. i saw the selected country name is country name that at the 1st row of table Negara ......
I have a page that has a form on it which has a dropdown list on it. It connect to an sql database and populate the list. What I would like to do is make the list editable so that if the data returned doesnt contain what I want, I can type in the data I require which will then be updated to the database when the form is posted. Hope I've made sense, you may be able to tell.
I would like to create dropdown box that would populate by query table in excel. Field would be base on names. Second when query is submitted it would return a report for that name with the value I specify as the results for that person name. Is it possible and where can I find information on this subject.
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?
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.
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:
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?
I am building a link exchagne for a medical web site. To get categories for the link exchange, I Googled "medical categories" and came up with a very, very good list of medical categories. they were seperated by a <br> tag. I went through the code and extracted all but the following (see below).
What I want to do is somehow create a list of "options" for this categories in a select dropdown, with the category being the value for the option AND displayed in the dropdown. You know what I mean. I would think it would involve reading in a text file and inserting the necessary code. Code:
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
