0 Replies - 2723 Views - Last Post: 29 March 2012 - 12:09 PM Rate Topic: -----

#1 grabitnz  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 29-March 12

Grouping CF output problem

Posted 29 March 2012 - 12:09 PM

Hi there everybody
I am having problems with pagination using cfloop and the grouping of cfoutput in nested cfoutput tags.
The code below lists my results eg:
producer
query results
producer
query results
producer
query results
etc

what i require is eg
producer 1
query results 1
query results 2
query results 3
producer 2
query results 1
query results 2
query results 3
etc etc

I have been belting my head against the wall with this for 2 days now and its getting to the frustratyion boil over time????

the page works fine UNTILL i introduce the cfloop for the pagination so this appears to be where my problems are as i cannot use the 'group' attribute in a cfloop query, - that would be to easy eh?

If anyone can help with this it would be very much appreciated
[code]
<!---PAGINATION (WITHIN <tr> TAG) loop to show 10 query results at a time--->
<cfloop query="getproducts" startrow="#URL.offset#" endrow="#limit#">
<cfoutput group="producer">
<table width="610" border="0" align="center" cellpadding="0" cellspacing="0">
<!---<cfset rowCounter = 0>--->
<tr valign="middle" class="smalltext11light">
<td colspan="5"><img src="siteImages/5pxSpacer.gif" width="57" height="5"></td>
</tr>
<tr valign="middle" class="smalltext11light">
<td colspan="5"><div align="left" class="smalltext11redbold"><strong> <span class="smalltext11redbold">#UCase(getproducts.producer)#</span></strong></div></td>
</tr>
<tr valign="middle" class="smalltext11light">
<td colspan="5"><img src="siteImages/5pxSpacer.gif" width="50" height="5"></td>
</tr>
<!--- ends set anchors--->
<!---Lists listings by Town--->
<cfoutput>
<tr>
<td width="72" rowspan="2" valign="top" ><cfif getproducts.prodImage neq ''>
<a href="productCatDetails.cfm?ID=#getproducts.ID#"><img src="prodImages/#getProducts.prodImage#" border="0"></a>
<cfelse>
<a href="productCatDetails.cfm?ID=#getproducts.ID#"><img src="prodImages/noImageLoaded.gif" border="0"></a>
</cfif></td>
<td width="468" valign="top" class="smalltext11light capitalize"><strong>#getproducts.prodname#</strong> - (#getproducts.weight#)</td>
<td width="70" align="right"class="smalltext11light"><a href="productCatDetails.cfm?ID=#getproducts.ID#"><img src="siteImages/catMoreInfo.gif" name="catMore" width="89" height="16" border="0" id="catMore"></a></td>
</tr>
<tr>
<td valign="top" class="smalltext11light">#getproducts.prodDesc#<br>
<br></td>
<td align="right"class="smalltext11light"></td>
</tr>
<tr>
<td colspan="3" valign="top" ><hr size="1" noshade></td>
</tr>
<!--- <cfset rowCounter=rowCounter+1>--->
</cfoutput>
<!--- ends town listings
<cfset rowCounter = 0>--->
</table>
</cfoutput>
<!---END PAGINATION LOOP --->
</cfloop>
[code]

many thanks in advance
grabit

Is This A Good Question/Topic? 0
  • +

Page 1 of 1