| |
cf_sorTable |
SorTable+ |
| Data source |
Developers supplies an existing record set to the tag.
|
Tag communicates with database directly to retrieve a record set.
|
| Database support |
All databases supported by ColdFusion.
|
- Microsoft Access
- Microsoft SQL Server
- MySQL
- PostgreSQL
|
| Non-database record set support |
Yes. Record sets may be generated using:
- cfdirectory
- cfftp
- cfhttp
- cfldap
- cfpop
- cfquery
- queryNew()
|
No
|
| Performance limitations |
About 10,000 records. Load is on CF Server. |
Tested with 500,000 records and and limited only by database performance. Tables should be well indexed for optimal performance. Load is on database Server. |
| Multi-page results |
Yes |
Yes |
| Filtering of data by end user |
No |
Yes |
| Checkboxes, buttons and images |
Possible but not built-in |
Yes |
| Caching |
No (developer's responsibility to cache the full record set) |
Yes (built-in caching of sorted pages of results) |
| Skill level |
Beginner |
Beginner |
