SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Limits the selection with a Multi List box
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wvuour
Starting Member

USA
3 Posts

Posted - 12/19/2013 :  09:02:21  Show Profile  Reply with Quote
I want to allow a list box to populate with a Large amount of data but I want to LIMIT the number of items that the user can select within this multi-list box.

I know this can be done but I am not sure how?? Please HELP!!

Thanks for your time




wvuour

Edited by - wvuour on 12/19/2013 09:05:11

James K
Flowing Fount of Yak Knowledge

3704 Posts

Posted - 12/19/2013 :  10:46:00  Show Profile  Reply with Quote
quote:
Originally posted by wvuour

I want to allow a list box to populate with a Large amount of data but I want to LIMIT the number of items that the user can select within this multi-list box.

I know this can be done but I am not sure how?? Please HELP!!

Thanks for your time




wvuour

This really has nothing to do with SQL, so I think there would be very few people who may be able to answer your question here. Also, it depends largely on what platform you are using to create the user interface.

If you are using .Net - C#, VB etc., you would add a handler for the Change event of the list box. In the event handler, you would count the number of items selected, and if it is more than your limit, display a warning.
Go to Top of Page

wvuour
Starting Member

USA
3 Posts

Posted - 12/19/2013 :  11:28:41  Show Profile  Reply with Quote
I am using SQL behind the Scene of the list box to pull in the data to populate the list box in an eLauncher by Evisions (Banner) software called ARGOS.

But I want to limit the number of selections . . . so I am pulling in 1000 different subjects/course in the list box . . . but I only want to allow say 15 or 20 of those to be selected.

eLauncher by Evisions (Banner) software ARGOS will not allow those other programming codes behind the Scene plus it is also picking about which SQL statements and functions I can use in ARGOS too.

This has been a great learning experience but hard to find people to help. This is way I am having trouble. I have posted this same question to the Evisions (Banner) software ARGOS forum too with little to no feedback.

Thanks anyways . . . still learning ARGOS. . .



quote:
Originally posted by James K

quote:
Originally posted by wvuour

I want to allow a list box to populate with a Large amount of data but I want to LIMIT the number of items that the user can select within this multi-list box.

I know this can be done but I am not sure how?? Please HELP!!

Thanks for your time




wvuour

This really has nothing to do with SQL, so I think there would be very few people who may be able to answer your question here. Also, it depends largely on what platform you are using to create the user interface.

If you are using .Net - C#, VB etc., you would add a handler for the Change event of the list box. In the event handler, you would count the number of items selected, and if it is more than your limit, display a warning.



wvuour

Edited by - wvuour on 12/19/2013 14:35:39
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000