473,549 Members | 2,243 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 5766
> 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
3418
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). ...
3
1882
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...
2
3883
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
10815
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...
3
2827
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...
1
2244
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
2271
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
7542
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
1440
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...
0
7471
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...
0
7740
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. ...
0
7985
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...
1
7503
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...
0
7830
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6071
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5111
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...
0
3517
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...
1
1082
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.