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
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 two list boxes . User can select multiple values from the lists. Is there a way I can force that the user can select from only one of the list boxes? Can I associate the radio button with the list so that as soon as user selects the radio button the other list box turns grey(not letting the user to select anything from that list).?
The good news is that I have a code in place that allows all form data to be submited to me, everything displays except the select boxes data. I have tried to search for this and know that it must be do able as it is used on big company sites. Code:
I have a Stored Procedure with a Where clause for a date range, I would like to know is it possible to add onto my Classic ASP two select input boxes for filtering my date column?
For instance filtering January 15, 2008 thru February 14, 2008. If so would you be able to show me what that might look like?My where clause starts on 01-01-2005 and end on a future date, for example 12-01-2040
I am working with an ASP app that creates reports based on data in an SQL Server 200 database. There is a web form with select boxes for the user to select their criteria, and based on that an SQL SELECT statement is generated.
One of the requirements is that some fields need to be multiple selections. The output of these fields are in CSV format (One, Two, Three). These values are all alphanumeric, NOT just numeric....
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 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
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 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 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 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.
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?
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 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.
I have a asp page that I am trying to use Javascript to validate wether or not a value is selected. I have two check boxes on a form, cbx1 and cbx2. I only want to throw an error if both of them are left unchecked. Here is what I have: Code:
if ((cbx1.value!=1)&&(cbx2.value!=1)){ alert("Please Choose How We Should Contact You") return false }
however, this always throws the error, even if one is =1. I thought that the And comparison for JS would only run if both arguments were true.
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:
Ok i'm trying to do a simple delete from what is checked. can someone look at my code and determine why it's not working i when i submit with nothing check it works when i submit with something check it gives me The page cannot be displayed.I'm still new at all of this so excuse my messy code.
I have a select list which retrieves the values of a field from a database. I also have some text fields which I would like to fill with data from other fields in the same table which are associated with the selected item in the list. I can't seem to figure out a way to fill the text boxes with the values from the DB in the OnChange procedure of the select list. Does anyone know how I might go about this, or if it is even possible?
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.
