1 Reply Latest reply on Jul 7, 2008 2:54 AM by Newsgroup_User

    Paging Results

    leemar99
      I’m trying to page query results which are determined by what link the user has clicked, the following code pages the results of the query but doesn’t display the outputs. It displays them as the query variable, i.e. #getItems.Title#, any ideas what might be causing this?
        • 1. Re: Paging Results
          Level 7
          leemar99 wrote:
          > I?m trying to page query results which are determined by what link the user has
          > clicked, the following code pages the results of the query but doesn?t display
          > the outputs. It displays them as the query variable, i.e. #getItems.Title#,
          > any ideas what might be causing this?

          forgot a cfoutput. cfloop doesn't output. btw you might just use a cfoutput
          w/startrow & maxrows options here as well.


          <cfoutput>
          > <cfloop query="getItems" startrow="#start#" endrow="#start + step-1#">
          > <table id="productTbl">
          > <tr>
          > <td colspan="2"><strong><a
          > href="../template/products-details.cfm?ItemID=#ItemID#"
          > class="black">#itemID#</a></strong></td>
          > </tr>
          > <tr>
          > <td rowspan="2"><img class="prodImg"
          > src="../images/products/#getItems.itemImage#" ></td>
          > <td>#itemDiscrip#</td>
          > </tr>
          > <tr>
          > <td><form action="#variables.ThisPage#?CatID=#URL.CatID#"
          > method="post" name="form" id="form">
          > <input name="Qty" type="text" id="Qty" value="1" size="4" />
          > <input name="ItemID" type="hidden" id="ItemID"
          > value="#getItems.ItemID#" />
          > <input name="Submit" type="submit" class="buttons" value="Add to
          > Quote" />
          > </form></td>
          > </tr>
          > </table>
          > </cfloop>
          </cfoutput>