[jQuery] Re: JQuery Tablesorter can't sort number in Coldfusion
Bettina, try downloading the latest development version:
http://jqueryjs.googlecode.com/svn/trunk/plugins/tablesorter/2.0/
And see if it fixes the problem, there is a bug in the 2.0.3 version that
doesn't auto detect number if the equal zero.
/Christian
2008/5/20 Hamish Campbell [EMAIL PROTECTED]:
H... CF might be causing the problem, but you'll still be able to
see it in the generated code.
Can you compare the output with and without cfoutput - the
difference should give you a clue as to why it isn't working.
On May 19, 11:59 pm, Bettina [EMAIL PROTECTED] wrote:
Hi
Yeah of course. Here i posted a picture how the table looks like:
http://www.onebyte.ch/tablesorter.jpg
But it must be a Problem with ColdFusion because wenn i leave the
cfoutput away, and write the table and content by hand, the problem
ist gone and its working. Its really weard.
And the code from the site looks like this:
link rel=stylesheet type=text/css href=http://192.168.88.5/
OneTool4/site/scripte/tablesorter/themes/blue/style.css
script language=javascript src=http://192.168.88.5/OneTool4/site/
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=25nbsp;/th
th width=70Datum/th
th width=250Titel/th
th width=150Gefahrene Kilometer/th
th nowrap=nowrapKategorie/th
th width=17nbsp;/th
/tr
/thead
tbody
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=78img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td
align=center13.02.2008/td
tda
href=index.cfm?incl=dsp_reise_auto_editedit=78Superman
2/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=78
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=85img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td
align=center01.01.2008/td
tda href=index.cfm?
incl=dsp_reise_auto_editedit=85Abschiebsparty/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=85
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a
/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=87img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
[jQuery] Re: JQuery Tablesorter can't sort number in Coldfusion
Hey, you are right, that was the fault. :-) Thanks a lot for your help. Have a nice day. Bettina
[jQuery] Re: JQuery Tablesorter can't sort number in Coldfusion
jQuery works on the generated source seen by the browser - that is,
it's CLIENT side.
Rather than posting the CF SERVER source, could you post the source as
seen by a browser viewing the page. That will be a LOT easier to
decipher. For example, from the example above, we can't tell what the
values in the cells are likely to be.
On May 19, 9:55 pm, Bettina [EMAIL PROTECTED] wrote:
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#/
cfoutputscripte/tablesorter/themes/blue/style.css
script language=javascript
src=cfoutput#application.websiteURL##application.subfolder#/
cfoutputscripte/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=25nbsp;/th
th width=70Datum/th
th width=250Titel/th
th width=150Gefahrene Kilometer/th
cfif qryGetKat.Recordcount
th nowrap=nowrapKategorie/th
/cfif
th width=17nbsp;/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=statusvalue=0id=#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=statusvalue=1id=#qryGet.rau_id#img src=../images/
status_inaktiv.gif alt=inaktiv title=inaktiv border=0 //a
/cfif
/td
td align=centercfif
len(qryGet.rau_datum)#LSDateFormat(qryGet.rau_datum,
'dd.mm.')#cfelsenbsp;/cfif/td
tda href=index.cfm?
incl=dsp_reise_auto_editedit=#qryGet.rau_id#cfif
LEN(qryGet.rau_titel) GT 40#Left(qryGet.rau_titel,
40)#...cfelse#qryGet.rau_titel#/cfif/a/td
td align=centercfif
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
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a/td
/tr
/cfoutput
/tbody
/cfif
/table
[jQuery] Re: JQuery Tablesorter can't sort number in Coldfusion
Hi
Yeah of course. Here i posted a picture how the table looks like:
http://www.onebyte.ch/tablesorter.jpg
But it must be a Problem with ColdFusion because wenn i leave the
cfoutput away, and write the table and content by hand, the problem
ist gone and its working. Its really weard.
And the code from the site looks like this:
link rel=stylesheet type=text/css href=http://192.168.88.5/
OneTool4/site/scripte/tablesorter/themes/blue/style.css
script language=javascript src=http://192.168.88.5/OneTool4/site/
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=25nbsp;/th
th width=70Datum/th
th width=250Titel/th
th width=150Gefahrene Kilometer/th
th nowrap=nowrapKategorie/th
th width=17nbsp;/th
/tr
/thead
tbody
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=78img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center13.02.2008/td
tda
href=index.cfm?incl=dsp_reise_auto_editedit=78Superman
2/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=78
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=85img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center01.01.2008/td
tda href=index.cfm?
incl=dsp_reise_auto_editedit=85Abschiebsparty/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=85
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a
/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=87img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center24.04.2008/td
tda
href=index.cfm?incl=dsp_reise_auto_editedit=87Ahorn/
a/td
td align=center0/td
tdItalien/td
td
a
href=act_reise_auto_del.cfm?del=87
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a
/td
[jQuery] Re: JQuery Tablesorter can't sort number in Coldfusion
H... CF might be causing the problem, but you'll still be able to
see it in the generated code.
Can you compare the output with and without cfoutput - the
difference should give you a clue as to why it isn't working.
On May 19, 11:59 pm, Bettina [EMAIL PROTECTED] wrote:
Hi
Yeah of course. Here i posted a picture how the table looks
like:http://www.onebyte.ch/tablesorter.jpg
But it must be a Problem with ColdFusion because wenn i leave the
cfoutput away, and write the table and content by hand, the problem
ist gone and its working. Its really weard.
And the code from the site looks like this:
link rel=stylesheet type=text/css href=http://192.168.88.5/
OneTool4/site/scripte/tablesorter/themes/blue/style.css
script language=javascript src=http://192.168.88.5/OneTool4/site/
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=25nbsp;/th
th width=70Datum/th
th width=250Titel/th
th width=150Gefahrene Kilometer/th
th nowrap=nowrapKategorie/th
th width=17nbsp;/th
/tr
/thead
tbody
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=78img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center13.02.2008/td
tda
href=index.cfm?incl=dsp_reise_auto_editedit=78Superman
2/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=78
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=85img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center01.01.2008/td
tda href=index.cfm?
incl=dsp_reise_auto_editedit=85Abschiebsparty/a/td
td align=center0/td
tdSchweiz/td
td
a
href=act_reise_auto_del.cfm?del=85
onClick=javascript:return confirm('Wollen Sie diesen Eintrag wirklich
louml;schen?');
img
src=../images/del.gif width=17 height=20 border=0
alt=Eintrag louml;schen title=Eintrag louml;schen
/a
/td
/tr
tr
td align=center
a
href=act_change_param.cfm?param=statusvalue=0id=87img
src=../images/status_aktiv.gif alt=aktiv, sichtbar title=aktiv,
sichtbar border=0 //a
/td
td align=center24.04.2008/td
tda
href=index.cfm?incl=dsp_reise_auto_editedit=87Ahorn/
a/td
td align=center0/td
tdItalien/td
td
a
