473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 5756
> 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***@TRASHaspfaq.com> wrote in message
news:#8**************@TK2MSFTNGP12.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*******@discussions.microsoft.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
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...
3
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...
2
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
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...
3
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...
1
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...
1
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...
4
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...
1
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...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.