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.
View RepliesI am able to query an Access DB and return the values no problem. Now I want to create a "DISTINCT" list, lets say car makers, showing no duplicates. Once you click on the brand, it will then re-query and give you all available models, etc etc. I have done this before using Cold Fusion but this time I do not have that option.
Now is there an easy way to do this? I have been looking for days for an easy way, like 2 or three pages(like in CF), to do this in ASP. What is my first step? Record sets? I have no problem accessing a DB and querying data. Its the drill-down that confuses me. Also is there a way to make the menus expanding menus in ASP or does that use jScript?
a ASP page I have records displayed. The table that contains the data is built dynamically as the records are read.I need to be able to click the column headings and sort the data by the column heading just clicked.
I have looked high and low and I cannot seem to find any code that is straight forward and easy to follow without having to reconstruct the tables which I would rather not do. Anyone out there have access to some decent code for doing this function? Or, perhaps some functions for doing this function?
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.
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.
View Replies View RelatedI'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?
how can i change the options of a combo box when selecting an option of another combo box?
View Replies View RelatedI 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 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:
View Replies View RelatedI 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?
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.
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:
View Replies View Relatedi 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?