468,539 Members | 1,575 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

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 5550
> 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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by James Butler | last post: by
2 posts views Thread by Filips Benoit | last post: by
3 posts views Thread by Thunder$truck | last post: by
1 post views Thread by Microskills | last post: by
1 post views Thread by Microskills | last post: by
4 posts views Thread by Thomas Adler | last post: by
1 post views Thread by =?Utf-8?B?anAybXNmdA==?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.