Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Sorting in Coldfusion
Hi,
How to sort multiple tables at the same time in a cF page.
For example when the user sort first table then it has to automatically sort other tables according to first one in that page...
How to sort multiple tables at the same time in a cF page.
For example when the user sort first table then it has to automatically sort other tables according to first one in that page...
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
1 - create a sort function for each table
2 - each sort function use a key
3 - for the "other" table the key come from the first table
4 - for the first table the key is the order (desc or asc)
5 - each time you sort the first one, you call the sort function of the other table
function sort(table_to_sort, key) {
// sort code
}
2 - each sort function use a key
3 - for the "other" table the key come from the first table
4 - for the first table the key is the order (desc or asc)
5 - each time you sort the first one, you call the sort function of the other table
function sort(table_to_sort, key) {
// sort code
}
I am a newbie to CF, if possible can u pls give me a code snippet..
Right now we have a function called sort and we are calling this sort function at both the tables as below:
table1:
<th class=" headline" width="2%" nowrap="nowrap" sv="c" onclick="sort(0,document.g
table2:
<th class=" headline" width="2%" nowrap="nowrap" sv="c" onclick="sort(0,document.g
Right now we have a function called sort and we are calling this sort function at both the tables as below:
table1:
<th class=" headline" width="2%" nowrap="nowrap" sv="c" onclick="sort(0,document.g
table2:
<th class=" headline" width="2%" nowrap="nowrap" sv="c" onclick="sort(0,document.g
function for sorting is:
function sort (b_0,b_1)
{ var current_col = this.document.getElementBy
if (b_0 != current_col) { b_1 = 0}
else {
if (b_1 == '0' ) { b_1 = '1'; }
else { b_1 = '0' ;}
}
var sortby = "'["+b_0+","+b_1+"]'";
this.document.getElementBy
this.document.getElementBy
}
And we are calling this function at both tables like below :
table1:
<table width="100%" cellpadding="0" id="bdhl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
<th class=" headline" width="4%" nowrap="nowrap" vv="b" onclick="sort(1,document.g
table2:
<table width="100%" cellpadding="0" id="hefl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
<th class=" headline" width="4%" nowrap="nowrap" vv="b" onclick="sort(1,document.g
I am trying to get if user sort by table1 zipcode , sorting has to take place even for table2 zipcode ..
function sort (b_0,b_1)
{ var current_col = this.document.getElementBy
if (b_0 != current_col) { b_1 = 0}
else {
if (b_1 == '0' ) { b_1 = '1'; }
else { b_1 = '0' ;}
}
var sortby = "'["+b_0+","+b_1+"]'";
this.document.getElementBy
this.document.getElementBy
}
And we are calling this function at both tables like below :
table1:
<table width="100%" cellpadding="0" id="bdhl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
<th class=" headline" width="4%" nowrap="nowrap" vv="b" onclick="sort(1,document.g
table2:
<table width="100%" cellpadding="0" id="hefl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
<th class=" headline" width="4%" nowrap="nowrap" vv="b" onclick="sort(1,document.g
I am trying to get if user sort by table1 zipcode , sorting has to take place even for table2 zipcode ..
Ok to call the onclick javascript of th, table2, you may use :
<table width="100%" cellpadding="0" id="bdhl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
<table width="100%" cellpadding="0" id="bdhl" >
<th class=" headline" width="2%" nowrap="nowrap" vv="a" onclick="sort(0,document.g
Thank you so much it is working to some extent but..
When a user is sorting table1 column1 ascending and when he is revisiting the page it is changing both the tables to desc..
Any clue..
When a user is sorting table1 column1 ascending and when he is revisiting the page it is changing both the tables to desc..
Any clue..
you can use jquery tablesorter plugin, That will fix your issue, Just need to use the class and that's it, its done
http://tablesorter.com/docs/
http://tablesorter.com/docs/
we have tried tablesorter but it did not work for multi-table sorting...
Can you let me know how it works..
Can you let me know how it works..
Can anyone please help me on this...
When a user is sorting table1 column1 ascending and when he is revisiting the page it is changing both the tables to desc..
But for desc it is working fine...
Do I need to tweak anything here
function sort (b_0,b_1)
{ var current_col = this.document.getElementBy
if (b_0 != current_col) { b_1 = 0}
else {
if (b_1 == '0' ) { b_1 = '1'; }
else { b_1 = '0' ;}
}
var sortby = "'["+b_0+","+b_1+"]'";
this.document.getElementBy
this.document.getElementBy
}
When a user is sorting table1 column1 ascending and when he is revisiting the page it is changing both the tables to desc..
But for desc it is working fine...
Do I need to tweak anything here
function sort (b_0,b_1)
{ var current_col = this.document.getElementBy
if (b_0 != current_col) { b_1 = 0}
else {
if (b_1 == '0' ) { b_1 = '1'; }
else { b_1 = '0' ;}
}
var sortby = "'["+b_0+","+b_1+"]'";
this.document.getElementBy
this.document.getElementBy
}
Premium Content
You need an Expert Office subscription to comment.Start Free Trial