Hi, I have a query which returns 431 results: <cfquery name="qGetCompany"> select companyname from company where countrycode='au' </cfquery> I want to separate these results into many pages, each page contains 20 results and have links to each page, if the current result is on page 4 ,should have this : page1, 2, 3,<<prev, 4.. next>> 6, 7 ...20... startrow & endrow don't work:(resuilts are not from continueing row numbers in the table) <cfloop query="qGetCompany" startrow="#starrowthispage#" endrow="#endrowthispage#"> Anyway to do it? Thank Ins _____________________________________________________________________________ http://movies.yahoo.com.au - Yahoo! Australia & NZ Movies - Find out what's on at the local cinema with Yahoo! Movies ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
