Professional Web Applications Themes

Limit on HTML listbox entries? - ASP

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 ...

  1. #1

    Default 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)?
    JohnH Guest

  2. #2

    Default Re: Limit on HTML listbox entries?

    > on the number of entries in a listbox? Also, any better 

    Let them break it down, e.g. give me a list of those that start with A, B,
    C, etc.


    Aaron Guest

  3. #3

    Default Re: Limit on HTML listbox entries?

    > a DTC listbox (server-side) bound to a recordset to allow 

    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?


    Aaron Guest

  4. #4

    Default Re: Limit on HTML listbox entries?

     [/ref]
    allow 
    >
    >Yuck. Do you really need to use a DTC here? You[/ref]
    realize how easy it is to 
    this proprietary and 
    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'?
    JohnH Guest

  5. #5

    Default Re: Limit on HTML listbox entries?

     
    >
    >Let them break it down, e.g. give me a list of those[/ref]
    that start with A, B, 
    Would be nicer, but the customer doesn't want to do this -
    he wants to be able to select from the full list.

    John
    JohnH Guest

  6. #6

    Default Re: Limit on HTML listbox entries?

    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" <com> wrote in message
    news:#phx.gbl... 
    >
    > Yuck. Do you really need to use a DTC here? You realize how easy it is[/ref]
    to 
    and 


    Stuart Guest

  7. #7

    Default Re: Limit on HTML listbox entries?

    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" <microsoft.com> wrote in message
    news:02f601c39ece$cf25fa10$gbl... 
    > >
    > >Let them break it down, e.g. give me a list of those[/ref]
    > that start with A, B, 
    > Would be nicer, but the customer doesn't want to do this -
    > he wants to be able to select from the full list.
    >
    > John[/ref]


    William Guest

Similar Threads

  1. limit listbox items
    By rajesh in forum Dreamweaver AppDev
    Replies: 5
    Last Post: March 21st, 02:49 PM
  2. Replies: 0
    Last Post: August 3rd, 10:18 PM
  3. Listbox with entries
    By AMarin in forum Macromedia Director Lingo
    Replies: 1
    Last Post: July 17th, 06:45 AM
  4. Replies: 3
    Last Post: July 9th, 05:50 PM
  5. CDONTS-Sending HTML mail-8000 character limit
    By Shane Porter in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 7th, 07:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139