RobH
|
| Posted: 02/28/2003, 6:00 AM |
|
Using ASP, MSSQL Server and CodeCharge Studio 2+
I have Record Forms that assign users to various tasks. Bt default, I want list boxes where my admin people see the name and not the UserID. The Users table has over 900 names that I really don’t want to query everytime to get the list of users, it’s slow and not very efficient.
Ideally, I would like to pull a value from a table where a UserID is stored and compare it to a pre-built list of Usernames stored in an application object (or text file, doesn’t matter), but I don’t know how.
The List Box control allows me to get my UserID through the Source Type and Source Control properties, which I want to do. The List Source property gives me a choice to select ListofValues but how can I create my own variable that will contain the List of Values?
|
|
|
|
Headhunter
|
| Posted: 02/28/2003, 11:32 AM |
|
900 records slow? I have a list box with over 5000 records!!! and works very smooth (mysql + php). I'm considdering to make a quick pick letter or number to make the list a bit smaller. For example pick letter s to show only names beginning with s in the listbox. Maybe this is something for you?
http://www.dbweaver.com
|
|
|
|
lneisius
|
| Posted: 02/28/2003, 11:42 AM |
|
Headhunter:
Love the site your working on! How about an example showing some of the things you did. Like the color tracking on the grids!!!
Would like to see how you do the custom listboxes!!!!
|
|
|
|
lneisius
|
| Posted: 03/01/2003, 6:52 AM |
|
HeadHunter:
Check this one out! I belive its what CCS needs! Very fast even with 11000 records. Any Ideas on how to incorporate?
http://www.atgconsulting.com/oodynlistbox.asp
|
|
|
|
|
|
