Filter 2nd Drop Down List Value From DIFFERENT Tables
I have coded 2 drop down lists. For ur info, currently my 2nd drop down list's content is being retrieved from one single table in database only. What if I would like to make the content of my 2nd drop down list to be populated with data from 2 different tables?
What i mean here is that, the selected value in 1st drop down list will determine data from which table to be loaded into the 2nd drop down list. Earlier I'ved coded my SQL statement as:
SQL = "SELECT x.language_ID, x.language_name, y.msg_category " &_
"FROM Language x INNER JOIN outMessageENContent y " &_
"ON x.language_ID = y.language_ID"
where data for 1st drop down list is loaded from table x and data for 2nd drop down list is loaded from table y.
My 1st drop down list only has 2 values., which are 'English' and 'Chinese'.Now I would like to make it as, if user select 'English', then my 2nd drop down list will refer to that particular 'English' table, while selecting 'Chinese' will allow 'Chinese' table's data to be loaded into my 2nd drop down list.
So what shall I change in order to filter the 2nd drop down list's content according to the selection from 1st drop down list? Shall I modify my SQL statements?
View Replies
ADVERTISEMENT
I'd like to know if there exists a query to erase/drop tables from an access table (on a asp script) older than X creation date.
View Replies
View Related
i have a drop down box that selects tables on my asp page, but using the hidden attribute, they have fixed positions on the screen. this a search engine and i need it so that if they only search two options that them two options will be at the top of the screen?
View Replies
View Related
if there exists a query to erase/drop tables from an access table (on a asp script) older than X creation date.
View Replies
View Related
I need to retrieve the tables list from a MS Access database.
View Replies
View Related
i am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
View Replies
View Related
Im using a drop down list for user to select their option. (For example the user selected type2) All goes fine for saving, but when I retrieve the info from database to be display on the same form on the same drop down list, it display Select Heretype2
<select name="type">
<option value="<%=type%>">Select Here<%=type%></option>
<option value="type1">type1</option>
<option value="type2">type2</option>
</select>
How to overcome this?
View Replies
View Related
I want to save the value of the option in a cookies choosed by a user in a drop down list in ASP page. After OnChange"........ what should I write?
View Replies
View Related
I'm sure an ASP programmer would be able to create this function within 5 minutes, but I'm just learning and I've fumbled my way through creating a little site content management system for a local community group. I'm a designer and the site looks great (so I'm told) but I just can't get this last page to work. I'm desperate for help!!!
I'm trying to call the values for a drop-down list from a seperate categories table in Access, to add/update records in a main Access table/query. The page/form is used to:
a) diplay/edit existing records; or
b) add new (if cstr = "").
I have finally managed to display the correct selection in the drop-down list for existing records (not sure if code is correct?) but I can't work out how to write changes (edit record) back to the database; or 'save' a new record? I'm also not sure if I should be trying to write data to the table or query? Code:
View Replies
View Related
how do i maintain the drop down value.. when i click on the "All" it cant be maintained... jsut that "All"... others values works fine.. Code:
View Replies
View Related
I have a page which displays all the fields in a table of my dbase. One of the fields in the database was previously populated by a drop down box.
My question is, is it possible to display the same drop down box with the value that has been populated from the table so it can be updated?
View Replies
View Related
Does anyone has some sample code or know any resources for using ASP and Javascript to dynamiclly create a drop down list?
(ie. Once the user selects a drop down list, ASP gets the selected value and go to database to get another set of new values. then creates a drop down list of all the new values)
View Replies
View Related
I am working on a project where people can search my database from the web. I have a drop down list on the page but I am having a hard time trying to code it so that when someone picks a title from the drop down list they only get the people with the same title as selected by user.
View Replies
View Related
i want to create one asp file using vbscript which will contain a form which gets informations like name, company and contact details(address, phone, email) of the user.
i want to use one dynamic drop down list box of which that drop down box will contain all the previous names entered in the past along with the option "add new name" at the beginning of all the names so that if anyone wants to add new name to the database they can click it and if already entered member browses that page he can select his/her name which will populate all the details down below like his company and contact details and if he wants he can make some changes in it and update in the database.
i tried searching tutorials for this but what i found was only for client-side javascript.
View Replies
View Related
i have a drop down list from with i choose a company name.after i choose the company name i want to go to a page where it displays all there details.what would be the most easiest way to do this?
View Replies
View Related
i have a drop down list box and i want to fill it with the options from the table i have called courses i want to fill the drop down list with what ever is in the courses table location field, e.g if there is scotland in the location field i want that to be shown so the user can select it, but i dont want repeating data to come up for example if there is 2 courses with the scotland i dont want 2 scotlands in the the drop down box.
View Replies
View Related
I want a new drop down list to display suppliers name, i have a stored procedure to get me this information, so am going to call a 2nd stored procedure on my .asp page and populate the drop down list with its values , would this be the best way to do this ?
I then need some way to link the supplier name to the supplier code so i can filter the report when i select the supplier name it will return the result for all the supplier codes in the report.
View Replies
View Related
I have a drop down list with 60 values in it. When I click on the drop down list it shows 30 values and the scroll bar. I only want it to show 10 values and the scroll bar. How do I set this limit for the number of values that are displayed at a time.
View Replies
View Related
I have created a page which contains 4 drop down lists.When loading the page itself i am filling up the first drop down list.Depeding upon the selection of the item in the first one,without submitting the page,the second list should fill.
And according to the selection of that the third one and so onn.The probelm is that i want to do this without using the OnChange method in the select.I am stucked now.
View Replies
View Related
I have the following piece of code:
<SELECT Name = BB>
<option value="100">English</option>
<option value="103">Italian</option>
</Select>
Once submitted, is there a way for me to get the content of the selected drop down as well as the value? Or can I only get the value using Request.Form("BB") ?
What I'm trying to do is to store multiple values in the drop down. (i.e. price and product name)
View Replies
View Related
When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?
View Replies
View Related
I have a form I'm building in Dreamweaver. On my form I have a drop down list that is populated by a table in my Access Database. I won't to add a second drop down list but have the contents of it vary by what I select in my first drop down list. Let me explain further. Lets say I have a database of Movies. And The name of the movies are in a table and that table is used to populate my first drop down list. Now I have another table that has the actors in the movies. I have a junction table to make them relate in my database.....now how can I select a movie in the first drop down list...and the actors from that movie popluate the second drop down list?
View Replies
View Related
I have an asp page that creates a table from a Ingres II database. The headers at the top of the columns are hyperlinks that ad a order by to my list. This was all working fine until I added more choices with a drop down list view_type .
Now I am getting this error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I am thinking it has to do with when my list is reordered it does not know which view type and is not going through the count. Code:
View Replies
View Related
I have an asp page right now and I want to fill a drop-down list with
information like a persons name from an xml file. Once the user picks a
person from the drop down list I want it to go back to the xml file and
load the information about the person into textboxes. Does anybody have
an example for something like this in asp?
View Replies
View Related
I hope this is the right group. I am very new to ASP so this is
probably a stupid question. I have some vbscript that query's AD and
populates a recordset. I know the recorset contains the information I
want by doing a Response.write. I am having problems dynamically
creating a drop down list from the data in the recordset. The drop down
is created but it is empty. Code:
View Replies
View Related
I need advice how to reduce the size of my drop down list which is created dynamically using a field from my database. If you visit this link you'll see as the box is too long it's knocked out the whole look of the page. Other than shortening the names of the businesses, is there anything else I can do?
My concern is that next year sometime after this site has gone live, it will be maintained with a content manager by people with no IT expertise.
View Replies
View Related
i want to retrieve the value from Mircrosoft Access database into the drop down list..it works.. so its dynamically..
but the problem is.. how could i redirect from the dynamic drop down list to other page.actually this page mostly like a search page.
View Replies
View Related
Im having a form for user to enter fields. One of the requirements is to enter the school name. To overcome a difficult and long drop down list. How would like to let the user select from a "state" drop down list first, and it automatically will change the drop down list of the "school" under the selected state. How do I do that?
View Replies
View Related
I have a problem when passing the selected text from a databound dropdownlist. No matter which item that you select in the list the first item is always returned in the customerdrop.selecteditem.text.
How do i get the actual 'selected item' back? Code is below! I call the contactshow sub to populate the dropdownlist, and this in turn calls the bindlist sub. Code:
View Replies
View Related
I'm trying to populate a drop down list with values found in the Project and ProjectAllocation.
The Project Table consist of all the Project Details like Name,Location, Date,etc.
Whereas the ProjectAllocation consist of only 2 fields, ProjectID & EmpID (this is bcos one project can have many employees). Code:
View Replies
View Related
I have a small problem using SSJS, I have an ASP web form that populates an XML form, I then want to Select a field with the id="group" from the XML file and write it into a SELECT Field of another WEB Form but I am having Problem,
I taught I had this conquered when I had the form as HTML as follows:
Code:
View Replies
View Related
I have an form/application that requires several pages of steps to be completed. On page4 (income school info) I have a dynamic drop down list that builds itself from the database based on member names that the person has entered on the previous pages. When the person filling out the form gets to the end they have the chance to edit their data if something is wrong on page5a.
When they click on the edit icon the member name is passed back to page4 in the querystring. Based on what the member name is in the querystring, I want the dynamically built drop down list to select whatever name is in the querystring. Code:
View Replies
View Related
provide me a sample code for dependent drop down lists?I need to create a few drop down lists and they are dependent of each other. Their relations are very complex as 1 drop down list may affect 2 drop down lists.
View Replies
View Related
