Inspiring

Question

Force page break after so many rows with cfquery?

Forum|Forum|6 years ago
June 28, 2019
3 replies
558 views

Hello, we're using Coldfusion and SQL and are trying to make a page with a query with only one table with one row and need it to force a page break after so many rows for example 50. We could also have it force a page break after 8x11 page is filled. I'm using a header and it will never show the header (theas) on page 2 sense it can't figure out where the page break is. Any help would be great.

<head>

thead {

position: sticky;

top: 0px;

}

</script>

</head>

<thead>

</td>

<div align="center"><strong><font size="-2"> <nobr> category </font></strong></div>

</td>

</td>

<div align="center"><strong><nobr><font size="-2"> artist </font></strong></div>

</td>

<div align="center"><nobr> <font size="-2"> title </font></div>

</td>

</td>

</td>

</td>

<div align="center"><font size="-2"><strong>price</strong></font>

</div></td>

<div align="center"><font size="-2">check</font>

</div></td>

</table></thead>

<tbody>

<tr>

</td>

<div align="center"><strong><nobr><font size="-2">#Left(catdesc,20)# </font></strong></div>

</td>

</td>

<div align="center"><strong><nobr><font size="-2">#Left(artist,25)# </font></strong></div>

</td>

<div align="center"><nobr><em><font size="-2">#Left(title,25)#</font> </em></div>

</td>

<div align="center"><strong><nobr><font size="-2">#fUpStkQty#</font> </strong></div>

</td>

<div align="center"><strong><font size="-2">#fStockQty#</font></strong> </div>

</td>

<div align="center"><nobr><font size="-2">#fNSWTD1#</font></div>

</td>

<td bgcolor="ffffff" width="12px"><div align="center"><strong><font size="-2">#fNSMTD1#</font></strong></div></td>

<td bgcolor="ffffff" width="12px"><div align="center"><font size="-2">#fNSYTD1#</font></div></td>

<div align="center"><strong><font size="-2">$#fcost#</font></strong>

</div></td>

</div></td>

</cfoutput></tbody>

</table>

This topic has been closed for replies.

J

John123

Participating Frequently

The only way to get true page breaks for a report type output is to use CFDOCUMENT and output a PDF then you can insert

<cfdocumentitem type="pagebreak"> to force a page break.

T

taunntAuthor

Inspiring

I'm trying not to use CFDOCUMENT. I keep having issues with css and it making the font extra small when I try using CFDOCUMENT with the header and footer options.

J

John123

Participating Frequently

I have never had any luck with separate CSS, seems to work if you add it in line on the elements. You could also take a look at this thread https://forums.adobe.com/thread/121088

WolfShade

Brainiac

Actually, now that I think of it, you'd be better off using a non-scrolling header at the top of the page, and let the database values scroll underneath it, if you have that many records.

HTH,

^ _ ^

WolfShade

Brainiac

This:

<script>
thead {
position: sticky;
top: 0px;
}
</script>

.. will never work. You're placing CSS code within a SCRIPT tag. This will error, every time.

I also see TD that are not contained within any TR tags. Where are your rows???

CORRECTION: I see it.. the one TR. So what you provided is just the header. That many columns, you'll have to set up a horizontal scrollbar, unless each column is only one character wide.

I don't fully understand your question. Is it 'pagination' that you want? Or are you wanting to output a header followed by 50 records followed by a header followed by 50 records, etc.? If this is for print, that's understandable. But I don't think CF has a 'page break' like you'd find in Word. It can't be done, really, due to all the different browsers, monitor displays, resolution, etc.

The web is quite fluid.

V/r,

^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded