I'm developing a form in which people can choose to attach articles to numerous countries. I.E if someone was writing about the Commonwealth Games we could attach the article to all of the Nations in the Commonwelth. However, implementing this code wise is proving a headache. Code:
View RepliesI am populating a SELECT list from a result set. I need the same result set to populate a second SELECT list. Only one list is being populated. How can I get this to populate both? Here is my code:
<select name="options" size=10 multiple="multiple">
<% while (!rs.EOF) { %>
<option value="<%=(rs.Fields.Item("FIELD1").Value)%>">
<%=(rs.Fields.Item("FIELD1").Value)%>
</option>
<% rs.MoveNext(); }
if (rs.CursorType > 0) {
if (!rs.BOF) rs.MoveFirst();
} else {
rs.Requery();
}
%>
</select>
Is there a quick and easy way to take the results of a query and turn it into a list?
I I run a query and return 15 records (of 1 value each) how can I turn it into 1,2,3,4,5,6,7.....
Can anyone here recommend some service for opt in email lists. My problem is that most services will take the user off the site to sign them up and the forms are very basic. I have some complex quote forms and contact forms where people can input alot of information. I'd like to be able to add people to this subscription list if they want after processing the detailed information that they have entered. But at the same time I want to keep users in categories based on the industries that they are in so we can send targeted emails based on their industry. Does anyone know of a such a services? I've looked into listserv and lyris list manager, but I won't be able to install these apps on the webserver. So they are pretty much useless. Does anyone have any experience with this?
View Replies View RelatedI have a SELECT element on my asp that is autopopulated from a search button.
Currently, the user inputs the saecrh term, clicks the button and the drop
down is populated from the DB. The user then select from the list. Everything
simple thus far.Now I have been asked if I can get the drop down to open automatically
(apparently to save the users the extra click of opening the list!!!), but I
cannot find out how to automate this (then again, I have little momentum to
do so at this stage) and I know this request will rear it's head again
shortly.
Does anybody know where I can get some standard lists like
- a list of all countries in the world (with abbreviation, international prefix...
- a list of common christian names (aaron, abbey, adeline...
- a list of all currencie
- a list of all language
in txt/xls/mdb or whatever format
iv searched the forums and kind find anything that fits what im looking for.
I have made an online store, but am having problems with displaying multiple different dropdown options for different products, that are listed in a repeat region
i use dreamweaver 8, and ms access Code:
I have a form with two drop down list. I need the list items to vary by what I select. Ok..short and sweet. I have a list of dates in one....in the other I have a list of events. If I select a date in the first drop down I only wanna see the events for that day. Also if I select an event I only wanna see the dates for that event! What is the best way to go about doing this....and please dummy it down for me...I suck at sql to be honest.
View Replies View RelatedNot sure if this is posible but how do you create a dropdown box where if you type a "c" it takes you to the start of the c's then if you type an "h" it takes you to the ch's etct .
View Replies View RelatedI' m using a multiselect list but I have to press Ctrl when I want to choose more than one records. How can I select records without pressing Ctrl? Code:
View Replies View Relatedhelp me with making a repeating "dynamic list/menu" . i use dreamweaver and when i put a "repeat region" on a "dynamic list/menu" the page just keeps loading forever. do i need to change the default coding dreamweaver makes...iv been trying to figure this out for literally weeks, and im about to give up. I know it can be done becuase iv seen it done.
View Replies View RelatedIs it possible to sort dropdown lists alphabetically via a recordset without using SQL statements?
View Replies View Relatedhow I could achieve the following. I am looking to create an asp page with a dropdown list and associated values. When the user selects a value from the list, i would like to store this value into an dynamic array, as i am looking to use the array to calculate some values. Is this possible?
View Replies View RelatedI am displaying lists from a database just fine. There are 5 items in an unordered list that can be displayed. My problem is that if I have less than five, the emty list items will display a bullet.
How can I opt to only display list items if there is data in the field, and if a field is left empty to no display anything at all (in this case the bullet).
I have been looking for mailing list scripts, but discover that they all seem to be for "newsletter" type lists rather than debating lists. Are there any that can be used to allow all subscribers to post?
View Replies View RelatedI am building an online shop, i wish to select all the sizes out of a table and polutate a drop down list with the selection, then dependant on what size you selected it offers the quality available in another dropdown list based on the amount recovered from the database relating to that size.
I know this can be done is javascipt, but have no idea what to search google for, nor where to start, any ideas would be good .
I need to populate a list box with values that will be determined by the selection of another list. What it is, is when we add a user, they get added to a city, eg Townsville and then there are a heap of groups that only apply to Townsville people.
So once I select Townsville as the location, I want to perform a search in AD and return the list of groups in the Townsville OU.
I am not exactly sure of the appropriate method to handle this in asp. If necessary, I could make a third page and just pass values to that from the second page. Is there a better way?
In case you are wondering, there are currently two pages. One is for use by supervisors/managers, and they fill out some details which get put into a URL that is emailed to the administrators.
Clicking on the link fills out the base form for the admin people, but I want them to have more access and to see more than the managers/supervisors that are submitting the request.
I am creating an employee feedback portion on my company's intranet. The purpose for this is so that a project manager can give feedback to human resources regarding members of their teams. When the project manager gets through with the feedback, an e-mail gets generated and sent to an HR rep and to the person being evaluated. What I would like to do is the following:
-When the Project Manager goes to the portion of the site I am going to take the value in the LOGON_USER and query AD for his/her e-mail address so that there is no room for human error in filling it in
-I would like to populate a drop-down list with all of the users in the GAL for the PM to select from to give feedback on
-I would like all distribution lists excluded from the drop-down, only actual users should be shown. Code:
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:
View Replies View RelatedI am trying to take actions using onchange with an option list without success.
I am not able to fully populate the list without a bad bad behavior (the list is not getting populated)
What I am looking for, is being able to call a sub procedure each time a new item in the list is selected (of course after it has been populated)
Below some of the code: ....
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.
i will be launching a site on which i will have a birthday reminder service along with some other features. Site is being made with the help of ASP and MS-Access. its birthday reminder service is a bit similar to that of birthdayalarm.com. Now if you go to www.birthdayalarm.com you will notice that when it gives you an option to add birthdays to your list, it allows you to get access to your msn list on that very site..a user just has to enter his msn id and password on that site and then it shows his full contact list, and then with just one click it can e-mail all those users in the contact list. I want that kind of a system with which users on my site can have access to their msn and yahoo contact list...after they provide their user id and password. Similar system is also integrated at www.friendster.com to invite friends. Does someone has any idea on how that thing can be made available on my site...any help would be greatly appreciated as its a really important part of my site.
View Replies View Relatedwhether anyone had any knowledge of the use of dependant drop downs? For example i would like to choose a product based on the type i.e computer hardware, monitor etc then a list of all products of the same type be displayed in a following dropdown.
Any examples of similar things done, urls to try, your own experience? How simple is it to implement?
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??).
I am somewhat famialiar with ASP.net but I am trying to use ASP. I want to dynamically load drop down lists from an already created MySQL DB. I already have the table build and all the fields, and what not but I can't figure out how to load the values of a drop down list with the records from a column.
View Replies View RelatedI want to have dependent dynamic dropdown lists where the person can select the state, then county, then zip code, and all 3 of these menus will be populated by a database. I have a page that Ive been working on but I just cant get it. The page I am working on also refreshes when you select the state, then when you select the county it refreshes again but instead of populating the zipcode list it just takes the state name and inserts it into the city menu. Code:
View Replies View RelatedI have an ASP-page where I want to be able to select a fabric and color of that fabric. Since different fabrics comes with different colors I want to have a form with two drop-down lists where selection of fabric in the first list populates the second list with the right set of colors. I need to have the lists in the same form so it only require one submit.
View Replies View RelatedI have a drop down box(Yes, no) if users select Yes that is suppose to bring up another drop down list with a list of choices.
I was told by someone that the best way to go about is to create the second drop down list and make it read only, but make it editable when Yes from the previous drop down list is selected.
i have a SQL Server (2005) and am attempting to populate 3 combo boxes by using SQL stored procedures.
The problem is that I cannot find out how to link the second combobox to the first using a selectedIndex method and the same with the last in relation to the second box. I can always pass from page-to-page, but that would be extremely inconvenient and time consuming for the user. Here is what I have so far: Code:
Trying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?
View Replies View RelatedBasically, I have 2 separate drop-down lists, we'll call them List1 and List2.
Say List1 contains:
Fruits
Months
Sex
Now, I would like all 2 lists to be on the same page. A user would proceed to select something from List1, say "Fruits". Upon clicking on the drop down list for List2, the list items should automatically be updated to predefined items, say "Apples", "Oranges" and "Pears".
if the user changes his mind and goes back to select "Months" from List1, List2 should immediately display stuff pertaining to List1 items, say "January", "February", "March" etc etc....
I am having trouble with the ordering page. I would like a dynamic form list to look at a database and when the user selects a product code, the text boxes containing description and price change too to reflect the product code.
The user will be entering in their contact details, so I dont want the page to reload too because I will lose that info. Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.