Try this piece of code, it's old but it works: http://www.planet-source-code.com/vb...Id=14&lngWId=9

Here's one way (from CFMX manual, pages 468-469):

<CFQUERY DATASOURCE="your_db" NAME="GetLinks">
SELECT link, link_ID FROM your_table
</CFQUERY>
<cfparam NAME ="MaxRows" default="10">
<cfparam NAME ="StartRow" default="1">
<CFOUTPUT QUERY="GetLinks" startrow="#StartRow#" maxrows="#MaxRows#">
#GetLinks.currentRow# --- #link#<BR>
</CFOUTPUT>
<CFIF (StartRow+MaxRows) LTE GetLinks.recordcount>
<a href="your_filename.cfm?StartRow=<cfoutput>#evaluate(StartRow+MaxRows)#</cfoutput>"><img src="/images/arrow.gif></a>
</CFIF><br>
<a href="your_filename.cfm?StartRow=1">Reset counter</a>

(too easy, so I decided to fill it out - just copy & paste; change MaxRows to output different number of records)

hi,
did you ever figure this one out or am i missing something in the posts below? as far as i can tell the replies u hd were pretty useless?
any ideas MUCH appreciated....
cheers
jon

Help! I want to learn the basics about CF. Please, give me some websites!

website links for coldfusion:

macromedia.com
easycfm.com
cffaq.com
coldfusiontutorials.com
webmonkey.com

but for me the macromedia site has always been the best reference

www.communitymx.com is another great site to help with all macromedia products.

Take care,

Walyer

Walyer's Playpen

I tried adapting this piece of code to use on my guestbook to show X number of records per page, and produce a previous/next link, but it does absolutely nothing. I have tried numerous pieces of code to achieve this, but so far, nothing works. Any advice is definitely appreciated.