Drop Down List Selection As Parameter To A SP
I working on an ASP page that has a drop down list that gets its contents from a SQL table.
Can anyone show me how to use the selected item from the drop down list and use it as a parameter in calling SQL stored procedure (this procedure simply updates a table so there are no result sets).
I have designed my page to include a submit button and was wondering if it is possible to call the procedure as soon as the submit button is clicked. I get really confused with whether to use a server side or client side script.
View Replies
ADVERTISEMENT
I have the following drop down menu on a html page and when submitting
i would like to call out on asp what someone has selected.
<select size="1" name="type">
<option value="Prospect">Prospect</option>
<option value="Suspect">Suspect</option>
<option value="Qualified">Qualified</option>
<option value="Proposed">Proposed</option>
<option value="Closed">Closed</option>
<option value="Lost">Lost</option>
</select></b></p>
I also have regular fields on the html page which works great when
submitting but for some reason i can't get the dropdown selection to
display Code:
View Replies
View Related
I have a selection list of the 50 states that is not dynamically built. If &state=CA is in the query string i want the selection list to automatically select CA out of the selection list since that is what was in the querystring. Know what I mean?
View Replies
View Related
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
View Replies
View Related
I have a list box that allows users to search an SQL database on ZIP, Name and so on
After the submit the List Box selection always goes back to the defaut selection.
I figured by writing the current selected item to a cookie prior to the submit I could recall it upon reload.
Does anybody know how to set default selected item for a list box? Am I going about this the right way? The more I research it seems dynamically creating the list box is the way t go
View Replies
View Related
I was trying to set up 3 menue drop downs for filtered relational selections of 1st-(Buildings), 2nd (Departments) followed by (Projects). I foillowed all the links and can not see how to get a onchange to work as relational menue. This would have been best. But 3 days later I am tight for time so I was attempting to just setup of the time being 3 seperate drop downs with submit. I can only get the departments to work. The building and projects will not filter as the departments. Code:
View Replies
View Related
Here is my situation, I have an ASP page with 2 list boxes. The first list box displays people that are available to be selected. The other list box shows the people who have been selected. This makes it easy to see who has been selected and who has not been selected since if you are in one list box you will not be in the other.
I know how to write the SQL to get the data for each list box but my problem is getting this to work without having to reload the whole page (I thought I could just re-run each list boxes' SQL and display the results instead of having to load the page again).
Write now I was thinking each list box would have an OnClick or OnChange JavaScript event. I would then have 1 table with all People in it and a second table of people who were selected. When the user clicked on the list box of available people (not selected) I need to run an ASP insert script and then requery both list boxes to pick up the change. In the case a user was removed from the selected list box, I need to run a Delete ASP script.
My problem is that I can do this if I reload the page every time a person is selected from a list but there has to be a way this can be done without reloading the page. Do you have any ideas or suggestions?
View Replies
View Related
I'm working on a project, trying to create an HR hiring intranet page. Basically, here is problem. I have a table in a database called "Title Access" that lists titles, and has software, email, and user rights associated with each title. For example, Network Administrator will get Office, Dreamweaver, be part of the IT and Admin groups.
Now, here is the issue: Whenever the user types in the name, pay rate, hire date, and title on the intranet page then clicks "submit", I want the database to create a new user in the "employee" table with that name, and populate the access rights in that table with the rights associated with the title. Thus, the "employee" table will now include "John Doe", and will have Office, Dreamweaver, IT, Admin checked off. Is there any way to do this????????????
View Replies
View Related
I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
View Replies
View Related
I writing an asp application that uses three listboxes. the first one lists departments ids the second list box populates either users or supervisors based on which button is pressed ( users button and supervisors button).
If a user is selected from the list the submit button redirects to page1.asp. if a supervisor is selected the same submit button redirects to page2.asp My question is how can I submit the form without using more than one submit button.
View Replies
View Related
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
View Replies
View Related
how do i get a value from a combo box and populate a list box base on the selected value from a combo box? If possible can i get a sample coding.
View Replies
View Related
I have a menu box with dynamic values from a recordset (value = 'Size' column)
I then have a textbox for which I want to display the 'Price' column according to the record selected in the menu box.
View Replies
View Related
I have a survey/member form that gathers information. I would like to have a drop down list on a page that a user selects, either 1, 2 or 3.If 2 or 3 I would like to show on the form another field for information gathering ie:if a user has 1 cat, fields for cat name, sex & age show.
if a user has 2 cats, 2 fields show instead of one for each, and the same
for 3.....
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
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