Just getting started with ASP (NOT .NET) and have a question:
I have a basic form and I'm trying to add some functionality to it. I want a user to be able to select a product from a list box. After this product is selected have another text box, ProductID update to reflect the product number.
In VB I would use an OnChange type thing. Can anyone point me how to do this with an ASP page or using some kind of embedded script?
I've got this listbox and this text field on an ASP page. Now I want the item I click on in the listbox to appear in the text field and I can't find the code nowhere for what seems to me such an easy thing to do.
Problem is when there is an error with one of the other fields and the press reloads the county is reset to Select County how can i remember this value.
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.
i have two dropdowns(dd1 & dd2) in the same page. dd2 items depends on the item index from dd1.when dd1 is onchange, the form will get the dd1 index value and then do a search in DB for the results to be input into dd2.How can i achieved that?
Im trying to get a drop-down box that when a value inside it is selected, it updates a data grid below.
I am making a world cup fantasy football league between a few buddies and i want for each person to view points stats etc on a web page which connects to a database.
On one of these pages which i want help with has a list of Managers, and when a manager is selected it will show in a data grid their chosen squad of players.
I can get a page to select each teams squad, but at the moment i only know how to do that as a set of unique pages for each team which would be time consuming to do. Therefore a drop-down list of the team names would be a lot easier if it could update the page when a value is selected. Code:
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
but i cant find anywhere about how to get at these elements when the forms been submitted. for example, if a few of the items have been select, it returns a commar delineated line, but how can i get at, say the 3rd item selected or find out how many items were selected?
how can i add item/s to a dropdown from another page. i am currently using window.opener to initial the link between the 2 different pages. i have 2 pages, main and sub page. when i clicked on a button at the main page, it will pop out the sub page. when i clicked on the add button at the sub page, it will add the item into the dropdown list at the main page on the fly.
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:
I am trying to find out how to select an item from a drop down menu after a query is executed. My drop down has 4 options, and what I am trying to do is if the record stored in the database is "option2" I need the drop down menu to have option2 is selected.
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of the dropdown with the value from the database. The value in the database is either new, trial, maint., employee, beta, or null. I need to set the dropdrown to one of these values. An example of the select;
I want an ASP page with a dropdown and a simple button. Every time the user chooses an item from the dropdown and clicks on the button i want that value written below in list and allow user to select more.
Also how can these choices be saved somehow so tha when the user goes to the next page the choices he made can be written to the database. For example
The choices in the dropdown may be:
London Dublin Paris New York
When the user chooses Dublin I want ti written below the dropdown. Then when he chooses New York. I want it added to london. so that it displays
Dublin London
Then when he click next button these two choices are taken over to the next page where an insert query can be used to insert them into the db.
I am trying to learn and use good DHTML concepts and code (assuming they are needed). My current issue concerns how to handle this situation.
I have a Select List box which displays values based on what value is selected in a dropdown list. For example, my dropdown list contains a class name, and the Select list contains all of the students who are registered for that class.
So what I would like to occur, is when the user changes the class from the dropdown box, the Select List is re-created displaying the students who are enrolled in that class.
I thought I could do this without having to reload the page (with DHTML) but here is my problem. Code:
What I want to do is that I have created text box on one form so whenever user type something init and click search button then I want to display that text box value on other form so that i can retrieve a record according to that user's number... Code:
I'd like to have the option that matches the current value in the database field display as the selected option. I know it's easy enough to manually force one option or another to be selected, but how could I change which one it is based on the database contents?
I have a dropdown box whose contents i want to automaticaly display in a accompanying text box when a selection is made in the dropdown. My dropdown box is populated by a access database query and when someone chooses one of the options, i want that option to display in the accompanying text box. I hope this makes sense. I'm not sure how to use the "onclick" javascript function.
I have a dropdown that is dynamically populated. The value = a numeric code which I save in the DB. The text = the description. I know how to get the value of the selected item but I need the text of the selected item. I know how to do this in javascript but where I need to gather the text is during an ASP routine.
How do you get the text portion of a dropdown? I saw one post where you can add the numeric code and description together and then use split() to seperate them. I'd rather not do it this way. Is there another way?
I have two columns in my microsoft access database.
1st column is company_logo (jpg image) 2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
I have 2 queries on one asp page, usually I only run query 1 as default, But I hope there is a text link called "Run query 2" and when I click it, my asp file will run query 2.
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
i've made a calendar that uses newsitems from an access database. Every newsitem is a record (newsID, date, title, fact). When the page is loaded for the first time a visitor looks at that page, I want to set the calendar to the newsitem that is closest to the present, but lying in the past. So, today we are the 13th of October. In the database, i've got two items with date "the 2nd of October" and "the 25th of September". The query should return me the 2nd of October. Of course, when that newsitem did not exist, then the query should return me the 25th of September.
Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /emirate/view.asp, line 175
my database is access,i checked both data base as well as the coding,both field names are correct
my sql is only this sql= "select * from MasterEntry"