listbox table problem

[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.
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 disposed of and the entire page is then
updated to reflect these choices.

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?


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.

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

Many Thanks

[Aaron [SQL Server MVP]]

Please don't multi-post, we discussed this issue in another newsgroup, I
think you need to post to a client-side newsgroup as it is likely an HTML
problem or limitation.

Your issue doesn't revolve ASP, and it certainly doesn't involve a database.

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




"buzz" <buzz15@freeuk.com> wrote in message
news:40bf7be7$0$17764$cc9e4d1f@news.dial.pipex.com ...

> 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.
> 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 disposed of and the entire page is then
> updated to reflect these choices.
>
> 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?
>
>
> 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.
>
> The server in NT4 running IIS4 and the browser used is IE6.
>
> Many Thanks
>
>

[Bullschmidt]

Perhaps something like this might help to reduce the number of records
shown on one page at a time:

Database Paging
[url]http://www.asp101.com/samples/db_paging.asp[/url]
Uses PageSize method of recordset.

Paging Records with GetRows by Mukul Sabharwal - 7/5/2000
[url]http://www.4guysfromrolla.com/webtech/070500-1.shtml[/url]
Uses GetRows.

Displaying a certain # of records on each webpage Paging
[url]http://www.aspfree.com/asp/startpage.asp?id=11[/url]
Uses PageSize method of recordset.
Shorter.

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bullschmidt]

<<
The problem is, although everything is fine when a few hundred records
are retrieved, when the full 2500...

>>

Database Paging
[url]http://www.asp101.com/samples/db_paging.asp[/url]
Uses PageSize method of recordset.

Paging Records with GetRows by Mukul Sabharwal - 7/5/2000
[url]http://www.4guysfromrolla.com/webtech/070500-1.shtml[/url]
Uses GetRows.

Displaying a certain # of records on each webpage Paging
[url]http://www.aspfree.com/asp/startpage.asp?id=11[/url]
Uses PageSize method of recordset.
Shorter.

Recordset Paging with ADO 2.0 by Michael Qualls
[url]http://www.asp101.com/articles/recordsetpaging/index.asp[/url]
Uses PageSize method of recordset.
Longer with more comments.

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
[url]http://www.Bullschmidt.com[/url]
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!