[nici2508]

Hi,

At the moment my search results page shows all results on one page so the user has to scroll right down to see them all, how can i edit the code below to limit results to 10 per page and have a link to see 1-10 of results 11-20 of results or something similar?

Thanks

Nicola

<span class="text">
  <cfif len(#searchterm#) eq 0>
		  <cflocation addtoken="no" url="searchdj.cfm?message=error" />
</cfif>



		<cfquery name="q1" datasource="BTS2009">
select * from contact
where artist like '%#searchterm#%'



		</cfquery>
		
	 </span>
	 
	 <span class="heading">Results</span><br />
	 
	 Search results will display all closest matches in the artist category selected. 
	 
	 <span class="text">
	 
<cfif q1.recordcount gt 0>
<cfoutput query="q1"><br />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		  <td width="25%" align="left" valign="top"><span class="heading">Artist ID:</span><br /><span class="heading">Artist Genre:</span><br />
			<span class="heading">Username:<br /></span><span class="heading">Gender:<br />
			</B></span><span class="heading">Plays:<br />
			</span><span class="heading">Available in:<br /></span><span class="heading"><br /></span></td>
		  <td width="34%" align="left" valign="top"><span class="text">#q1.artist#</span><br /><span class="text">#q1.id#</span><br /><span class="text">#q1.username#<br /></span><span class="text">#q1.gender#<br /></span><span class="text">#q1.music#<br /></span><span class="text">#q1.city#<br />
		  </span><span class="text"><br /></span><span class="bodytext"></span></td>
		  <td width="41%" valign="top"><img src="../images/#username#.jpg" alt="#q1.firstname#, #q1.surname#" /></td>
		</tr>
		<tr>
		  <td> </td>
		  <td> </td>
		  <td valign="top" class="text"><a href="viewprofile.cfm?id=#id#">View Profile</a></td>
		</tr>
		<br /><br />
	  </table>
</cfoutput>

<cfelse>
<p class="heading">Sorry no matches were found.</p>
</cfif>
</span>

[xheartonfire43x]

Hi Nicola,

This might help you http://paginationcfc.riaforge.org/. It is a CFC for creating Pageination. I have not used it before, but have heard good things about it.