Link to home
Start Free TrialLog in
Avatar of NJordan72
NJordan72

asked on

Moving Info Between Two Dynamic Lists

OK Here is the Challenge of the Day-

I have two lists.  One called Distribution List and one called the User List.  The user list is a list of all the users (which are stored in the table tblLogins).  The distribution List is the list off all users that belong to a particular list (the lists are stored in tblDistributionLists and the relationship is in tblDistributionLists_Logins)

I would like to have a page the displays all of the users that are members of a particular list in a list box on the left hand side, and all of the users on the system in a list box on the right hand side.  In the middle I would like two arrow buttons (one pointing right and the other left)

My goal would be for the user to be able to highlight a name on the distribution list and click on the right arrow to remove the user from the list (delete that relation from the DB) and be able to highlight a user on the right and add him to the list on the left (add him to the relation table).

I know that IBuySpy does this pretty seamlessly, but that was using .NET and we haven't implemented the Framework on our production server yet.  Is there a nifty way to do this in traditional ASP?  Any help?  Thanks!
Avatar of LCP
LCP

You can use javascript to add/remove item from the SELECT list. However, if you want to update the database at the same time, you have to write a submit action for the ASP to add/remove the item from a list.

ASKER CERTIFIED SOLUTION
Avatar of Göran Andersson
Göran Andersson
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
NJordan72:

You have many open questions:

https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20175227
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20130164
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20165375
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20184291
https://www.experts-exchange.com/jsp/qShow.jsp?ta=cplusprog&qid=20256443
https://www.experts-exchange.com/jsp/qShow.jsp?ta=cplusprog&qid=20260378

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator
NJordan:

Please read item 3 in my post above. We would like an explanation as to why the grade is less than A.

thanks!
amp
community support moderator