asked on

Publishing a SQL Server table of 500,000 rows on the web...

Hi All,

I have tried using some software to convert a 500,000 row table into an .html page. However, the HTML page gets way too big to open up in Internet Explorer. Is there any way I can do this?

Thanks!

Faiga Diegel

do you have to show that 500,000 row at one time? did you try using paging on your web page?

salesprod

ASKER

The better solution would be a lookup of some sort, but unfortunately I am limited to html. Yes, they have to be displayed at once. How can I do paging?

ahoffmann

> Yes, they have to be displayed at once.
and
> too big to open up in Internet Explorer
then you have to use another browser ..

Anthony Perkins

>>Yes, they have to be displayed at once. <<
I know this is far fetched, but just for a minute, let's assume that you manage to load it in a browser. Tell me, what user in their right mind is going to scroll through 500K rows?

salesprod

ASKER

No one is going to scroll through 500K rows. It would be a lookup tool, used parallel with the Find function.

ahoffmann

> .. going to scroll through 500K rows ..
not necessary, you can use for each row
style="position:absolute;top:0;left:0;"
;-)

Anthony Perkins

Give me a break. Either that or take some interface clasess. Or better still talk to your users. What a concept!

ASKER CERTIFIED SOLUTION

Ken Selvia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ahoffmann

> No one is going to scroll through 500K rows.
then you don't need them in one page (as you stated earlier), so we have 2 contradictory requirements
salesprod, could you please describe more clearly what you want to achieve.