ASP :: Information Boxes

Drop Down Boxes
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.

Three Check Boxes
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

Input Boxes
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

Select Boxes
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?

Several Select Boxes
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

Two Text Boxes
code:

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?

ASP Text Boxes
I have a text box that i need to check for illegal characters. I only want to have 2 numbers allowed in them, with no letters or ( . , ' ; / ? [ etc.

how could i read the input to a string and check each character entered one by one?

Dropdown Boxes
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.

Message Boxes
Is there anyway to do a message box in asp with vbscript to make an alert box appear like in javascript.

2 List-boxes With Add
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?

Combo Boxes
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.

Check Boxes
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.

Drop Down Boxes And Sessions
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:

Question On Drop Down Boxes
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.

Multiple Check Boxes
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?

Getting Text From Option Boxes
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?

Forms And Text Boxes
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?

Populating Drop Down Boxes
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.

Dynamic Text Boxes
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

Dynamic Text Boxes
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.

Populating Drop Down Boxes
I 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:

Variables From Drop Down Boxes
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:

Delete From Check Boxes
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.

Filing Text Boxes
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?

Select One Of The List Boxes
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).?

Dependent Drop Down Boxes
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.

Select Boxes And Asp JMail
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:

Problem With Combo Boxes
I have the same problem as well.i used the explanation which has been given for the hard coding example but it doesnt work.

Getting 2 Selection List Boxes Working Together
Here is my situation, I have an ASP page with 2 list boxes. The first list box displays people that are available to be selected. The other list box shows the people who have been selected. This makes it easy to see who has been selected and who has not been selected since if you are in one list box you will not be in the other.

I know how to write the SQL to get the data for each list box but my problem is getting this to work without having to reload the whole page (I thought I could just re-run each list boxes' SQL and display the results instead of having to load the page again).

Write now I was thinking each list box would have an OnClick or OnChange JavaScript event. I would then have 1 table with all People in it and a second table of people who were selected. When the user clicked on the list box of available people (not selected) I need to run an ASP insert script and then requery both list boxes to pick up the change. In the case a user was removed from the selected list box, I need to run a Delete ASP script.

My problem is that I can do this if I reload the page every time a person is selected from a list but there has to be a way this can be done without reloading the page. Do you have any ideas or suggestions?

Populating Three List Boxes From The Database
I need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.

Dynamically Linked List Boxes
I want to link 2 list boxes on the same page without reloading it. The list boxes are dynamic and when one selects an item in the first one, the second one get's populated accordingly. So far I've been stuck with Javascript Object Expected Error and I cant find a way to make it work. Code:

What Data Type Should I Use For Yes Or No Check Boxes?
how's the best way to handle yes or no check boxes in a form and DB?

I am building an apllication using ASP and MS SQL 2000. The form will have a total of
34 yes and no check boxes. That is, users will have to make a choice(s) by checking either one.

So my question is, for efficiency on the SQL side, what's the best data type to use?

Create As Much As U Want Of Dropdown And Tect Boxes
i want to create a textbox and when i enter a number on it ,for example 3 ,and send submit , i will have 3 dropdownlist(all of them is the same) , and choose different things from these 3 dropdownlist , so ican sumit 3 stuff everyone is separte than the other , and to the same userid

so how this could be?!? cause i dont knowe how it will be send to the same table , and they have also the same Name.

Moving Data Between Select Boxes
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.

I am having problems retreving the data from the boxes after the user has moved any of the data:

If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:

request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count

If i dont move the data i can retrieve it using: Code:

Need Script/Code For Dropdown Boxes
I wrote this code for the website with a query to a postgreSQL database. The queries works fine and are able to get data into my dropdown boxes. However I want to populate my second dropdown box according to the selection the user made in the first dropdown and so on with the rest of the dropdowns. Code:

Automatic Population Of Text Boxes
I need help on this ASAP. I have to deliver this in another 3 days. There is a ASP page that has 4 text boxes. In the 1st one, I will enter a value. based on this value I enter in the text box, the other 3 text boxes should be filled in automatically. These values for the other 3 text boxes should be retrieved from a SQL Server 200 database based on the value in the 1st text box.

Ignoring Blank Input Boxes
i have created a database system for work but when you input job details you have to fill in every box i want it to be able to process and add the data to the database without having to have every box filled in. Here is the code:

2 List-boxes With Add & Remove Button
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.

Can anyone provide me the code?

Locking All Text Boxes In Asp Page
I need advise as to how to do the following. In a asp page, the user can input
information via text boxes which goes to a database. If users click a check
box named final and submit the asp page, then next time they come, they will
not be able to change any information.

This means, I would like to grey out the text boxes so that users are unable to edit the values in the text boxes. The only way to allow edit is via adminstrator's intervention.

Changing Drop Down Boxes Without Refreshing
I have two drop down boxes that are linked via an ID and a parent_id.

I would like to choose my first option and then have the second drop down box load everything that is under that ID without refreshing the page.

Radio Buttons & Combo Boxes
I have 2 radio buttons & 2 combo boxes.how can i change the combo box to enabled state only when the radio button associated to it is checked? I want this to happen at once (without having any submit buttons).

Multiple List Boxes Dependent
I am working on a survey form. I need to create multiple-multiple dependent istboxes...I need to allow the user to make multiple selection from a categoryListbox and as the user select from categoryListbox must display and add available subcategories into the subCategoryListbox and allow to select multiple subcategoris.

Text Boxes Change Colours
In a form I'm creating several asp text boxes for user input. When I look at these in IE or Firefox one or two are coloured yellow with a border, whereas the rest are the normal white with a thin blue border.

There is nothing I can see in the code that does this, and with a bit of testing I can force this condition by adding text outside the text box. Very weird. Has anybody seen this behaviour before. I'm using Dreamweaver MX 2004, but I'm feeling it's not DW at fault here.

Multi Drop Down Search Boxes
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...)

Parent-Child Dropdown Boxes
I have two dropdown boxes, one is a state dropdown (statedrpdwn) and the other is a city dropdown (citydrpdwn). I want the values in the citydrpdwn to be dependent on what is selected in the statedrpdwn.

So when the user selects a state, I want the city drpdwn to only display the cities in that state. How can I do that? I also need to save this information to a database and retrieve it back correctly from the database. How can I do that?

Multiple Dynamic Drop Down Boxes
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:

Add Additioanl Drop Down Boxes On Click
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?

Asp Email Form With Tick Boxes To Different Address's?
I am trying to set up a contact page using Matt's FormMail ASP script (because my hosting is on a Windows server I am unable to use the easier Natemail PHP script)

It is simple enough to send an email to a single email address but I want to have a form with a choice of 4 email address's to send to that are chosen by way of a tickbox (it doesn't have to be a tickbox but that is what I prefer at the moment)

Does anybody know of a method to do this?

(I am using Adobe Golive CS2)

To Transfer The Data From Database To The Text Boxes In ASP
I need some ideas in this if you can please help me.The folllowing is the scenerio:

I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.

usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.

Information Boxes

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?