471,084 Members | 782 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 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 5639
> 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

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.