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>