Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 29th, 2004, 03:22 AM
Authorized User
 
Join Date: Jun 2003
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default if "table heigt" > "pagesize left" then "new page"

hi,

my asp-app generates reports. Such a report iterates tables from db-records. My output now looks like: 3.25 tables on page 1, 4.5 tables on page 2 and so on.
I would like to have an output like: 3 tables on page 1, 4 tables on page 2 and so on.
The tables have a variable height. Is there some trick to get only complete tables on 1 page? (css or something?) Or should i go count tablerows and force my own pagebreaks when not enough rows are left for the next table (somehow count the height of it) on a page?

what are your suggestions?

Harold
 
Old June 29th, 2004, 03:52 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Haroldd,

I am not sure what you mean 3.25 and 4.5 tables. Is that you mean to say the tables are broken?

Are you trying to implement paging recordset? Not sure on what database(SQL server or MS Access) you use.
You can take a look at this, if that helps.
Access - Recordset Paging with ADO 2.0

SQL server - Paging through Records using a Stored Procedure

Cheers!


_________________________
- Vijay G
Strive for Perfection
 
Old June 29th, 2004, 04:22 AM
Authorized User
 
Join Date: Jun 2003
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thnks for your reply Vijay. I indeed meant broken tables and i'm using an Microsoft Access db.

as i looked quickly to the link u gave me i don't think that is going to help me. But i think i'm going to solve it quickly. I'm just gonna force a page break after each table so that each table starts on a new page. Those managers like big reports so they can have big reports

THanks for your help

Harold





Similar Threads
Thread Thread Starter Forum Replies Last Post
updating table w/ query that has left join msordo VB.NET 2002/2003 Basics 4 April 11th, 2008 11:26 AM
using <div>'s to have a left hand pane on web page crmpicco CSS Cascading Style Sheets 2 December 7th, 2007 11:54 PM
can't create table when <% ...%> is in page hertendreef ASP.NET 2.0 Basics 3 May 29th, 2006 10:32 PM
Regular Expression to remove <table> </table> tags mathalete CSS Cascading Style Sheets 2 January 23rd, 2006 01:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.