Friday 03-09-2010
About Us | Contact Us | FAQ | Support | Links
Coldfusion Custom Tags, CFXs, CFCs, Full Applications and more!
< Built by ColdFusion Developers, for ColdFusion Developers >
 
Home | Tag Categories | Latest Tags | Top Rated Tags | Top Selling Tags | My Account | Search | Sell Your Tags | Tags A-Z
CF paginate Query

CF paginate Query - Easily create paginated queries using MySQL
Developer Name: Brandon Corbin
Company Name: Brandon Corbin Consulting
Email Developer Email Developer:
Latest Version: 1.0
Price: $16
License: One Copy per Server.
Encrypted: No
Average Rating:
Times Rated: 1
Rate This Tag:


Tag Comments

Only works with MYSQL
The code in this tags uses LIMIT which does not transfer into SQL 2000. I am looking for a way to modify it to work in SQL 2000.

Posted on: Friday 11 Aug 2006
By George Murphy

This works...
Try using this in MSSQL:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=850&lngWId=5

Posted on: Monday 09 Oct 2006
By Tom Nunamaker

 Related ColdFusion Applications
Developers who purchased CF paginate Query also purchased:
  1. CF_TreeControl
  2. CFX_HTTP5
  3. CF_FileManager V3.2 (Cross Browser)
  4. CF_RelatedSelectsControl
  5. Calendar Control
  6. cf_image_resize
  7. CFX PDF (Adobe PDF Generator)
  8. Quick Calendar
  9. CF_Tab
  10. UDI - Universal Database Interface Version 3.9


What Is CF paginate Query?
This tag allows you to easily create multiple paged queries.

name="VariableName"
datasource="DataSourceName"
perPage="Number of results per page"
next="Text for Next Link"
previous = "Text for Previous LInk"
pageListSpacer = "Each page number seperator"
queryString = "this will pass on any url variables that need to be present when going back and forth between pages"
class = "CSS Class Name"

This tag will then output the following variables:

#pageList# - i.e. 1 | 2 | 3 | 4 | 5 with links already generated
#nextLInk# - i.e. Next >>
#previousLink# - i.e. << Previous
#totalPages# - the number of pages for the query
#recordcount# - total records in the query


 


< Business Strength Coldfusion Custom Tags >
Sitemap | Privacy | Branding | Web Services | Support | Contact Us