Skip to main content
July 7, 2008
Question

Paging Results

  • July 7, 2008
  • 1 reply
  • 324 views
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?
This topic has been closed for replies.

1 reply

Inspiring
July 7, 2008
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>