I am trying to find out how to select an item from a drop down menu after a query is executed. My drop down has 4 options, and what I am trying to do is if the record stored in the database is "option2" I need the drop down menu to have option2 is selected.
View RepliesDrop 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.
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 RelatedWhat would be the easiest way (JavaScript?) to have the attached form redirect a user to a sample business card on select from the drop down menu and response.write to the new file, carrying over the info the user inputs into the form? I want to change the response.write to the sample1.asp, sample2.asp etc.
View Replies View RelatedThe 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 list form object on my page:
<select name="item" size="5" multiple="multiple" id="item">
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
</select>
but i cant find anywhere about how to get at these elements when the forms been submitted. for example, if a few of the items have been select, it returns a commar delineated line, but how can i get at, say the 3rd item selected or find out how many items were selected?
how can i add item/s to a dropdown from another page. i am currently using window.opener to initial the link between the 2 different pages. i have 2 pages, main and sub page.
when i clicked on a button at the main page, it will pop out the sub page. when i clicked on the add button at the sub page, it will add the item into the dropdown list at the main page on the fly.
How do I make an item the selected one based of the info I get from a querystring.
ie:
1 - I pass in a query string containing the color "blue"
2 - I have a drop box that has 30 colors in it (inserted manually)
3 - How do I code to have blue the selected one?
I 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 RelatedI know that I can use instr(input,1) etc. but my attempts so far are of little use.
View Replies View RelatedI need to be able to have a drop down box wih several options, and what option you choose depends on what the next drop down ox has.
For example, a drop down box with countries: England, Wales, Scotland.
If you select England, you get the box below it saying Liverpool, Manchester.
I have an .asp page containing a form with (multiple) select/dropdown boxes. The page is submitted to itself.
Is there any way of retrieving the selected values (i.e. the text) in the select boxes server-side?
I'm looking for something like Request.Form("Select1").Value.
I've got three drop down menus which allows the user to select a date on a html form. The day drop down menu has the values 1-31, the month menu has values 1-12 etc etc. However i would like when the page is loaded for the current date to be present as the intially selected value in the menu. How can i apply the selected attribute of the current date.
View Replies View Relatedl've created an Access db with these fields (Title, Body and Section) Section field is Lookup column (About Me, Contact and Links). Also I created a form on add_data.asp to add data from it. On the form there's a Drop Down Menu. The peoblem is how to add from the drop down menu to the database. Here's my code:
View Replies View Relatedwe are working with the date of birth and have three drop down menus...my question is in the year because what we want is to make the drop down menu to start in 2006 not in 1906. Code:
<label>Year
<select name="select4">
<%
dim zzzz
dim a
zzzz = year(Date())
for a = CInt(zzzz)-100 to CInt(zzzz)
Response.write("<option value=""" & a & """>" & a & "</option>")
Next
%>
</select>
</label>
I am having some problems populating a drop down menu called province with data.
This is the error I am receving:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/fairmont/order.asp, line 85
I am sure there is data in the DB. I have attached the file.
Anyone know how to create a drop down menu where the user can enter text
also?
If they do not want to choose an answer from the drop down menu, the
users can just enter their own answers in the drop down box. Anyone
know if this is possible?
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 generate a dropdown menu form a ms sql database with two columns in it. I need both colums to show in the menu. I can't get it to work for the life of me. Code:
View Replies View Relatedi'm having some difficulty coding my dropdown menu's on a page, i want the contents of one to be dependent upon the value of the selected option of another.
View Replies View Relatedcan someone give me an example code for how to retrieve the selected value from a drop down menu in ASP. i have been trying something like this:
<%response.write(request.form("selected"))%>
but it doesn't display anything.
I have a form that I would like to create. My primary concern is 2 drop-down menus. The contents of the second drop down menu depend on the selection of the first drop-down menu.
For example: In the first drop-down menu, I want to select a department, and after a department is selected, I want to be able to select one of that department's employees from the second drop-down menu. Of course the content of the employee menu will depend on which department was selected.
I've been experimenting a little bit with my Access database, but how I design that really depends on suggestions I get here, so let me know what you think.
EDIT: I should also mention that the contents need to be read from the Access database, rather than storing everything in a javascript array. In this way, I can have Human Resources add new departments and employees via a web form so that I don't have to manually edit code every day.
I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.
I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either.
I have created a drop down menu populated from a database. Would this warrant posting?
View Replies View RelatedBelow is an extract from a form that i am writing. I need the user to be able to have a drop down menu of languages. How do I use the 'option value' command in ASP like you can do in HTML; so there is a list of languages for one to be selected. If someone could amend my code to give me a couple of language options so I can get an idea of how it is down.
<tr id="r_Lang">
<td class="ewTableHeader"><span>Language<span class='ewmsg'> *</span></span></td>
<td class="ewTableAltRow"><span id="cb_x_Lang">
<input type="text" name="x_Lang" id="x_Lang" size="30" maxlength="25" value="<%= Server.HTMLEncode(x_Lang&"") %>">
</span></td>
</tr>
I am working on an ASP website and my boss wants to have drop downs.
I have taken the existing code of menu includes but am unable to view
the drop downs. it just shows the url (menu.asp) in the browser but
doesnt throw the drop down.
How can I add a quick drop down menu to an asp page? I've tried to incorporate javascript and I can't seem to make it work. I want it to replace the current navigation on this page.
http://www.compsports.com/poll.asp?No=1
I am creating a "search by category" page using a drop down menu. I am very new at SQL/ASP and am having trouble with the correct syntax for sorting my search results.
Each category in drop down has an id ("catid"). Results need to show all Company names that fall under that specific category in alphabetical order. I have already completed a directory that is sorted alphabetically and tried to "borrow" some of that code:
I have an asp page with several txt feilds and drop down menus
on. I can validated as "required feilds" with the following code:
if (new_ex.elements["first_name"].value=="")
{ str_err += ("
Please enter your first name(s)") }
The validation below is for a drop down menu with mr, mrs, ms etc,
it doesnt work no matter how i try and solve this.
if (new_ex.elements["title"].value=="")
{ str_err += ("
Please enter your title, for example Mr or Mrs") }
Can anybody shed some light on this: Ive exaused all ideas.
i have one table called PAGES . in pages i have the following columns: page_Url, title, image etc... i would like to write a function/subroutine that is called that generates drop down list of all urls (PAGE_URL) from pages table. how can i do that?
what would the code look like?
I have created a dropdown menu that allows users to navigate and load other pages into a different frame (detail) than the one in which the dropdown is sited. All menu items and urls are stored in an access db.
Now I would like to try and make 2 improvements but I don't know how:
1. I would like to use the [Category] field in my data set to produce (non-clickable) headings in the drop down list. Code:
I have a dropdownlistbox (html control) and some text fields displayed on my page. The top menu bar of my page works fine in every case (as it always be on top of every thing that i display in my page) except of DropDown Combobox (html control). WHY ?
Can not understand the reason why my combobox always displayed on top when i tried to select some other item from my menu bar (say some other page) while my menu bar always on top for other controls.
How do i fatch value in dropdown menu in asp from MS access database....
How can I create two connection at a time...