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">&nbsp;</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">&nbsp;</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>&nbsp;</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&ouml;schen?');" >
                                                        <img 
src="../images/del.gif" width="17" height="20" border="0"
alt="Eintrag l&ouml;schen" title="Eintrag l&ouml;schen">
                                                </a></td>
                                </tr>
                </cfoutput>
    </tbody>
        </cfif>
</table>

Reply via email to