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.
View RepliesI 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:
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:
View Replies View RelatedI 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.
View Replies View Relatedim 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.
View Replies View RelatedI 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.
View Replies View RelatedI 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.
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 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?
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.
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?
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.
View Replies View RelatedThe user can search the database when they put in a date, that works fine, but when i put in another text box to search the database for a certain date range Code:
View Replies View RelatedI 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....
In my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB.
Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).
The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:
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?
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:
from the client side is possible to create a XMLHTTPREQUEST object to retrieve data ( in async way ) from web services, or simple from a asp page like this :
----- myasp.asp -----
<% response.write("<info>hello</info>") %>
----------------------
how can i accomplish this, but from the server side using ASP and ASP.Net ?
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.
I've created asp reports getting datas from Oracle. The server im using is 8i while client is 9i. Does Asp support oracle 9i. I mean while retrieving numeric datas from oracle it displays only 0. But if the same query is run in oracle to test it, it displays properly.
Do I have to download any patch or driver where IIS is compatible with oracle 9i. Any ideas whats wrong. Did u guyz understand what im trying to say. For ur better understanding Im sending a doc attachment.
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
does any one just help me with the an example of retrieving data from access data base?
View Replies View Relatedi guess it depends on the domain for that answer. If it's a box with hundreds of webpages serving thousands of customers you'd want to conserve network bandwidth you'd probably want to do javascript, but i wouldn't consider reloading a page a big hit since if you just open the connection and runing two queries. But if you need the bandwidth you could do it with javascript.
I try to keep things out of javascripts and out of the hands of the client. Mainly because if they're running an older computer it will take longer to load and put unnessary strain on them and also if the client has scripting disabled you have no more drop down boxes and your site is pretty much disabled. With the strickly asp method you'd have at least the options to choose from and not any core functionality taken from it. That's my 2 cents on javascript to asp.