Getting 2 Selection List Boxes Working Together
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
ADVERTISEMENT
I would like to create a page with VBscript and ASP which will contain two list-boxes one in the left side and the other in the right side with two buttons namely "Add>>" and "<<Remove" so that if the user selects a value listed in the left side list-box and presses "Add>>" then that selected value should go inside the right side list-box.
Similarly if the user selects a value listed in the right side list-box and after clicking "<<Remove" then that selected value should go back to the left side list-box.
provide me the code?
View Replies
View Related
I have two forms on one page. Form A only has a list box, lbox1, in it that is pulling its values via a stored procedure. Form B has a bunch of other stuff on it. What I want to do is hide Form B until a value is selected in lbox1. How do I accomplish this?
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 have two list boxes . User can select multiple values from the lists. Is there a way I can force that the user can select from only one of the list boxes? Can I associate the radio button with the list so that as soon as user selects the radio button the other list box turns grey(not letting the user to select anything from that list).?
View Replies
View Related
I've tried doing this tutorial on Macromedia's site, but can't get it to work.
http://www.macromedia.com/cfusion/kn...fm?id=tn_19117
I'm using VBscript server side script.
View Replies
View Related
i am trying to link list boxes for a mini intranet. I have created a booking database for our staff to add bookings into for a business and it is all based around dates etc. I want people to be able to select the year in the first box and then in the next list select the month and then the date.
Can you give me a sample code on how to link the lists so that they are dependent? i can get single drop down lists just cant link them.
View Replies
View Related
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
View Related
I need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
View Replies
View Related
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 Related
I would like to create a page with VBscript and ASP which will contain
two list-boxes one in the left side and the other in the right side
with two buttons namely "Add>>" and "<<Remove" so that if the user
selects a value listed in the left side list-box and presses "Add>>"
then that selected value should go inside the right side list-box.
Similarly if the user selects a value listed in the right side
list-box and after clicking "<<Remove" then that selected value should
go back to the left side list-box.
Can anyone provide me the code?
View Replies
View Related
I am working on a survey form. I need to create multiple-multiple dependent istboxes...I need to allow the user to make multiple selection from a categoryListbox and as the user select from categoryListbox must display and add available subcategories into the subCategoryListbox and allow to select multiple subcategoris.
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
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies
View Related
i want to do a voting, which let user select. how can i count the number of user vote?
n... how can i accumulate each slection and display a chart by percent?
example:
.apple
.beer
View Replies
View Related
I have a web page where a user can select a location out of a possibility of 5. I also give them the option of seraching all 5.
However when I put this in it get rids of the drop down box and puts them all in an open box about 2 inches in length. Which isn't too bad but if I say had 20 locations it would take up half the page.
View Replies
View Related
I have a form field called Streets that contains 'HIGH STREET,MAIN STREET'
I have a field in my access db called StreetName a single record would contain one street and I want to return all records that have a StreetName in the Streets field. How would I go about this?
View Replies
View Related
I do not write the whole code.
I have a IF statement like the following.
if request.Form("UyeTipi") = 1 then
strsql=select ****
else if request.Form("UyeTipi") = 2 then
strsql2=select *****
this is the recordset
set objRecordset = objConnection.Execute(strSql)
With loop I want to display data either from "strsql1" or "strsql2"
I create table like the following with loop
Code:
View Replies
View Related
I am working in an asp/Vb script environment.In a form I have 2 combo boxes.first is main criteria and second one is sub criteria.in the first combo I have made predefined enteris(the headers of the table)say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table.say if I selected Ename in first combo.the second combo should automatically fetch the listed Enames and vice versa.
View Replies
View Related
My left frame contains a combo box which loads the selected record in the main frame.The combo box retrieves concatenated 3 columns from my db. E.g. ID, Firstname & Surname.
Because of this, it seems to blow out the size of the frame,thus ruining my nav system.Does anyone know how I can restrict the box width, but allow the drop down part to remain wide?
View Replies
View Related
How do i select a completly random record from a database?
sql = select (random) from tbl, sort of thing.
View Replies
View Related
I have searched through a lot of paging articles. But I have not found any specific recommendations for my issue. I have a large record set that I need to page through (1000 records). But on each page (100 records) I must be able to select some rows, add
some comment for each and sumarize them on-the fly.
if I page forward and backward, I still need to see before selected rows with comments and I can even deselect or edit some of them. Should I store all this information (selection, comment, price) in session variables or is there a better way?
View Replies
View Related
I am working in an asp/Vb script environment. In a form I have 2 combo boxes. first is main criteria and second one is sub criteria. in the first combo I have made predefined enteris(the headers of the table) say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table. say if I selected Ename in first combo. the second combo should automatically fetch the listed Enames and vice versa.
View Replies
View Related
My site is running on IIS5.0 hosted on win2k service pack 4 m/c. We are going to procure high end windows M/C . I seek your advice in selecting right os and version of IIS. My comp is a bit hesitant to migrate to .net too (I don’t know planning of comp in future).My requirement should be
1) Same Program should run on new server with minimum changes.
2) If required we can migrate to .net (although planning is not in near future and I even don’t know what is needed for that)
Your advice in this regard is highly appreciated. Also if you can explain in short about new feature in IIS6.0 (or upper version). Which version of IIS come along with Windows 2003 server, I really have very little knowledge in this field.
View Replies
View Related
i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"
i want to do the same thing with data from a database. how do i do this?
View Replies
View Related
I have this code the value thats stored in table is Yes in College_Assistance field
so i want to select the Yes radio button
but its not selecting
when i see he view source it doesnt say checked="true"
any idea why. Code:
View Replies
View Related
Has anyone used the UPS e-tools such as address verification and rate selection service? I'm trying to implement it on our site and I would just about kill to see some source code. It's a little above my coding level and I just can't seem to figure it out.
The documentation goes into a VB sample, but I dont think that is necessary since you can perform an HTTP POST and parse XML in an ASP page.
View Replies
View Related