473,803 Members | 3,886 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Limit on HTML listbox entries?

I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit. I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
Jul 19 '05 #1
6 5795
> on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?


Let them break it down, e.g. give me a list of those that start with A, B,
C, etc.
Jul 19 '05 #2
> a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection.


Yuck. Do you really need to use a DTC here? You realize how easy it is to
populate a <SELECT> list from a database, without using this proprietary and
browser-dependant nonsense, right?
Jul 19 '05 #3
-----Original Message-----
a DTC listbox (server-side) bound to a recordset to allow the user to make a selection.
Yuck. Do you really need to use a DTC here? You

realize how easy it is topopulate a <SELECT> list from a database, without using this proprietary andbrowser-dependant nonsense, right?
.

I can look into doing this, but I don't know where/what
the restriction is, i.e. would I still get the same
problem populating 'manually'?
Jul 19 '05 #4
-----Original Message-----
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
Let them break it down, e.g. give me a list of those

that start with A, B,C, etc.
.

Would be nicer, but the customer doesn't want to do this -
he wants to be able to select from the full list.

John
Jul 19 '05 #5
I have generated a Select box with 1200 records before.

It was fairly slow to load but was only for administration for myself so it
didn't matter.

Stuart
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:#8******** ******@TK2MSFTN GP12.phx.gbl...
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection.
Yuck. Do you really need to use a DTC here? You realize how easy it is

to populate a <SELECT> list from a database, without using this proprietary and browser-dependant nonsense, right?

Jul 19 '05 #6
Time to put your foot down and give the customer what he NEEDS instead of
what he WANTS. Even if you could populate the list successfully, after a
few times working with a list that long, he'll get fussy that he can't find
what he wants and blame you.
"JohnH" <an*******@disc ussions.microso ft.com> wrote in message
news:02******** *************** *****@phx.gbl.. .
-----Original Message-----
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?


Let them break it down, e.g. give me a list of those

that start with A, B,
C, etc.
.

Would be nicer, but the customer doesn't want to do this -
he wants to be able to select from the full list.

John

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
3428
by: James Butler | last post by:
Running a CLI script that fopen's a file, parses the lines into an array, checks the array entries against a few regular expression qualifiers (i.e. !eregi("bot",$entry)) and dump the good entries into a MySQL db. The fopen'ed file is a 410MB text file with log entries formatted like a .CSV file ("" text qualifiers and comma separators). Running the script from a web browser in Windows98: Works fine, except it stops about 1/10th of...
3
1894
by: CJM | last post by:
I would like to be able to use an autocompleting listbox - that is, one where you can select an item in the list by typing the first few characters; the standard IE listbox only responds to the first character. I'm happy to pay a few quid for a 3rd-party component/activex control if necessary but I imagine something equally good could be done with client-side code... Any suggestions?
2
3904
by: Filips Benoit | last post by:
Dear All, What is the max lenght of the valuelist-string as rowsource in a listbox ? I use a listbox to show all the files in a folder. Filip
9
10850
by: Terry E Dow | last post by:
Howdy, I am having trouble with the objectCategory=group member.Count attribute. I get one of three counts, a number between 1-999, no member (does not contain member property), or 0. Using LDIFDE as a comparison I get the same results. No members means just that, an empty group. Zero means that the DirectorySearcher.SizeLimit has been exceeded....
3
2836
by: Thunder$truck | last post by:
I'm sure this is easy but I can't figure it out. I use a ListBox for my application log and each time the app performs a task an entry is added into the ListBox. When the list box becomes full, a vertical scrollbar is automatically added to the ListBox. As more and more entries are added to the ListBox it becomes a chore to continually have to manually scroll down to see the new entry.
1
2255
by: Microskills | last post by:
I am a new VB.NET programmer. I am writing a dictionary program with a Dictionary file has over 60000 entries. When user starts typing a word in the searchbox, I want to show words that start with the text in the search box. For example if user enters GA lstbox will show GAB GABARDINE GABLE ...
1
2281
by: Microskills | last post by:
I am a new VB.NET programmer. I am writing a dictionary program with a Dictionary file has over 60000 entries. When user starts typing a word in the searchbox, I want to show words that start with the text in the search box. For example if user enters GA lstbox will show GAB GABARDINE GABLE ... ...
4
7553
by: Thomas Adler | last post by:
Hello, I want to create a listbox with icons. Icon1 --- Item1 ----comment01 Icon1 --- Item2 ----comment01 Icon1 --- Item3 ----comment01 Icon2 --- Item4 ----comment01 Icon1 --- Item5 ----comment01 Icon2 --- Item6 ----comment06
1
1450
by: =?Utf-8?B?anAybXNmdA==?= | last post by:
I've got a ListBox on my Visual Studio C# form with several entries (14,000). I have to put a search field on the form. As text is entered into the search field, I want the ListBox to remove entries that do not match. Sounds simple enough, but it is really taking a long time! I started running it before opening my web browser, and now (with typing this message, I'm about to go over and hit a breakpoint) it is at ... 12687 entries, and all...
0
9564
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10546
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10310
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10292
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5498
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5627
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4275
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3796
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.