ASP :: Dynamic Drop Down List

Dynamic Drop Down List!
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?

Dynamic Drop Down List
I hope this is the right group. I am very new to ASP so this is
probably a stupid question. I have some vbscript that query's AD and
populates a recordset. I know the recorset contains the information I
want by doing a Response.write. I am having problems dynamically
creating a drop down list from the data in the recordset. The drop down
is created but it is empty. Code:

Dynamic Drop Down List
I need advice how to reduce the size of my drop down list which is created dynamically using a field from my database. If you visit this link you'll see as the box is too long it's knocked out the whole look of the page. Other than shortening the names of the businesses, is there anything else I can do?
My concern is that next year sometime after this site has gone live, it will be maintained with a content manager by people with no IT expertise.

Dynamic Drop Down List
i want to retrieve the value from Mircrosoft Access database into the drop down list..it works.. so its dynamically..

but the problem is.. how could i redirect from the dynamic drop down list to other page.actually this page mostly like a search page.

Dynamic Drop Down List
I have a web tool written in ASP. One of the feature is dynamic drop down list which updates a drop down list as another drop down list is changed.I uses javascript to reload the same page to update the drop down list.Everything works fine on the webpage using desktop/laptop.

However, it doesn't work on my mobile device(i.e. one drop down list doesn't get updated as another drop down is changed)how to make it works on mobile device? Should I integrate ASP with another technology,. WAP maybe?

Dynamic Drop Down List Problem
I have an asp application which I made "Multilanguage". I made an asp file
for every language with all the strings to be used stored like this:

Langstring1 = "French"
Langstring20 = "VTest"

In the beginning of an asp file I determine which language file to include.
In my database there are only numbers. I can now display the right text in
the right language using respons.write: Response.write(Langstring20)

Now I want to use a dropdown box displaying a text as selected based on a
relation between the number in my database and my language files. When I
have number 20 in a database, the value of the option should be 20 and the
text displayed should be 'VTest' for this is Langstring20. Problem is that
the option value seems to be correct with what I do, but the text displayed
in the box is not correct. How can I solve this? Code:

Drop Down List
Im using a drop down list for user to select their option. (For example the user selected type2) All goes fine for saving, but when I retrieve the info from database to be display on the same form on the same drop down list, it display Select Heretype2

<select name="type">
<option value="<%=type%>">Select Here<%=type%></option>
<option value="type1">type1</option>
<option value="type2">type2</option>
</select>

How to overcome this?

Drop Down List
I want to save the value of the option in a cookies choosed by a user in a drop down list in ASP page. After OnChange"........ what should I write?

Drop-down List
I'm sure an ASP programmer would be able to create this function within 5 minutes, but I'm just learning and I've fumbled my way through creating a little site content management system for a local community group. I'm a designer and the site looks great (so I'm told) but I just can't get this last page to work. I'm desperate for help!!!

I'm trying to call the values for a drop-down list from a seperate categories table in Access, to add/update records in a main Access table/query. The page/form is used to:

a) diplay/edit existing records; or
b) add new (if cstr = "").

I have finally managed to display the correct selection in the drop-down list for existing records (not sure if code is correct?) but I can't work out how to write changes (edit record) back to the database; or 'save' a new record? I'm also not sure if I should be trying to write data to the table or query? Code:

Drop Down List
how do i maintain the drop down value.. when i click on the "All" it cant be maintained... jsut that "All"... others values works fine.. Code:

Drop Down List
I have a page which displays all the fields in a table of my dbase. One of the fields in the database was previously populated by a drop down box.
My question is, is it possible to display the same drop down box with the value that has been populated from the table so it can be updated?

Drop Down List
Does anyone has some sample code or know any resources for using ASP and Javascript to dynamiclly create a drop down list?
(ie. Once the user selects a drop down list, ASP gets the selected value and go to database to get another set of new values. then creates a drop down list of all the new values)

Drop Down List
I am working on a project where people can search my database from the web. I have a drop down list on the page but I am having a hard time trying to code it so that when someone picks a title from the drop down list they only get the people with the same title as selected by user.

Drop Down List Box
i want to create one asp file using vbscript which will contain a form which gets informations like name, company and contact details(address, phone, email) of the user.

i want to use one dynamic drop down list box of which that drop down box will contain all the previous names entered in the past along with the option "add new name" at the beginning of all the names so that if anyone wants to add new name to the database they can click it and if already entered member browses that page he can select his/her name which will populate all the details down below like his company and contact details and if he wants he can make some changes in it and update in the database.

i tried searching tutorials for this but what i found was only for client-side javascript.

Drop Down List
i have a drop down list from with i choose a company name.after i choose the company name i want to go to a page where it displays all there details.what would be the most easiest way to do this?

Drop Down List
i have a drop down list box and i want to fill it with the options from the table i have called courses i want to fill the drop down list with what ever is in the courses table location field, e.g if there is scotland in the location field i want that to be shown so the user can select it, but i dont want repeating data to come up for example if there is 2 courses with the scotland i dont want 2 scotlands in the the drop down box.

