i 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.
Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:
basically what im trying to do is create a form to submit some data to an access db.
In the form i want to be able to have two dynamically populated drop downs (so if a user chooses cars in the first field it comes up with a bunch of car manufacturers, or if he chooses boats it comes up with boat builders etc etc.)
Ive searched high and low, and i the best i can find is javascript to make the drop dows. The java script however uses a form to repost the data back to the page to populate the second drop down. This wont work when its inside a form.
is it possable if i set up a drop down and choose somthing a different drop down box will be filled with informatin dependsing on the first one. for example if i choose in drop down box to UK . i then get all the citys in the uk like london and so on. is this possabel.
I've been using ASP for smaller (up to 4 items) dropdown menus, and so far I've been if/then/ statements such as this boolean case:
Code: <select name=""gift"> " <%If MyGift = true Then %> <option value="true" selected>YES</option> <option value="false">NO</option> <% Else %> <option value="true">YES</option> <option value="false" selected>NO</option> <% End If %> </select>
How do you set the selected item in a drop-down menu when you have many items in the dropdown, as in the case where the dropdown contains the 31 possible days in a month?
I have two drop downs. Both dropdowns are dynamic and data is send from a db for both,
Depending on what is selected in the first drop down i want to populate the second drop down. I know and have done this using XMLHTTPScripts but as this is for a website i dont want to go down this route.
I don't know what to call what I want, but here is the description. Can I use sub-Lists? I have a dropdown that conatains a list of products. When a user chooses an item, I want another drop down or anything that will allow them to then choose the specific category.
For example:
#1: I have cars and trucks.
When I user selects cars, I want a dropdown to give them available cars to choose from. Say for instance the user selects Ford. Then I want them to have the option to choose from the list of Fords. Escort, T-bird etc. Their final choice is what's sent to the DB. #2: Also, I don't want to give them the option to enter a date into the DB. I have a field in my DB design "timestamp". I want this field to be automatically populated server side once the data is submitted.
I want to make a form where m using two drop down menus.
Where in based on selection in first drop down the second drop down should populate itself with relevant data based on first drop down. Like first can be COUNTRY name and second can be STATE name where based oon country selected the STATES are displayed in second drop down for selection.
I have an existing ASP file in a virtual directory. When I type server. or request. in this text file using Microsoft Script Editor I get a dropdown showing the properties available for the object.
However, if I change the extension to ASP on an existing html file, or create a new asp file I'm not getting the dropdown. I suppose this indicates the objects are not available in these new files, and they would not run properly if I tried to open them. What am I missing in setting up these new ASP files?
What I'm trying to accomplish is the ability to post information to the querystring based upon values that are within a drop down that was generated from a database. Code:
i have a website that uses (or needs to use) dynamically driven dropdowns using asp & JS on all pages. it contains 3 different dropdowns that are DB fed and are dependent upon the value of each other. the drop down values are updated using a repost to itself.
they work perfectly on the initial pages where no other variables are involved, but i am having troubles on the pages where more variables are being sent. eg: i have use a lot of error checking, and when i repost, the variables are deleted, and thus the error listings take effect as the variables are now blank. can i refresh the dropdowns without repossting to the samepage without effecting the existing variables on that page? sessions? cookies?
I'm either way too tired or this is a bit above my head. I have a database (access) with four fields. One field is a unique id (rs("id")), one is a category (rs("category")), the third is type (rs("type)), and finally a title (rs("title")). There are and will always be seven types, numbered 1 - 7, with each type identifying a category. To be more specific, 1 = appetizer, 2 = soup, 3 = main dish, etc.
What I am trying to do is to create seven seperate drop down list, one for each type. The options in the drop down list will each be identified with the id (rs("id") and the values for each option will be the rs("title") field. I am having a hard time in the Loop distinguishing when to end one select statement and begin another.
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 a multiple select drop down. It will load into it the following information: Student ID, Last Name, First Name
There will be another drop down box that loads with classes, only this is not a multiple select.
I need the user to be able to select all students they need from the first drop down and then select the class they want to insert them into. Then, when they hit the button, it will break up the data from the first, Student ID, Last Name, First Name and insert those three things into the database under those respective column names.
Does anybody know how I can split these up properly when there will be multiple students selected, or does anybody have a better way of doing this?
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 creating a asp script that pulls records of an oracle database and displaying it as a table on an asp page. however what I want to do is display the records as links. for example.
record 1
(if record one is clicked)
record 1 information of another record from database 1 information another record from database 2 etc.
(and if record 1 is clicked again)
record 1
i really jus started learning asp and if anyone knows how to do that without any issues with client and server sides.
I have a table, which is bound to a database, how would I go about, making fields in one column, so that I can drill down on them.For example, I have a column of Groups, and I wish to click on a group and see the members in that group.
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:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I have 3 drop down boxes on an asp page Dynamically populated fron the db, I need the drop bown boxes to be refreshed when you have picked the first eg I select "Midlands" from the Region drop down and only the "Locations" that are in the Midlands are entered into the Locations drop down.....
On one of my client's sites, we set up a subdirectory off the app's root directory that doesn't allow the Anonymous IUSR_ account in. When we (the system admins) follow a link to that directory, it presents the standard NT Challenge login screen. We need to know proper Windows credentials to get in -- and once we do, we have access to higher-order functions (to change the read/write bit on files, to delete files, etc. through the web interface). All that works fine.
I'm want to have a drop down box, for which each item in it have its own URL. I want it to be forwarded to the URL only when the button "go!" is pressed. Here is my code, not working
I created a drop down box, I want to do like when a user select one of the options, it automatically run a query and displays the result. I hope there is a way to do this
In one of my ASP pages, I have a Combo box that gets the information from a sql database, the number of records that is shown in the combo box is too much (around 6000 records), the user has to select from these records (let say the user is looking for "George", by clicking "G" the list goes directly to the first records starting with "G", so far everything is ok, now he/she enters "e" (the second letter of "George"),this time the list goes to the first record starting with "e", which is not the way that I want the user to find his/hers record. I hope that I have explained it correctly, what I need is, after entering the second letter of "George", the list moves to the records starts with "Ge", and by entering the third letter, list moves to those records starting with "Geo" and so on.
ive written a piece of code that selects everything from the "Departments" table in a DB and it works well. It lists everything in a drop down box. i'm not writing a page where users can edit their details.
i can make the text in the DB appear at the top, but it's listed again further down. is there any way to get rid of it? Code:
I have made a page in which i have 2 drop down boxes
in first i have got a choice from which i can select subject area eg ( microsoft, cicso , oracle) and after selecting the particular subject area the page reloads and retrive all the courses related to the particular subject area into the other drop down box, and after that when i select the course in the 2nd drop down box and click go then i got the whole information about that course.
Now what i want is that when i select the subject area in the first drop down box, all the courses should come as they are comming now + the 2nd drop down also have the option of "ALL COURSES " and after i select the "All Courses" option and click GO then i get all the courses and details os that subject area. Code:
I have my code like this the user enters the country in Upper case like this for example SPAIN
getcountry=Trim(Request.form("txtcountry"))
Response.write getcountry
now when i do a response.write it types the country name SPAIN
then i have a drop down which is been filled from the table and the values in it are lower case so i have to select spain which appears lower case in drop down Code:
On my page I have 3 drop downs that are populated with static data. When my user makes a selection in either drop down I want to show my HTML table associated with that drop down selection, also the data in my tables are all static.
For example.
if the user selects CAR - New in dropdown 1 I want to show a list of my new cars if the user selects TRUCK in dropdown 2, I want to hide my CARS and show my TRUCK list if the user selects BOATS - Fiberglass in dropdown 3, I want to hide (if shown) CARS, and TRUCKS and show my boat list.
For now all of the data is static (don't ask) so I need to do all of this on the client. Is there a way to do this either using JavaScript, Div tags, CSS, etc.