Welcome to WebmasterWorld Guest from 54.145.136.73

Forum Moderators: open

Problem with Opera select box

   
4:37 pm on Jun 15, 2003 (gmt 0)

10+ Year Member



I'm running into a problem I'm hoping somebody can help me with.

I've got a MySQL table with about 1200 records that I'm putting into a multi select box. It works fine in IE6 and NS6, but when I load the page in Opera 7.11, only the first 749 records show up in the select and the rest of the page doesn't load. So, that's bad enough but it gets stranger. When I limit my sql to 844 records (using "limit 1, 844") the select box has all 844 records and the page renders completely. But as soon as the limit is greater than 844, I'm back to seeing only the first 749 and the incomplete rendering of the page. All of the variations I've tried work fine in IE and NS.

Has anybody run into anything like this? Any suggestions as to how to get around it? I can always require IE or NS to view the page, but that's a last resort.

5:17 pm on Jun 15, 2003 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Welcome to WebmasterWorld smoozy,

That is a lot of records to be loading into one page. Almost sounds like opera is having a problem with the amount of data. Like there is a max size for either the box or the page.

I assume there is no way to break up the amount of data you are returning. That sounds like it would be fairly slow and difficult to sort through for the user(as it is for opera ;)).

7:18 pm on Jun 15, 2003 (gmt 0)

WebmasterWorld Senior Member nick_w is a WebmasterWorld Top Contributor of All Time 10+ Year Member



>> Almost sounds like opera is having a problem with the amount of data.

Bang on jatar! You'll find Opera also has trouble with very large images. I tried loading one that was a few Megs (I didn't realize) and Opera had real trouble with it.

Can't you do a 'first 100, next 100' type thing?

Nick

8:16 pm on Jun 15, 2003 (gmt 0)

WebmasterWorld Senior Member tedster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I've found that any browser has limits when you really push the boundaries. Sometimes it is file size, and sometimes it is just dimensions -- I found a limit around 6000px for an image in several browsers, and I was just redrawing a single color gif.

It seems clear to me that coding a browser means making some trade-offs, and one of the trade-offs is assuming limits and writing them into the browser code to keep everything working well and coordinated in 99.99% of the situations.

I think Nick's approach of "first 100, next 100" might work out nicely with a double select box. Choose the range in a first box and use that range to populate the second. Of course, you'll still be limited to 74,900 choices ;)

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month