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.
View RepliesI 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>"
I have page 1, that has a drop down box with codes. The user could either select a code or click a link that opens a page with a drop down consisting of descriptions.this is what I am trying to do.When user selects an option in page 2 drop down, the page 2 should be closed and the selected value should be inserted in page 1 drop down. How could I do this in asp?
View Replies View RelatedI 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:
I have coded 2 drop down list and below is my code:
View Replies View RelatedI am having a drop down list and other text boxes in a form. I need to retrive and fill text boxes from database depending on the selected item in drop down list. I am using javascript as scripting language. Can any body give solution.
View Replies View Relatedwhat I want to do is - the user is presented with a form with a drop down box at the top with two options - Yes or No, If No is selected then the form stays as is and the user can complete the other text boxes.
However, if the user selects yes I want the page to refresh with a different set of input boxes.
The 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 have a form named: 'formhandheld' and a select with the name: 'pricing_option'.
I'm trying to make the select <option> thats based on 'axDD3current' selected.
what's the code ? Probably more of a JavaScript question than ASP
document.formhandheld.pricing_option.options[<%=axDD3current%>].selected;
the above doesn't work
I am displaying few values in a List box. I would like to put first item as selected by default. i.e <option value="some value" selected>Name</option>
Here is my code.
<SELECT size=15 id=select1 name=select1>
<% do while not Rs.EOF %>
<Option value=<%=Rs("value")%>><%= Rs("Name") %></Option>
<%
Rs.MoveNext
loop
%>
</SELECT>
I have a dropdown menu with parents' names, and on the same page when a name is selected (through an onChange event), another drop dpwn boix containing student names change according to the parent selected.
But I want the Parent drop down box to contain the parent's name who was selected, and although the event works, it just keeps displaying the first name of the list of parents even after a different parent is selected.
I am still trying to get my feet wet with ASP, VBScript, and MS SQL here and I am trying to create a very useful page where I can eaisly view my SQL tables and the columns within those tables.
I have two SQL scripts that work well, one to display the tables within my database and one that shows me the column names in that table.
I created a form, added a drop down selection and coded it so the table names appear in the drop down, then added a "Submit" button.
What I am trying to do is get the page to display the column names below based on the table name I select from the drop down list.
ISSUE #1: I cannot seem to get the table name when chosen from the drop down to pass it's value to the second query so it can display the results.
ISSUE #2: How do I display these results from the chosen table name based on the column script below? Code:
Is there a way to have a drop down menu where u can select an option from the menu or type in ur own??? I am using ASP and SQL
View Replies View RelatedI have a list box with a number of values (4) on a ASP form, the value is stored in a database field.
When a form to amend the record is loaded, I would like to display the list box with the currently held value as the seleceted item in the list box. e.g.
4 items in listbox A B C D
B selected and saved.
Amendment form displayed, List box contains A B C D, with B highlighted.
Is this possible with ASP?
Drop Down Menu as follows:
<select name="county" id="county" >
<option value=''> Select County</option>
<option value='Antrim'> Antrim</option>
<option value='Armagh'> Armagh</option>
<option value='Carlow'> Carlow</option>
</select>
Problem is when there is an error with one of the other fields and the press reloads the county is reset to Select County how can i remember this value.
I'm building a page to update an existing database entry. On the form to do so, I have a basic select option menu as such:
<select size="1" name="ColR" style="width: 115px">
<option value="FFFFFF">White</option>
<option value="000000">Black</option>
<option value="FF0000">Red</option>
<option value="FF9900">Orange</option>
<option value="FFFF00">Yellow</option>
<option value="008000">Green</option>
<option value="0000FF">Blue</option>
<option value="4B0082">Indigo</option>
<option value="9400D3">Violet</option>
</select>
I'd like to have the option that matches the current value in the database field display as the selected option. I know it's easy enough to manually force one option or another to be selected, but how could I change which one it is based on the database contents?
I have dynamcally populated a drop down menu with data from an access
database using ASP. The values seem fine, however when i pass them to
the next page (using form get method) the whitespaces in the values
are ignored.
For example with <option value=jim jones> then only "jim"
gets passed to the next page not "jim jones". I have viewed the source
created on the dynamic page and the values are populated fine, but
passing to the next page seems to be problematic...
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.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
View Replies View RelatedI 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...
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?
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?
View Replies View RelatedI'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:
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:
View Replies View RelatedI 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?
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)
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.
View Replies View Relatedi 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.
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?
View Replies View Relatedi 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.
View Replies View RelatedI 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.
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.
View Replies View RelatedI 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.