I have a form that will add a device to a database. What I am having a problem with is that I have two drop down boxes. One is a building number and the other one is a room name. Because there are many room names that are the same in many of the buildings and some room names that are not in all of the buildings, I have created a table called buildings and another table called rooms.
I have a drop down menu that displays all the building numbers and what I want to be able to do is when I select the specific building number, another dropdown box appears showing all the room names for that specific building. I also what to be able to keep the information already on the form intact. As an example, a user puts in information on the form such as the machine name, username and then selected a building name, which would then show the rooms in that specific building, maintaining the information of the machine name and username on the form. There are seven items on the form, which the user must include prior to submission of the form.
I have been looking through the forum trying to find an example but with no luck! I have three drop down boxes for displaying a date i.e. day, month, year. I have an edit page which I want to allow the user to update their details. When the choose to edit their page the date stored in the database is split into the three values i.e. day, month, year.
I want to set the selected property for each of the three drop downs boxes based on the date already stored. My question is "Is this possible?" or do I just have to display the dropdowns with default values selected i.e. 1 Jan 1970.
I have a form, all the drop down boxes are populated from fields in tables in a database ive made. This part is working fine. The fields are for IT components and each one has a price in a seperate field.
Im trying to store the price to a session when the user selects. When the page loads and the drop down lists are populated I am loading the price values in also but not displaying them. So far my code for it is this: Code:
I am creating a search form on my website. The user will be able to search via zip code, county or state. If the user selects the state option from the drop down box, I would like another dropdown box to appear on the page with all the states listed. I think you have to use javascript but i'm not sure.
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.
I am now on the write track for detecting and acting on a variables value. Could someone please have a look over it and see where it is falling out. The help really would be appreciated.
The reason for vTime = vTimex + VTimex1 etc... is because once I get the first part working I will then continue to add up the value until it reaches four. I believe once I get the first part working I can adapt it for the second part. Code:
I've gotten the dependent drop down boxes to work except, when I fill out the form, and get to where I click the first drop down box and make a selection, the page refreshes and all of the fields turn blank, except for the second drop down box, which displays the correct records based on what was chosen in the first box in the entire form. Also the first drop down box returns to the first record in the list.
I am strugling to make a Multi Drop Down Search boxes. The main concept is to be able to make a search following some pre-defined dropdown boxes. I would like to search for a specific event in mathematics (for exampel) from a specific time (between different centurie).
- boex1 has a series of categories (Doctors, mathematicians..) - BoxA has a range of centuries from 1500 to 2000 (1500- 1600...) - BoxB has a range of centuries from 1500 to 2000 (1500- 1600...)
I have a form with 2 drop down menus. the first is populated via a database query and the second gets populated based on the selection made in the first box. (Category/Sub Category)
I am having a difficult time keeping the initial item selected after the page reloads. I thought that this statement would work: Code:
I have an ASP site where users select employee skills from a one drop down box and the level from another drop down box.
However what i iwsh to do is provide an add button where uses can add more drop down boxes onclick. I have tried looking for help on how to do this but dont seem to be able to find any. I'm guessing i would have to use javascript to do?
This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
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.
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:
I am trying to create a database submition type interface which is dependant on the selection of three check boxes. The form contents will always be the same type of information;;; name address etc. The user must decide which db to write their details to.. So if check box one is selected then it writes to database a. If the other two are individually selected then the script will write the form details to another database b and c. If all three are selected then the script will write to all three databases a b and c . Is it as simple as creating three connection strings and assigning them to variables
I am in the process of writing a website which has an access database and uses asp to access it. Part of the site is a search facility. I have heard that it is possible for hackers to gain access to the database by entering SQL in to the search box. First of all is this possible? Secondly if it is possible, what sort of syntax should i be checking for on the text entered in to the search field
Does anyone know if there is a way to select an item in a select box by typing the beginning of the word and it finds it in the list? As an example: Say I want to go to the item named "M1234" in the list. When I type M it goes to the first "M" item. When I type 1 it goes to the first "1" item. Is there a way to make it go to the first "M1" item instead of jumping back to the "1" item? Is it even possible to do this in classic ASP?
I have 4 tables in my db which represent an county split up: 1 County split into 3 Divisions split into 2 Districts split into 10 Section I have a query which pulls all the tables together to show every Section, its district, division, and county. Obviously, each Section only appears once each District 20 times and so on.I want to have 4 select boxes on my page which represent the break down:
county > division > district > Section
This is to enable a user, from any page, to filter the content of that page by whatever breakdown they wish.The question is how best to populate the 4 select boxes (well 3, county only has one option!)? I could have 4 queries on my page (4 hits to the db!), have one query and filter for each select box etc
If request("bMarketTypes") <> "" AND request("bMarketArea") <> "" Then Response.Write "types and area<br />" Elseif request("bMarketArea") <> "" Then Response.Write "area<br />" Elseif request("bMarketTypes") <> "" Then Response.Write "types<br />" End If
I have two text boxes,so the possible combination both are checked,OR one is checked and the other isn't, or vice versa.Why won't this code work then?
When I write code to populate a dropdown box with all fields from a column in a table, it populates all but the first record. And then automatically sets this missing record as the record to be sent, no matter which record I select. Has anyone seen this issue before.
I would like to create a page with VBscript and ASP which will contain two list-boxes one in the left side and the other in the right side with two buttons namely "Add>>" and "<<Remove" so that if the user selects a value listed in the left side list-box and presses "Add>>" then that selected value should go inside the right side list-box.
Similarly if the user selects a value listed in the right side list-box and after clicking "<<Remove" then that selected value should go back to the left side list-box. provide me the code?
how the information boxes pop up when you mouse over a link? For instance in this forum, when you mouse over the Title of the thread, an information box pops up with the entire message. I assume that is Javascript, but does anyone know where I can find more information on this?
I am setting up an ASP page using a combo box ... Request: ... The user select a date from the pull down list and on selection of that date another box or window will populate with the corresponding data from that same record in the database..
I guess I am looking for an "On Selection event" type feature Something that will cause an event to happen based on the selection from the combo box and not have the user to press enter to get the corresponding results.
Say i have a table with check boxes for every row. I would like to have a feature where when the user clicks the checkbox the column background color changes like the one in hotmail and yahoo mail.
I have two forms on one page. Form A only has a list box, lbox1, in it that is pulling its values via a stored procedure. Form B has a bunch of other stuff on it. What I want to do is hide Form B until a value is selected in lbox1. How do I accomplish this?
I have this form which the user will fill online.Now the form has 3 checkboxes giving a user the option of selecting which person/persons out of the three listed should get the form email when he hits submits.
So the form has three checkboxes and each checkbox will have a name of a person next to it.The user just needs to check it (one name or all names out of three) and after he hits enters a mail shud go to the respective selected people.I was thinking of using CDONTS to send mail..but i cant figure out how i shud do it with this mutliple checkbox scenrio?
ok i need to get the text from an option box? i know you can do it with java script but it would make my life a lot easier if you can get it using asp. don't know if there is a method out there or what. any ideas?
I have a form and some of the text boxes are being filled in from a search from another form. Go to this link to see the code for the form page: Code:
I want the user to see the info in the first four text boxes that are populated by the database and I want this info. to be submitted with this form, but I don't want them to be able to change or edit the info. in these populated boxes. Just want them to fill out the rest of the unpopulated boxes.
This form submits to an asp page that processes the form data and sends it to an email. how can i do this?
i have been asked to create text boxes dynamically on a web site, the user can click a button and a new set of text boxes will appear. The user can add as many boxes as many times as he wants, I have created the text boxes already using the following code.
function inserttextboxs() { var tab = document.getElementById("Difference")
var tr = tab.insertRow() var tc = tr.insertCell("") tc.innerHTML = '< input type=text id=text1 name=text1>';
}
The problem is I don't if this how I should be doing it when I submit the form all the elements have the same id, I need to create something with unique id's so I can retrieve the different values
how do get dynamic content to a drop down text box from a db. For example:
There are two drop down boxes. First one continents Second one countries.
The user selects content from the first drop down box and using the onChange javascript function the data on the second drop down should show the countries related with that content.
