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.
Can someone point to an example where dynamic drop-downs are populated? I would like to execute a sql statment and populate the items in dropdownbox1. I would also like to retrieve all possible values for dropdownbox2 and use Javascript to build an array that holds these values.
Then, I would like to scroll thru the array to select the correct values for dropdownbox2 based in the selection made in dropdownbox1. At last I would like to save the selected values for dropdownbox1 and dropdownbox2 to the database. I would appreciate very much if someone can give me code examples for each of the things listed above.
I'm orking on an online Catalogue, users are to select from a dropdown menu the finish they wish there goods in. The way I was thinking of doing this is have the finishes availiable stored in a column in the database - lets say 'finish' and the column would contain the finishes seperated by commas.. like red,blue,green,yellow etc, so the pull down menu would need to dynamically populate with these values.. is there an easy way of doing this, or am I going about it the wrong way?
View Replies View Relatedi am trying to create a drop down with information from a db. i am clueless as to what to do.
View Replies View RelatedI am trying to populate a drop down so that it shows the current date, plus the previous 6 days. Here is some pseudocode. I can't get it to work from here.
<SELECT name=Date>
<%
Dim d
d = Date()
for i=1 to 7
%>
<option><%=d-i%></option>
<% end for %>
</SELECT>
I have a recordset full of a list of courses.I want to create a search page, where the user can select the course from a drop down box, hit go and be taken to a page on that course. But some courses have 3 versions of that course, so for example I have 3 IT courses. so in the list it says
IT
IT
IT
How can I limit this to just display the value once in the drop down?
im looking at populating a drop down box with database values when a user selects a value from another drop down box.I have a drop down list that populates from database values, it is a list of manufactures. When a user selects a manufacture i want it to display all the systems for that manufacture which will be stored in a table. I understand that because asp is server side that once an option is selected the page would have to submit and then load the values in.
View Replies View RelatedI am trying to populate the drop down boxes. There should be two one for the begin date and the other for the end date. here is my code. The problem is that it wont create the drop downs. Code:
View Replies View RelatedI'm trying to pass information using POST. The first screen the user selects a company, and that variable is passed to the second page. On the second page, I am trying to populate a drop down list of usernames, but only those usernames that have the same company as the one selected on the prior page.
For some reason, the drop down list does not fill up with any names, and the rest of the form comes up blank(i.e. password, login, reset). Are there any glaring errors in this code? Code:
I was wondering if someone could help me with finding out how to populate a drop-down box with values queried from a database.
Also, I was also wondering if someone could help me with figuring out a way to place field-values retrieved from a table into a text field. This would be for the purpose of editing a record that has previously been entered.
Placing the information in a texbox field so that the user can easily type over it seems like the best thing to do.
I am trying with very little success to populate two drop down boxes in the same form when i do i get an error saying page cannot be displayed.
They do not need to be linked to each other in any way but they get the data from the same table I am new to ASP so this might be pretty easy to resolve.
I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
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>
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:
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 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...