Drop Down List
I want a new drop down list to display suppliers name, i have a stored procedure to get me this information, so am going to call a 2nd stored procedure on my .asp page and populate the drop down list with its values , would this be the best way to do this ?

I then need some way to link the supplier name to the supplier code so i can filter the report when i select the supplier name it will return the result for all the supplier codes in the report.

Drop Down List
I have a drop down list with 60 values in it. When I click on the drop down list it shows 30 values and the scroll bar. I only want it to show 10 values and the scroll bar. How do I set this limit for the number of values that are displayed at a time.

Drop Down List
I have created a page which contains 4 drop down lists.When loading the page itself i am filling up the first drop down list.Depeding upon the selection of the item in the first one,without submitting the page,the second list should fill.

And according to the selection of that the third one and so onn.The probelm is that i want to do this without using the OnChange method in the select.I am stucked now.

Adding A Drop Down List
I have an asp page that creates a table from a Ingres II database. The headers at the top of the columns are hyperlinks that ad a order by to my list. This was all working fine until I added more choices with a drop down list view_type .

Now I am getting this error:
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I am thinking it has to do with when my list is reordered it does not know which view type and is not going through the count. Code:

Using Asp And Xml To Fill A Drop Down List
I have an asp page right now and I want to fill a drop-down list with
information like a persons name from an xml file. Once the user picks a
person from the drop down list I want it to go back to the xml file and
load the information about the person into textboxes. Does anybody have
an example for something like this in asp?

Drop Down List Prob~
Im having a form for user to enter fields. One of the requirements is to enter the school name. To overcome a difficult and long drop down list. How would like to let the user select from a "state" drop down list first, and it automatically will change the drop down list of the "school" under the selected state. How do I do that?

Drop Down List Problems
I have a problem when passing the selected text from a databound dropdownlist. No matter which item that you select in the list the first item is always returned in the customerdrop.selecteditem.text.

How do i get the actual 'selected item' back? Code is below! I call the contactshow sub to populate the dropdownlist, and this in turn calls the bindlist sub. Code:

Populate Drop Down List
I'm trying to populate a drop down list with values found in the Project and ProjectAllocation.

The Project Table consist of all the Project Details like Name,Location, Date,etc.

Whereas the ProjectAllocation consist of only 2 fields, ProjectID & EmpID (this is bcos one project can have many employees). Code:

Using XML To Populate DROP DOWN LIST
I have a small problem using SSJS, I have an ASP web form that populates an XML form, I then want to Select a field with the id="group" from the XML file and write it into a SELECT Field of another WEB Form but I am having Problem,

I taught I had this conquered when I had the form as HTML as follows:

Code:

Dependent Drop Down List
provide 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.

Drop Down List Populated
I have a drop down list that is populated by a database, all the items are pure text.

I am using this line of code:
msgbox(listAccom.Items(listAccom.SelectedIndex).text)

but no matter what item is selected it always returns the very first value. However Identical code works on a different page I have created. Can anyone offer suggestions as to why this might be.

Drop Down List From Db Table
I already know how to create a drop down list that reads from a database. However, how can i make a drop down list that reads from a table but it automatically selects a specific row instead of the first row?

Add The Default ALL In Drop Down List
i want to add the deafault "ALL " in the list, how to add? and when i select ALL , it would print out all data in Name field.

<%
sVar = Request.QueryString("Name") 'request from Name field
If Not Request("Name") = "" Then
strSQL = "SELECT Name,TagName,MinTLV FROM Folder where Name='" & sVar &"'"
rs.Open strSQL, conn
%>

Updating Drop-down List
I would ideally like to present an initial list based on one DB table. The user selects an item, and the 2nd list is updated to show items from the DB related to the first selection. As I understand it, there are a number of possible solutions, but I dont
know much about any of them, nor which is currently the recommended route.

This is going to be applied in an intranet application, so it gives me a bit of freedom to use the technology I wish, but if there is an accessible solution (as in WAI) that would be great.

Drop-down List And Table
I have drop-down list with product categories and next to it I've got a table with list of products. I've managed to make them to read the data from the data base. In drop-down list i have names of 6 categories and in the table i have names of all my products I've got in the data Base, but i couldn't make the table showing only those products depending on which category name has been selected in the drop-down list.

Dynamic Drop Down Box
i have two drop down boxes: student id and student name on a web form.

a database (ms access) has the student id and student name fields in a table.

the drop down boxes should get their values from the table's fields respectively.

i am ok with that (using asp) but my requirement is as follows:

once i select a studentid from textbox1 then automatically the textbox2 should be selected with the corresponding student name.

how can i do this using asp? or can javascript do the job too?

Drop Down List With Linked Fields
I want to create an asp page from these forms in my database:

Database:
Table 1 =>
1.1) ID:
1.2) Product Name
1.3) Description

Table 2 => For the ASP Form
2.1) ID:
2.2) Text field 1 (Normal input field)
2.3) Product (Dropdown Menu, Data Source Table 1, Field 1.2)
2.4) Description (Text Field, Data Source Table 1, Field 1.3)

The Description value should be in correlation with the Dropdown Menu value in Table 1

