Populate List/menu From A Database
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies
ADVERTISEMENT
Adding A New Entry To A List Menu Based On A Database
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
Populate Multiple DropDownMenu's Based On Previous Menu
I have a series of tables, within one database, which each hold unique information, all of which relates to one main table.
I would like to have 4 DropDownMenu's populate themselves based upon the choice of the previous menu.
Example.
Menu A contains four names - John, Henry, Larry, Ed.
When user selects Henry from Menu A, Menu B will show the following choices - Bread, Peanuts, Pickles, Chips.
When user selects Chips from Menu B, Menu C will show the following - BBQ, Ranch, Plain.
When user selects Plain from Menu C, Menu D will show the following - 1 oz., 5 oz., 8 oz.
All of those fields relate to individual tables that all contain a relationship to the main table. Is there a particular way in which I can populate multiple tables based upon the preceeding menu?
Dynamically Populate Drop Down Menu Option Value Problem
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...
Populate A List
I have a drop down menu that is populated from a database. the problem that I have is that alot of the numbers in the field are duplicated ie the field in question has years in it and may of the years are the same.
is it possible, when there are duplicated years, to populate the dropdown menu only once with that particular year. This would grately shorten the menu for me.
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:
Populate List Box Base On Combo Box Selection
how do i get a value from a combo box and populate a list box base on the selected value from a combo box? If possible can i get a sample coding.
View Replies View RelatedPopulate A Select List From A Comma Delimited Txt File
I would like to use ASP to populate a select list from a comma delimited txt file.....
View Replies View RelatedList Menu
I need to create a page which updates a products information within a record.
the tables are,
products (ID,CatID,sID)
supplier (sID,sName),
category (CatID, CatName)
The above tables supplier and category have relationships to products by using the sID and CatID
I need to update the product details by having a select/option for a supplier and category but if not changed by the user the value already within products table stays the same, therefore the list must be dynamic so that the first item in the list is the one relating to the value in the products table. Also the value must be the ID numbers but must display the names not the ID's to the users within the select/option.
Menu List
I have a form page in ASP where the first menu/list function as a filter of
the second menu list. Once I select an item form the first combo I get the
second menu full of options. This is correct. My probem is that the first
combo gets the default value again and I do not see what I did choose.
Menu/List Validation
how to validate a menu/list? I can use dreamweaver to validate a text field but not a menu/list.
View Replies View RelatedList Menu With Name Of Files
How can I make and populate list menu with name of files from one folder and then select one of their?
View Replies View RelatedRead In List Menu Value Into Asp
does anyone know how to read in a list menu value into asp? I need to get the value and then display results with it.
View Replies View RelatedDynamic List Menu
I could not solve for the past 3 days. I am try to build a website using ASP and VBscript. I am still a newbie to it.Let's get to the problem. What I am trying to do is to have multiple dropdown list. Each list menu ( except the 1st) dependes on the choice made in the one above.
I am using dreamweaver, it did generate a the form and everything and I was able to filter the results. The problem is that I don't know HOW TO REFRESH THE LIST. In other words, I can't figure out how to change the list menu options when the choices above change. I have tried to find some tutorial about it, but all I found was with JavaScript and I don't wanna mix VBS with JS.
Dynamic List Menu
Does anyone know how to make it so that when someone clicks on certain menu item on one list it automatically updates a second list with values.For example,if i click the Make of a car in one list, i want the second list to automatically update with the relative Models.
I've seen it done on various sites such as www.autotrader.co.uk but can't think how its done. So far i'm populating the first list dynamically with a database but don't know what the next step is to get the second one to do it.
Dynamic Menu/List
I currently have an "Add customer" page on my site. On this page you can choose multiple "brands" from a list box. (These brands are dynamic and come from a seperate table in my db). These brands are split up into an array and each added as a row to a database table.
Now I am working on a "Modify customer" page. It has all the same fields as my Add page except that the fields are already filled in with information from the db. I can't seem to figure out how to have my list box have multiple items selected when you first come to the page.
How To Remove Blanks From A List Menu??
One of my tables is used for two purposes so there are blanks in the column I'm filtering. I tried using an IF statement but it still put the blanks in the list menu. Any idea how to remove the blank items? Code:
View Replies View RelatedHow To Pass Dynamic List/menu In Forms?
I have a form called form1.asp which has 10 dynamic list menus. This is the code for one of them. In this form I have a recordset. Code:
View Replies View RelatedList Box Should Display Underneath Menu Window
I am trying to create a menu for asp.net page. The menu-detail list display, when mouse hovers over the main menu list, like you see in regular windows apps.
When the detail-menu-list window displays, it goes 'behind' combo box (sent to back). For other controls, like textbox, it is fine. Can some explain, how can I send the list box (<asp:listbox>) to become the underneath and not display on top?
Annoying Problem With List/menu 'selected'
I 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...
Combine List Menu Fields For Email Output
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour
2. user selects minute
3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
Here is the asp code for the form: ......
Changing The Value Of A Textbox Based Upon The Selection Of A Menu/list Box
I have a menu box with dynamic values from a recordset (value = 'Size' column)
I then have a textbox for which I want to display the 'Price' column according to the record selected in the menu box.
Dropdown Menu/list Issue Pulling Records From Access Db
I am trying set up a page where the user can view records chosen by the year.
I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
Populate Array From Database
I need to populate an array with two columns of data from a database eg Firstname and second name and sorte alphabetically. So both of these columns go in to one array, I found this code.
View Replies View RelatedPopulate Dropdown With Image AND Text From The Database?
I have two columns in my microsoft access database.
1st column is company_logo (jpg image)
2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
Does anyone knows if this could be done?
Maybe I should stick just with the textual part?
Database View Form Populate (query Issue)
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View Replies View RelatedPopulate A Popup Window With Clickable Records From An Access DB And Upon Clicking, Populate A Selectbox On The Original Webpage With The Clicked Record
We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)
We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)
We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.
(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.
Pop Up Menu - From Database
Can anyone recommend, pop up /hover menu that populates data from the database? At the moment we are using http://dhtmlcentral.com/projects/coolmenus/ but it seems to take a while to load. I'm just wondering if there is more efficient script available.
View Replies View RelatedDropDown Menu And DataBase
I have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
How Can I Post Contents Of A Menu To A Database?
I've created a web form that will post to an Access database. All of
the form fields correctly save to the database upon submit using:
<td><font face="MS Gothic">Site:</td><td><INPUT TYPE="TEXT"
NAME="Site"></td>
Below is what I have for one of the drop-down menus. Could anyone help
with how to add the VB code to this so that the selected menu item
will submit to the database as well? Code:
Drop Down Menu Auto Genrate From Database
I need to create a drop down list that will auto Generate numbers from 1-60.
So when they select the drop down list, it will display 1 thought to 60.
Mssql Database Driven Spry Type Horizontal Menu
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replies View Related