You can check query_name.CurrentRow as you are outputting the query. The
page number is CurrentRow/10.

-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 12:43 PM
To: CF-Talk
Subject: Determining no. of pages in results


Hi,

I have a query which searches a table, and displays results, 10 at a time.
How can I display the page-numbers though, so users can scroll through to a
page further along the query (1,2,3,4 etc)?

To get the number of pages, all I've done is:

<cfset noPages = round(getads.recordcount / 10>

Any ideas?

Thanks.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to