listbox table issue

[buzz]

I would appreciate a pointer.....

I have an asp page that links to an Access database and retrieves 2500
records and each record line has two listboxes. The problem is, although
everything is fine when a few hundred records are retrieved, when the full
2500 are the listboxes do not position themselves within the table cell and
even extend beyond the table at the bottom of the page. Any ideas?

The server in NT4 running IIS4 and the browser used is IE6.

 

[Aaron [SQL Server MVP]]

Does a user really need to see 5000 listboxes on one page? Why not make
them choose some way to filter it down so they never have to see 2500
records at once? That page would be completely unusable, IMHO.

 

[buzz]

Aaron

Each line is a pallet of stock and one listbox contains what to do with it
and the second is a reasoncode. The user gooes through his/her stock
indicating stock that needs to be displosed of and the entire page is then
updated to reflect these changes.

This is the extreme of the records available and there are filters to reduce
the number of records but this option will still be required.

many thanks

buzz

 

[Aaron [SQL Server MVP]]

Well, usability aside, as for the client-side display issue (extending
beyond the table), it's not really an ASP issue. If you can reproduce the
problem at a URL, post it to a client-side HTML group and ask, "what's up?"

--
http://www.aspfaq.com/
(Reverse address to reply.)

 

[buzz]

OK

Thanks anyway

Well, usability aside, as for the client-side display issue (extending
beyond the table), it's not really an ASP issue. If you can reproduce the
problem at a URL, post it to a client-side HTML group and ask, "what's up?"

 

[Chris Hohmann]

Aaron

Each line is a pallet of stock and one listbox contains what to do with it
and the second is a reasoncode. The user gooes through his/her stock
indicating stock that needs to be displosed of and the entire page is then
updated to reflect these changes.

This is the extreme of the records available and there are filters to reduce
the number of records but this option will still be required.

How about two (2) pages. One to list the pallets and another to display an
add/edit form. You could also implement paging on the list page to limit the
number of rows returned to some sane number like 10 or so. It's a pretty
common approach this type of scenario.

 

[mustcomment2003]

Your computer may be low on resources. I had wierd problems like this
when using Win98 and a thing that had lots of controls on the web
page...

I use a computer now that has 750mb memory and win2000... you should
try the http call to the page on a different (better) computer...

If all the other items that are "flushed" from the server buffer to
the client look "good" then the client can't handle the amount of data
being spit at it...

Try a 2.4mhz box with a lot of mem and win2000. If that doesn't do
it... then you may be S.O.L. on the amount of data you're passing
back...

b.t.w. - you're welcome

 

[Dave Anderson]

I use a computer now that has 750mb memory and win2000... you should
try the http call to the page on a different (better) computer...

You must have an amazing number of memory slots:

512 + 128 + 64 + 32 + 8 + 4 + 2 = 750

Even if you're sharing memory with the video card, this requires five:

512 + 256 + 8 + 4 + 2 - 32 = 750

Impressive. ;-)



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[buzz]

Thanks very much, I appreciate the comments.....

I know the 2500 records seem a lot but this is what has been specced by
those requiring the application and would be quite usable if this problem
could be overcome. Planners are responsible for certain product lines and
require their products to be listed along with the pallet status' in
numerical order so that they can be systematically gone through. As I
mentioned earlier there are filters and this is the extreme but still
currently a requirement if achievable.

I shall try it on a beefier machine and then revisit if it still does not
display correctly..