|
|
Known issues
Outstanding issues
| Issue |
Tag produces no output at all. |
| Diagnosed |
20060217 |
| Affected version |
All |
| Affected environment |
All |
| Status |
Resolved in next release |
| Priority |
High |
| Description |
In some circumstances, cf_sorTable produces no output. A resource file distributed with cf_sorTable in a sub-folder is also called sortable.cfm. The ColdFusion Server calls this file as the custom tag, thus causing no output. |
| Resolution |
- Open
customtags/sortable.cfm and replace resourcebundles/sortable with resourcebundles/core
- Replace
resourceBundles.sortable with resourceBundles.core
- Open the
customtags/sortable/resourcebundles/ folder and rename all files, replacing sortable with core, e.g. core.cfm, core_de.cfm, core_en.cfm, etc.
- Open
customtags/sortable/resourcebundles/core.cfm and replace sortable_en.cfm with core_en.cfm
|
| Issue |
Table columns referencing same query column share passthrough attributes |
| Diagnosed |
20041003 |
| Affected version |
All |
| Affected environment |
All |
| Status |
Resolved in next release |
| Priority |
High |
| Description |
If you have several columns in your table that refer to the same query column in the cf_column column attribute, and you are passing through attributes that are ignored by cf_column (such as style or onmousedown) then the same attributes will be used for each of these columns. Specifically, the attributes from the last column sharing the same column attribute will be used. This is because the passed through data is stored using the column name as a key, and the later columns are overwriting the data for the earlier columns. |
| Work around |
In your query, create duplicate identical columns using SQL aliases. For example:
SELECT myColumn AS myColumn1, myColumn AS myColumn2, myColumn AS myColumn3
FROM myTable
Set the cf_column column attributes to different aliases (myColumn1, myColumn2, ...).
|
| Issue |
Sort is case sensitive |
| Diagnosed |
20040424 |
| Affected version |
All |
| Affected environment |
ColdFusion Server 5 |
| Status |
Outstanding bug |
| Priority |
Low |
| Description |
Sorted text data is case-sensitive, so all upppercase text is sorted separately from lowercase text. This is an inherent problem with ColdFusion 5. |
| Work around |
- Upgrade to ColdFusion Server 6; or
- Convert all your record data to a consistent case; or
-
Fix the case in your query, e.g. in T-SQL ( Server):
SELECT UPPER(LEFT(myColumn, 1)) + LOWER(RIGHT(myColumn, LEN(myColumn) - 1)) AS myNewColumn, or in Microsoft Access: SELECT UCase(Left(myColumn,1))+LCase(Right(myColumn,Len(myColumn)-1)) AS myNewColumn
|
Resolved issues
| Issue |
Conflict with cfflush |
| Diagnosed |
20040805 |
| Affected version |
1.1 |
| Affected environment |
All |
| Status |
Resolved in 1.2 release |
| Priority |
High |
| Description |
If used in combination with cfflush, cf_sorTable may throw an error. |
| Work around |
Replace line 84 with
<cftry>
<cfhtmlhead text="<link rel=""STYLESHEET"" type=""text/CSS""
href=""#skinPath#/display."">">
<cfcatch />
</cftry> and add a link to the skin's style sheet to your page head manually. |
| Issue |
Link attribute unset throws error |
| Diagnosed |
20040522 |
| Affected version |
All |
| Affected environment |
All |
| Status |
Resolved in 1.2 release |
| Priority |
High |
| Description |
If you do not set the cf_sorTable link attribute, an error is thrown. |
| Work around |
Edit sortable.cfm, add <cfset baseClass=""><cfset link="##"> to the beginning of line 242. You will need to add an onclick attribute to each column. |
Structured Query Language
A language for getting information from and updating a database.
Cascading Style Sheet
Describes how a document should be displayed or printed.
Transact-SQL
An extended form of SQL used by Microsoft SQL Server.
|
