I have an ASP-page where I want to be able to select a fabric and color of that fabric. Since different fabrics comes with different colors I want to have a form with two drop-down lists where selection of fabric in the first list populates the second list with the right set of colors. I need to have the lists in the same form so it only require one submit.
View RepliesTrying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?
View Replies View Relatedhow can i change the options of a combo box when selecting an option of another combo box?
View Replies View RelatedI want to create an asp page from these forms in my database:
Database:
Table 1 =>
1.1) ID:
1.2) Product Name
1.3) Description
Table 2 => For the ASP Form
2.1) ID:
2.2) Text field 1 (Normal input field)
2.3) Product (Dropdown Menu, Data Source Table 1, Field 1.2)
2.4) Description (Text Field, Data Source Table 1, Field 1.3)
The Description value should be in correlation with the Dropdown Menu value in Table 1
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 a SELECT element on my asp that is autopopulated from a search button.
Currently, the user inputs the saecrh term, clicks the button and the drop
down is populated from the DB. The user then select from the list. Everything
simple thus far.Now I have been asked if I can get the drop down to open automatically
(apparently to save the users the extra click of opening the list!!!), but I
cannot find out how to automate this (then again, I have little momentum to
do so at this stage) and I know this request will rear it's head again
shortly.
iv searched the forums and kind find anything that fits what im looking for.
I have made an online store, but am having problems with displaying multiple different dropdown options for different products, that are listed in a repeat region
i use dreamweaver 8, and ms access Code:
Not sure if this is posible but how do you create a dropdown box where if you type a "c" it takes you to the start of the c's then if you type an "h" it takes you to the ch's etct .
View Replies View RelatedI need to populate a list box with values that will be determined by the selection of another list. What it is, is when we add a user, they get added to a city, eg Townsville and then there are a heap of groups that only apply to Townsville people.
So once I select Townsville as the location, I want to perform a search in AD and return the list of groups in the Townsville OU.
I am not exactly sure of the appropriate method to handle this in asp. If necessary, I could make a third page and just pass values to that from the second page. Is there a better way?
In case you are wondering, there are currently two pages. One is for use by supervisors/managers, and they fill out some details which get put into a URL that is emailed to the administrators.
Clicking on the link fills out the base form for the admin people, but I want them to have more access and to see more than the managers/supervisors that are submitting the request.
I have to populate a drop down list from the database depending on the values of another drop down list. And the thing is it should also be able to add more dynamic dropdown lists to it.
Basically is a survey result page for which the one trying to look at the survey has to figure out different criteriaz.
Suppose he's looking for a group of people who are interested in buyin a stuff and then he wants to find if their age is above or below 50 and then further he decides to see if they are employed or not...
I did try a couple of things such as populating a dropdown list in a new page depending on the values passed on by previous one... but was hoping to find a better solution as the one i m workin is tooo complex and tooo complicated.
whether anyone had any knowledge of the use of dependant drop downs? For example i would like to choose a product based on the type i.e computer hardware, monitor etc then a list of all products of the same type be displayed in a following dropdown.
Any examples of similar things done, urls to try, your own experience? How simple is it to implement?
Does anyway know the best way (preferably usinge ASP and avoiding the use of Arrays) how to achieve the following:
I have an ASP page. In it, I have a FORM that contains 2 Radio Buttons and a Drop Down List. I need to have the values of the Drop Down List change depending on which Radio Button is selected by the User.
(I thought that maybe some sort of code acting on the OnChange action for the Radio Buttons might work??).
I am somewhat famialiar with ASP.net but I am trying to use ASP. I want to dynamically load drop down lists from an already created MySQL DB. I already have the table build and all the fields, and what not but I can't figure out how to load the values of a drop down list with the records from a column.
View Replies View RelatedI have a drop down box(Yes, no) if users select Yes that is suppose to bring up another drop down list with a list of choices.
I was told by someone that the best way to go about is to create the second drop down list and make it read only, but make it editable when Yes from the previous drop down list is selected.
I currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two
------------------ -----------------
Ford Focus
Fiesta
Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
I am having trouble with the ordering page. I would like a dynamic form list to look at a database and when the user selects a product code, the text boxes containing description and price change too to reflect the product code.
The user will be entering in their contact details, so I dont want the page to reload too because I will lose that info. Code:
I have a form in asp that has a drop down of contact - busness names. One side is contact name and other side is business name in this one drop down. I want to create a button or Link for the user to click and re-sort the order of the drop down from contact name to business name. The drop down is in a form already, so I thought about using another form inside my main form to run a requery of the drop down, but I don't think I can run a form inside a form...
View Replies View RelatedHow do I get a drop down menu to show Please select one when a form opens up? The menu will be populated with a database field but when someone creates a new record I would like for all the drop down menus to say Please select one.
So if nothing is selected from that menu then when they INSERT the new record into the database it will store a Null value for that new field in that field.
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.
I am having a drop down list and other text boxes in a form. I need to retrive and fill text boxes from database depending on the selected item in drop down list. I am using javascript as scripting language. Can any body give solution.
View Replies View RelatedI have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
View Replies View RelatedIthe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
View Replies View RelatedI am using one combo box and populating it with the values . i have another combo box on the page. I want to display the related values in this second combo box based on the selection in the first combo box.
I am trying to reload this page on the change event of the combo box but the values are not coming in the 2nd combo box . Please send me a solution to this or if possible a sample code for the same.
im trying to link to a Access db which uses linked tables via a odbc connection... is there anything different about the connection string / driver?
adoConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Resources/peterjohntest.mdb")
but this error comes up Code:
I have a "booking" section on my intranet.
2 questions.
1. Can I, say by session, determine if a user logged in can amend/delete data they have entered? But no one else.
Say they book a conference room, but only they can delete it
2. I want to prevent cross bookings (in terms) of time.
I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however,
I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB.
The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.
I've been tasked with the challenge of re-sizing images linked via BBcode on the fly. I have compiled a list of functions that do individual components of this task, but stringing them together has proved, well, a challenge.
I discovered this code that will re-size the images, however this will need to be added on an ad-hoc basis, and the fact that the image name appears twice complicates the usual system I used to add the code.
Usual way of replacing the code (inside a function):
Code:
vText = Replace(vText,"[ img ]","<div align='center'><img align='middle' src='")
vText = Replace(vText,"[/ img ]","'></div>")
Image resize code:
if you have seen an example floating around on the internet of three linked list boxs using asp code and a database connection. I have managed to get it to work for the first 2 list boxs, but I am unable to get it to populate the third list box, this is how it is:-
Tables:-
Main_cat
Sub_cat
Subsub_cat.
Not all Sub_cats will have subsub_cats, hope this makes sense. I have attached the code.
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:
View Replies View RelatedCode:
' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here
could someone give an example so I could follow it?
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:
View Replies View RelatedI am unable to show and image or flash i have in an access database that is linked to an images subfolder, below is what i am using to show text on my ASP page but i want to ad a couple of images to the database to show in different locations on the page or pages, so i guess i needed a call function but ive used the one i have on my database image rotator scipt and a few others i have dowloaded and still the call scripts wont work, i'm sure im doing alot wrong can someone please edit this code and show me what to do... if its no bother
This works fine for showing the text on a page:
<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open "introtext", "DSN=introTXT.mdb"
While Not rs.EOF
Response.Write "<br>" & rs("Content") & "<br>"
Response.Write "" & rs("URL") & ""
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
%>
I'm creating a forum based site with basic BBCode features, but am concerned that misuse of the [ img ] tag will mess up my layout. I do not want to go down to road of users uploading images, but want to allow them to embed images from flickr, photobucket etc.
So, is it possible to restrict all linked images that are say, over 400 pixels wide? I've been racking my brains and have had trouble coming up with any solutions. Is it possible?