Professional Web Applications Themes

CFOUTPUT with Group attribute <back><next>navigation - Coldfusion Database Access

I have relational database system and when the query is run, i get 300 rows but only 5 should be displayed as I group by ListingID. I would like to create a back next navigation with 10 per page but only the first 5 are displayed in the output. <cfoutput query="#attributes.QueryName#" group="NewsID" StartRow="#url.StartRow#" maxrows="#EndRow#"> </cfoutput > Is there an example that shows an efficient way to do this? Thanks!...

  1. #1

    Default CFOUTPUT with Group attribute <back><next>navigation

    I have relational database system and when the query is run, i get 300 rows but
    only 5 should be displayed as I group by ListingID. I would like to create a
    back next navigation with 10 per page but only the first 5 are displayed in the
    output.
    <cfoutput query="#attributes.QueryName#" group="NewsID"
    StartRow="#url.StartRow#" maxrows="#EndRow#">

    </cfoutput >

    Is there an example that shows an efficient way to do this?

    Thanks!

    Ad Bec Guest

  2. #2

    Default Re: CFOUTPUT with Group attribute <back><next>navigation

    You almost have it. You have to cache your query, which you may have already
    known. Also, instead of maxrows=#endrow#, just state the number of rows.

    Speaking of which, you want 10 rows per page of which 5 are displayed? That
    doesn't make sense.

    Dan Bracuk Guest

  3. #3

    Default Re: CFOUTPUT with Group attribute <back><next>navigation

    I like to use a custom tag for this this one makes it very easy.

    [url]http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru.html[/url]


    "Ad Bec" <webforumsusermacromedia.com> wrote in message
    news:dhi4di$cja$1forums.macromedia.com...
    >I have relational database system and when the query is run, i get 300 rows
    >but
    > only 5 should be displayed as I group by ListingID. I would like to create
    > a
    > back next navigation with 10 per page but only the first 5 are displayed
    > in the
    > output.
    > <cfoutput query="#attributes.QueryName#" group="NewsID"
    > StartRow="#url.StartRow#" maxrows="#EndRow#">
    >
    > </cfoutput >
    >
    > Is there an example that shows an efficient way to do this?
    >
    > Thanks!
    >

    Rick Guest

Similar Threads

  1. Replies: 0
    Last Post: January 4th, 06:35 PM
  2. cfoutput cfquery "group processing" error
    By TimMcGeary in forum Coldfusion Database Access
    Replies: 0
    Last Post: July 18th, 02:40 PM
  3. Datagrid paging keeps going back to the first group
    By Kalvin in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: April 25th, 11:34 AM
  4. cfgrid inside a <cfoutput query="myQuery" group="GROUP">
    By DavidGhous in forum Coldfusion Flash Integration
    Replies: 1
    Last Post: April 12th, 07:23 PM
  5. Equivalent of cfoutput group in ASP.NET
    By JRock in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: March 14th, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139