ASP Populated Drop Down List With 'selected'
I have a simple form on my site with a drop down list for users to search for a specific category. The search works fine and populates my results page with the correct responses.

Alongside the results I have included the search form again so that users can modify their search, however I am unable to pre-populate the drop down menu with the previously selected category.

I have tried an IF statement but this only works when I hard code the variables in. Please can you cast your expert eyes over my code, I have a feeling I am suffering from fatigue as I have been trying to solve this for some time now. Code:

Filter 2nd Drop Down List Value From DIFFERENT Tables
I have coded 2 drop down lists. For ur info, currently my 2nd drop down list's content is being retrieved from one single table in database only. What if I would like to make the content of my 2nd drop down list to be populated with data from 2 different tables?

What i mean here is that, the selected value in 1st drop down list will determine data from which table to be loaded into the 2nd drop down list. Earlier I'ved coded my SQL statement as:

SQL = "SELECT x.language_ID, x.language_name, y.msg_category " &_
"FROM Language x INNER JOIN outMessageENContent y " &_
"ON x.language_ID = y.language_ID"

where data for 1st drop down list is loaded from table x and data for 2nd drop down list is loaded from table y.

My 1st drop down list only has 2 values., which are 'English' and 'Chinese'.Now I would like to make it as, if user select 'English', then my 2nd drop down list will refer to that particular 'English' table, while selecting 'Chinese' will allow 'Chinese' table's data to be loaded into my 2nd drop down list.

So what shall I change in order to filter the 2nd drop down list's content according to the selection from 1st drop down list? Shall I modify my SQL statements?

Drop Down List Selection As Parameter To A SP
I working on an ASP page that has a drop down list that gets its contents from a SQL table.

Can anyone show me how to use the selected item from the drop down list and use it as a parameter in calling SQL stored procedure (this procedure simply updates a table so there are no result sets).

I have designed my page to include a submit button and was wondering if it is possible to call the procedure as soon as the submit button is clicked. I get really confused with whether to use a server side or client side script.

How To Make A Value Being Selected In A Drop Down List?
I have coded 2 drop down list and below is my code:

Cookie Values In Drop Down List
I know how to write cookies and how to call cookies. But how do I write the values of a drop down list and the value of a radio button list to a cookie and call them to select the correct options when the page is reloaded?

Format Font Drop Down List
Not sure if this is an asp question i think its more of an html question but not too sure how to change the font of the drop down list here is the code, any ideas on where i should but the <font> tag? Code:

<td width="27"> </div></td>
<td width="40"><span class="hotsubtitle">Account Name:</span></td>
<td width="42"><select name="Account_Name" class="relatedLinkTitle">
<option>ALL</option><%=Request.Querystring ("Account_Name")%>

Option Selected In Drop Down List
What is the way to make an option in a drop down box selected if dependant upon a variable.eg have list of states and once a customer has been selected the state reflects the customers state in say an edit customer form.

Binding Textfield To Drop Down List
How to bind a drop down list to a textfield??? I want the textfield value to change for every different option selected in the drop down list.

Dynamic Drop Down Menu
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.

Dynamic Drop Down Lists
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.

Validation For Dynamic Drop Down?
This will display all records in PropSec table order by SecSort column which has values like '01', '02', '03', '04' and etc.

The reason for this is that i want to sort the records according to the SecSort, '01' first followed by '02' and so on. There musn't be a same value in the drop down box. The no. of records can increase, & not necessary fix to 3 records only.

MS Access db design :
Secsort = text(2)
Title = text(20)

Expected Outcome:

I would want to check to see that the user does not select the same value twice, i.e to prompt out an error message if it does. I am really confused as how to do a dynamic checking when there is no specific field name to check against.

The checking can be done in the secsort.asp or secsort_rs.asp. As long as it can detect the same values & prompt error msg, i am very happy.....

Dynamic Drop Down W/ No Refresh?
I have a dynamic drop down being populated by a db and then the second drop down is populated depending on what was selected in the first. When it does this though the page refreshes. Is there a way to do this without a page refresh?

I dont think using javascript and arrays is an option cause I am doing this with states and cities and there are about 75,000 records in the db that it is lookin through. Code:

Dynamic Drop Down Lists
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??).

Posting A Selected Option (drop Down List)
I cannot get the selected option to be POSTed (it does not appear in the
QueryString when using GET neither)

I construct the drop down list from an array, I select an element in the
list, I POST using a submit button. When I use Request.Form("NAME") it's
always empty. Is the selected item is Posted? How to retreive it?

Response.Write "<SELECT NAME>"
for i = LBound(aRessource, 1) to UBound(aRessource, 1)
Response.Write "<OPTION VALUE=" & i & ">"
Response.Write aRessource(i, 0)
next
Response.Write "<OPTION SELECTED>"
Response.Write "</SELECT>"

Pop Up Text Area After Click Yes From Drop Down List
I want to write a asp script, basically, that has drop down box in the form, if user select Yes, on the same page, a hidden textarea will show up, if user select No,
then nothing happen.

so far, my code is unsuccessful, in addition, I also got syntax error on the response.write line anyone has idea. Code:

Multiple Dynamic Drop Downs
Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code: