Hi, I want to sort my search results from a access database in 10 at a page and showed in page 1,2,3.....last. Now Im just using next and previous to goto frm one page to another.
<cfif pageno GT 1>
<td><a href="searchResult1.cfm?page=#pageno-1#" class="style3">< Previous </a></td>
</cfif>
<cfif counter LE #rec_count#>
<td align="right"><a href="searchResult1.cfm?page=#pageno+1#" class="style3">Next > </a></td>
</cfif>Any suggestions??
Jump to PostAre you having trouble writing the database query, the pagination code, or both?
Are you having trouble writing the database query, the pagination code, or both?
Are you having trouble writing the database query, the pagination code, or both?
I have the query, but Im just trying to sort the results...Im not sure where to do it-in database or in code in DreamW??
In 99.99% of all cases, you should get the database server to handle the ordering.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.