[jQuery] JQuery Tablesorter can't sort number in Coldfusion
Hi
I've got a table with a column with numeric values but it doesn't sort
right. Its all made in coldfusion. I would like to sort the Column:
"Gefahrene Kilometer". There are all Number in there.
Here my example:
<!--- Get Data --->
<cfquery name="qryGet" dataSource="#application.dsn#"
username="#application.dsnusername#"
password="#application.dsnpasswort#">
SELECT DISTINCT *
FROM mod_reise_auto LEFT JOIN mod_reise_kategorien ON rau_kat_id =
kat_id
</cfquery>
<!--- Sortierung --->
<link rel="stylesheet" type="text/css"
href="<cfoutput>#application.websiteURL##application.subfolder#</
cfoutput>scripte/tablesorter/themes/blue/style.css">
<script language="javascript"
src="<cfoutput>#application.websiteURL##application.subfolder#</
cfoutput>scripte/tablesorter/jquery.tablesorter.js"></script>
<script language="javascript">
$(document).ready(function() {
// extend the default setting to always include the zebra widget.
$.tablesorter.defaults.widgets = ['zebra'];
// extend the default setting to always sort on the second column
$.tablesorter.defaults.sortList = [[3,1]];
$("table").tablesorter({
// pass the headers argument and assing a object
headers: {
// assign the fourth column (we start counting zero)
5: {
// disable it by setting the property sorter to false
sorter: false
}
}
});
});
</script>
<table class="tablesorter" cellspacing="1">
<thead>
<tr>
<th width="25"> </th>
<th width="70">Datum</th>
<th width="250">Titel</th>
<th width="150">Gefahrene Kilometer</th>
<cfif qryGetKat.Recordcount>
<th nowrap="nowrap">Kategorie</th>
</cfif>
<th width="17"> </th>
</tr>
</thead>
<cfif qryGet.RecordCount>
<tbody>
<cfoutput query="qryGet">
<tr>
<td align="center">
<cfif qryGet.rau_status EQ 1 >
<a href="act_change_param.cfm?
param=status&value=0&id=#qryGet.rau_id#"><img src="../images/
status_aktiv.gif" alt="aktiv, sichtbar" title="aktiv, sichtbar"
border="0" /></a>
<cfelse>
<a href="act_change_param.cfm?
param=status&value=1&id=#qryGet.rau_id#"><img src="../images/
status_inaktiv.gif" alt="inaktiv" title="inaktiv" border="0" /></a>
</cfif>
</td>
<td align="center"><cfif
len(qryGet.rau_datum)>#LSDateFormat(qryGet.rau_datum,
'dd.mm.yyyy')#<cfelse> </cfif></td>
<td><a href="index.cfm?
incl=dsp_reise_auto_edit&edit=#qryGet.rau_id#"><cfif
LEN(qryGet.rau_titel) GT 40>#Left(qryGet.rau_titel,
40)#...<cfelse>#qryGet.rau_titel#</cfif></a></td>
<td align="center"><cfif
len(qryGet.rau_kilometer)>#rau_kilometer#</cfif></td>
<td>
<a href="act_reise_auto_del.cfm?del=#qryGet.rau_id#"
onClick="javascript:return confirm('Wollen Sie diesen Eintrag wirklich
löschen?');" >
<img src="../images/del.gif" width="17" height="20" border="0"
alt="Eintrag löschen" title="Eintrag löschen">
</a></td>
</tr>
</cfoutput>
</tbody>
</cfif>
</table>