cfdocument output problem

Posted on 2006-03-28
Last Modified: 2013-12-24
OK i have code that reads rows from a database from a field, i need this to output it in a pdf document, however when i do this it only outputs the second resord from the database, and not the first, third etc. if i take the cfdocument tag away and look at the infomation from the database on the page it displays no problem, just when i try output it in cfdocument it only outputs the second row from the database, here is my relevant code:

<CFQUERY NAME="getBooks" datasource="mybook">
SELECT userentry
FROM editbook
WHERE editbook = #url.id4#

<cfoutput><cfdocument format="pdf" orientation="portrait"><cfdocumentitem type="header">#entries#</cfdocumentitem></cfdocument></cfoutput>

Can anyone see where i am going wrong??


Question by:Ianaldo
    1 Comment
    LVL 18

    Accepted Solution


    Try this.

    <cfdocument format="pdf" orientation="portrait">
        <cfdocumentitem type="header"><cfoutput>#entries#</cfoutput></cfdocumentitem>


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Article by: kevp75
    Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now