473,804 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

limit to display=25?

Yesterday, I posted a question which ended up giving me a lot of info, but
the core question never got answered/solved. The short version is that when
a page displays a number of records based on some criteria that the user
selects, the last record shows up in the source code, but not in the
display. Specifically, I can see 25 records (actually nested tables built
with some loop code) More playing around showed me that adding one more
record to the criteria meant that the last 4 did not display (in other
words, there were 29 records all together, but only 25 showed).

Here's what's weird: I saved the file to my desktop (thus losing the ASP
code and allowing me to concentrate on the HTML), and then I removed a row,
one of the ones that did display. Lo and behold, the 26th record (which
didn't show up before) also displayed. So I did a control-Z, which added
that one back in which I removed, then removed a different one. Sure enough,
the that same one showed up. Finally, I kept that one out, then removed
another record randomly from the middle of the page, and the 27th one also
showed up.

What this says to me is that there is some sort of limit to what IE will
display (This being an Intranet, we're all on IE 6) I have further verified
this hypothesis by adding and removing various records. Doesn't seem to
matter which one.

Is there a limit? Can't see any other reason this could happen.
Jul 19 '05 #1
6 2433
> What this says to me is that there is some sort of limit to what IE will
display (This being an Intranet, we're all on IE 6) I have further verified this hypothesis by adding and removing various records. Doesn't seem to
matter which one.

Is there a limit? Can't see any other reason this could happen.


Can you show this magic HTML file?
Jul 19 '05 #2
From yesterday's post (which I think you have the ASP code for), I have
this:

http://www.middletree.net/debug/Disp...leTickets.html
Only difference is, it has 28 records, and only shows 25. I could be
slightly off about the number, but the main thing is that you can see the
statement at the top which says that there are 28 records, (a statement
which was generated by the ASP rowcount property), and more important, you
can see in the code when you do a view source that there is at least one
record that is in the source code, but not displaying. Well, not displaying
on the workstations we have here at work. Again this being Intranet, this is
the best I can do to show you what I am seeing.
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:OG******** *****@TK2MSFTNG P10.phx.gbl...
What this says to me is that there is some sort of limit to what IE will
display (This being an Intranet, we're all on IE 6) I have further

verified
this hypothesis by adding and removing various records. Doesn't seem to
matter which one.

Is there a limit? Can't see any other reason this could happen.


Can you show this magic HTML file?

Jul 19 '05 #3
Sloppy HTML. Count the instances of <table vs </table> (hint: 59 vs 33).

(I verified my hunch by replacing <table with <table border=1, and you can
see that the table width decreases as you go down the page, which indicates
severely nested tables.)

I guess IE will only put up with so much invalid HTML. :(

So, make sure that for every table you open within your loop, that you close
it. This should prevent the browser from succumbing to sloppy HTML.
Jul 19 '05 #4
Of course, I have been going down the same path in trying to solve this.
However, I was looking at the ASP files, not the outputted code, which I
obviously should have. In the ASP, I have a total of 4 <table and 4 </table
tags.

I probably have the opening tags in the loop, and the closing ones outside.

Point is, I think I understand the basic cause of the issue, just am having
trouble nailing down the exact place in the code.
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:uT******** ******@TK2MSFTN GP09.phx.gbl...
Sloppy HTML. Count the instances of <table vs </table> (hint: 59 vs 33).

(I verified my hunch by replacing <table with <table border=1, and you can
see that the table width decreases as you go down the page, which indicates severely nested tables.)

I guess IE will only put up with so much invalid HTML. :(

So, make sure that for every table you open within your loop, that you close it. This should prevent the browser from succumbing to sloppy HTML.

Jul 19 '05 #5
Yep, that was it! I moved an opening <table><tr><t d> combo to just before
the loop, and the count is 28 of each opening and closing (on the test page
I just pulled up). Thanks
"middletree " <mi********@hto mail.com> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl...
Of course, I have been going down the same path in trying to solve this.
However, I was looking at the ASP files, not the outputted code, which I
obviously should have. In the ASP, I have a total of 4 <table and 4 </table tags.

I probably have the opening tags in the loop, and the closing ones outside.
Point is, I think I understand the basic cause of the issue, just am having trouble nailing down the exact place in the code.
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:uT******** ******@TK2MSFTN GP09.phx.gbl...
Sloppy HTML. Count the instances of <table vs </table> (hint: 59 vs 33).
(I verified my hunch by replacing <table with <table border=1, and you can see that the table width decreases as you go down the page, which

indicates
severely nested tables.)

I guess IE will only put up with so much invalid HTML. :(

So, make sure that for every table you open within your loop, that you

close
it. This should prevent the browser from succumbing to sloppy HTML.


Jul 19 '05 #6
In news:ON******** ******@TK2MSFTN GP11.phx.gbl,
middletree <mi********@hto mail.com> typed:
: Of course, I have been going down the same path in trying to solve
: this. However, I was looking at the ASP files, not the outputted
: code, which I obviously should have. In the ASP, I have a total of 4
: <table and 4 </table tags.
:
: I probably have the opening tags in the loop, and the closing ones
: outside.
:
: Point is, I think I understand the basic cause of the issue, just am
: having trouble nailing down the exact place in the code.
:

http://validator.w3.org/

Easy way to find missing starting and ending tags, if nothing else.

Don


:
: "Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
: news:uT******** ******@TK2MSFTN GP09.phx.gbl...
:: Sloppy HTML. Count the instances of <table vs </table> (hint: 59 vs
:: 33).
Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7695
by: Wm | last post by:
I'm trying to get a handle on the best way to handle setting up my listings so that I display groups of about 25 records per page. I currently have a page that returns over 1,000 names/addresses, which is obviously not very efficient. Does anyone have any suggestions on the best way to approach this, or recommendations on what pitfalls to avoid? I'm assuming that I need to be able to count the total number of records that match the search...
20
2682
by: http://links.i6networks.com | last post by:
I need to display pictures, but only as large as AxB. If it is smaller than AxB, then I will display it in the original size, if it is larger than AxB, I will resize it. However, if the size is 100x200, but I limited it to 50x60, then if I use height x width, the image does not display well. So, I want it to srink is a ratio of the original size, so it is will be from 100x200 to 30x60. How can I do it if it is hosted on my server, --...
1
1179
by: cspano | last post by:
I'm using PHP 4.3.10, and MySQL 4.0.26, and cannot seem to get my script to return/display more than 25 records: <?php $query = "SELECT company_name, company_phone FROM tbl_company ORDER BY company_name LIMIT 40 ;"; $result = mysql_query($query, $db); //note $db connection already established for ($i=0; $i < $totalRows; $i++) {
5
4751
by: - | last post by:
I have only 1m records in my database running on a laptop of speed 1.6GHz, memory 512MB ram, and Toshiba MK8032GAX hard disk. I use 'LIMIT x,10' for the query to utilise record paging. When the value of x is nearer to 0, the query speed is fast. Presently, 'LIMIT 0,10', 'LIMIT 50000,10' and 'LIMIT 100000,10' takes about 0sec, 11secs and 4mins respectively. 1) Is there anything I should do, in terms of sql statement or database design,...
0
14428
by: Grip | last post by:
Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may be greater than 255 characters. 2. I have an access database. I link (not import) to the contents of the excel spreadsheet. In the design view in access, Column A has the data type "memo".
1
1502
by: apryladams | last post by:
i need to display 25 numbers in 5 output lines -5 numbers per line calculate sum and average those 25 vnumbers display sum and avergae on page output sum and average into an output file. find largest and smallest value on the screen
5
5727
by: grant | last post by:
I'm trying to use a scatter chart to plot level reading for a pump station level sensor. The sensor takes a reading every 4 seconds, and there are 23,000 reading per chart There appears to be a limit of 4000*4000 data points in MS Chart so I have had a play with the Office 10 activX chart control, but cant get that to plot the data at all. It always try to summaries the data for some reason fathomable only to Bill Gates! Mind you, the...
0
2542
by: GeniusTse | last post by:
Hi all, I found a big performance difference between two query with different "Limit" and I think it is not make sense Table: person_item PKey: (person_id, time) Index: (time) Query1) SELECT item FROM person_item WHERE person_id = '3000' ORDER BY time DESC OFFSET 0 LIMIT 10; total runtime: 0.224 ms
14
2463
by: adrianga | last post by:
Hi all, My English is not the best so it will be best if I show you an example: I have a query: SELECT Make as , Model as , DERIVATIVE, from MY_VIEW and here is what it returns: MAKE MODEL DERIVATIVE PRICE ==== ======= ========= ===== FORD MONDEO HATCHBACK SPEC EDS 2.0 Edge 5dr 8250.00
0
10595
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10343
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10335
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10088
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9169
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5529
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3831
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.