Trigger and Sort and Toggles Between Sorts

scripter73 · Feb 1, 2002

Hi,

I have a page that displays data from an array. The array has 5 fields:

Binder/Policy#
Date
Insured
Account#
Amount

The data is initially displayed sorted by Insured, then by Date. I call this one SORT 1.
My SORT 2 is displayed sorted by Date, then by Insured.

This is my goal. I want to display my SORT 1 data, and then have the
user click on something (preferably) the header, and then display the other sort (SORT 2), and be
able to switch back and forth between the two based on how the user determines the sort.

I'm having a hard time figuring out where to start. Here are a few of my issues:

1) I'd like to make the header look like "links", but not behave like links, because I
don't want to redirect the page. Therefore, my <a href="" action=""> will look sort of
funky.

2) I'll probably have to recall my current page with something like a (this) pointer.

If someone could point me in the right direction, I'd be eternally grateful.

To view my pages, goto the following:

http://www.freecfm.com/m/meeka1/homepage.cfm

Click on the Sweep Bank Reconciliation link to get to:

http://www.freecfm.com/m/meeka1/sweep.cfm

Thanks,
scripter73

Change Your Thinking, Change Your Life.

KevinFSI · Feb 1, 2002

Well, making your headers clickable without making them behave like links is simply a matter of assigning the right style attributes to them. You'd just need to assign an onClick event handler to either the <A> or the <TD> containing the <A>. That would be up to you.

There are a few ways you could handle this.
1. Make all the headers a link that just reloads the page with the sort option. You could make the default sort = date then if the user clicks on the "name" header, they're taken right back to the same page, but now sort = name. Very simple solution...calls for a lot of interface between client and server.

2. You could write a script that does the same thing without making trips to the server, buy creating a JavaScript array and sorting the array right on the client's machine, then rebuilding the table accordingly. This is no small task.

There are other ways, but hopefully this will spark your thinking. Kevin
slanek@ssd.fsi.com

"Life is what happens to you while you're busy making other plans."
- John Lennon

calista · Feb 1, 2002

Here, scripter73!

thread232-194717 Calista :-X
Jedi Knight,
Champion of the Force

scripter73 · Feb 1, 2002

Thanks KevinFSI and Calista for your posts.

Calista, I have HUGE questions. I read the thread. Thanks for the wealth of info.

I have no problem admitting that I'm not up to date on the usage of cookies in Cold Fusion nor am I completely familiar with the <cfparam> tag.

Here's my current logic for my program.

HOMEPAGE.CFM calls SWEEP.CFM (has an include for ARRAY_SORT.CFM).

My ARRAY_SORT.CFM page uses an Allaire tag that sorts my array. It has all of the ascending, descending specifications in it, what columns to primary/secondary sort by, etc.

My question is: Can I still use the cookie method as you've indicated with my current sort routine? Or is this method in lieu of my routine?

I guess I just not seeing it, so I'll post what I currently have for my ARRAY_SORT.CFM template:

<html>
<head>
<title>KDL Custom Tag Usage</title>
<script language="javascript">
function caller_id(){
alert("<cfoutput>#cgi.http_referer#</cfoutput>&quot

;
}//function caller_id()
</script>
</head>

<body>

Original Array (Sorted By Lastname, then Date):<BR>
<table cellspacing=0 cellpadding=0 width=100% border=0>
<tr width=100% bgcolor="#6699cc">
<td width=10%><font size=3 color="black">Binder/Policy#</font></td>
<td width=20% align="center"><font size=3 color="black">Date</font></td>
<td width=30% colspan=1 align="left"><font size=3 color="black">Insured</font></td>
<td width=20% align="right"><font size=3 color="black">Account#</font></td>
<td width=20% align="right"><font size=3 color="black">Amount</font></td>
</tr>

<cfloop from=1 to=#ArrayLen(bankArray)# index="i">
<cfif (#i# mod 2) eq 0>
<tr bgcolor="silver" width=100%>
<cfelse>
<tr bgcolor="ffffff" width=100%>
</cfif>
<cfloop from=1 to=5 index="j">
<cfset #grand_total# = #grand_total# + #bankArray[5]#>
<cfif (#j# eq 5) or (#j# eq 4)>
<td align="right" border=0 nowrap>
<cfelseif (#j# eq 2)>
<td align="center" border=1>
<cfelse>
<td border=0>
</cfif>
<CFOUTPUT>#bankArray[j]#</CFOUTPUT>
</td>
</cfloop>
</tr>
</cfloop>
</table>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr></tr>
<tr width=100% align="right" bgcolor="#6699CC"><td>Grand Total: <cfoutput>#grand_total#</cfoutput><td></td></tr>
</table>

<br><br><br>

 (this is an Allaire custom tag to perform the sort)
<CF_MD_Array_Sort
Sort_Order= 2,3
Array_Name = #bankArray#
Asc_Desc = 'Asc'
Sort_Type = 'text'>


Date-Sorted Array (Sorted By Date, then Lastname):<BR>
<table cellspacing=0 cellpadding=0 width="100%" border=0>
<tr width=100% bgcolor="#6699cc">
<td width=10%><font size=3 color="black">Binder/Policy#</font></td>
<td width=20% align="center"><font size=3 color="black">Date</font></td>
<td width=30% colspan=1 align="left"><font size=3 color="black">Insured</font></td>
<td width=20% align="right"><font size=3 color="black">Account#</font></td>
<td width=20% align="right"><font size=3 color="black">Amount</font></td>
</tr>
<cfloop from=1 to=#ArrayLen(bankArray)# index="i">
<cfif (#i# mod 2) eq 0>
<tr bgcolor="silver" width=100% border=0>
<cfelse>
<tr bgcolor="ffffff" width=100% border=0>
</cfif>
<cfloop from=1 to=5 index="j">
<cfif (#j# eq 5)>
<cfset #grand_total# = #grand_total# + #tmparray[j]#>
</cfif>
<cfif (#j# eq 5) or (#j# eq 4)>
<td align="right" border=1 nowrap>
<cfelseif (#j# eq 2)>
<td align="center" border=1>
<cfelse>
<td border=1>
</cfif>
<cfif (#j# eq 5)>
<cfoutput>#NumberFormat(tmparray[j],"999,999.99&quot#</cfoutput>
<cfelse>
<cfoutput>#tmparray[j]#</cfoutput>
</cfif>
</td>
</cfloop>
</tr>
</cfloop>
</table>
<cfset #grand_total# = #NumberFormat(grand_total,"999,999.99&quot#>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr></tr>
<tr width=100% align="right" bgcolor="#6699CC"><td>Grand Total: <cfoutput>#grand_total#</cfoutput><td></td></tr>
</table>

</body>
</html>

The above is what you're seeing on the page that I previously posted.

I'm really confused. Any light you can shed is appreciated greatly.

Thanks again,
scripter73
Change Your Thinking, Change Your Life.

calista · Feb 1, 2002

Yes, you can definitely use this cookie method, and, you can use any sort routine you want. I wound up writing my own. All CFPARAM does, is create a variable. You can give it a default or not. It keeps you from erroring out if the variable is referenced, but was not yet given a value by a CFSET.

OK, this code goes somewhere near the top of your page that displays your info:

<CFPARAM name="cookie.SortOrder" default="A">
<CFPARAM name="cookie.oSort" default="1">
<CFPARAM name="newSort" default="">
<CFPARAM name="origSort" default="">

<CFIF IsDefined("URL.newsort&quot

>
<CFSET newsort = URL.newsort>
</CFIF>
<CFIF IsDefined("URL.origsort&quot

>
<CFSET origsort = URL.origsort>
</CFIF>

<CFIF len(origsort) gt 0>
<CFIF cookie.oSort is "#newsort#">
<CFIF cookie.SortOrder is "A">
<CFCOOKIE name="SortOrder" value="D" expires="NEVER">
<CFELSE>
<CFCOOKIE name="SortOrder" value="A" expires="NEVER">
</CFIF>
</CFIF>
<CFCOOKIE name="oSort" value="#origsort#" expires="NEVER">
</CFIF>

Now, this is my header for the table that displays the data:

<CFOUTPUT>
<DIV ALIGN="center">
<TABLE CLASS="Toolbar">
<TR>
<TD><A HREF="DiscussionIndex.cfm?Forum=#Forum#&origsort=1&newsort=1"><SPAN CLASS="BigBlack">Thread</SPAN></A></TD>
<TD><A HREF="DiscussionIndex.cfm?Forum=#Forum#&origsort=2&newsort=2"><SPAN CLASS="BigBlack">Messages</SPAN></A></TD>
<TD><A HREF="DiscussionIndex.cfm?Forum=#Forum#&origsort=3&newsort=3"><SPAN CLASS="BigBlack">Last Post</SPAN></A></TD>
</TR>
</TABLE>
</DIV>
</CFOUTPUT>

Does this help? Calista :-X
Jedi Knight,
Champion of the Force

MarFisk · Feb 4, 2002

Hi scripter73,

I'm entering this discussion kinda toward the end, but I had a similar issue and chose a different approach that I thought I'd toss out there. I put the information into a form and made the header columns submit buttons with the value of the database field being passed. That way, the user doesn't get to see the link at all.

Using this, you could either continue as you are with CF doing the sorting or, as I did, just redo the request to the database. Though this is more load on the database, it can sometimes be faster than having the data reordered by Cold Fusion.

The form submits back to the same page but the value of the sort order is supplied by the form.

For example, the query looks a little like this:

<CFQUERY>
Select a,b,c from table1 where a='#Form.a#' Order By #Form.SortOrder#
</CFQUERY>

scripter73 · Feb 4, 2002

Thanks MarFisk, I'll interpret your way of doing it.

This is to Calista (or to whoever may know this answer).

Calista, I took your advice, and I'm ALMOST there.

The only problem is that I cannot get my arrays to toggle back and forth based on what the user selected. It just shows me the same sort no matter what.

My idea is that when the user clicks on the link, I can add a sorttype to the url and toggle between my displays based on the url variable.

Here's what I mean:

<html>
<head>
<title>Custom Tag Usage</title>
</head>

<body>

<CFPARAM Name="SESSION.SORT_TYPE" Default="INSURED">
<CFSET SESSION.SORT_TYPE = "INSURED">

<cfif IsDefined("url.sorttype&quot

eq "FALSE">
<cfset #url.sorttype# = "insured">
<cfset #session.type# = #url.sorttype#>
</cfif>

<cfoutput></cfoutput>


<CFPARAM name="cookie.SortOrder" default="A">
<CFPARAM name="cookie.oSort" default="1">
<CFPARAM name="newSort" default="">
<CFPARAM name="origSort" default="">

<CFIF IsDefined("URL.newsort&quot

>
<CFSET newsort = URL.newsort>
</CFIF>
<CFIF IsDefined("URL.origsort&quot

>
<CFSET origsort = URL.origsort>
</CFIF>

<CFIF len(origsort) gt 0>
<CFIF cookie.oSort is "#newsort#">
<CFIF cookie.SortOrder is "A">
<CFCOOKIE name="SortOrder" value="D" expires="NEVER">
<CFELSE>
<CFCOOKIE name="SortOrder" value="A" expires="NEVER">
</CFIF>
</CFIF>
<CFCOOKIE name="oSort" value="#origsort#" expires="NEVER">
</CFIF>

<form name="sortform" action="submit" method="get">
<CFIF #url.sorttype# eq "insured">
Original Array (Sorted By Lastname, then Date):<BR>
<table cellspacing=0 cellpadding=0 width=100% border=0>
<tr width=100% bgcolor="#ffffff">
<td width=10%><font size=3 color="black">Binder/Policy#</font></td>
<td width=20% align="center"><font size=3 color="black"><A HREF="sweep.cfm?Forum=#Forum#&origsort=2&newsort=2&sorttype=date">Date</A></font></td>
<td width=30% colspan=1 align="left"><font size=3 color="black"><A HREF="sweep.cfm?Forum=#Forum#&origsort=1&newsort=1&sorttype=insured">Insured</A></font></td>
<td width=20% align="right"><font size=3 color="black">Account#</font></td>
<td width=20% align="right"><font size=3 color="black">Amount</font></td>
</tr>

<cfloop from=1 to=#ArrayLen(bankArray)# index="i">
<cfif (#i# mod 2) eq 0>
<tr bgcolor="silver" width=100%>
<cfelse>
<tr bgcolor="ffffff" width=100%>
</cfif>
<cfloop from=1 to=5 index="j">
<cfset #grand_total# = #grand_total# + #bankArray[5]#>
<cfif (#j# eq 5) or (#j# eq 4)>
<td align="right" border=0 nowrap>
<cfelseif (#j# eq 2)>
<td align="center" border=1>
<cfelse>
<td border=0>
</cfif>
<CFOUTPUT>#bankArray[j]#</CFOUTPUT>
</td>
</cfloop>
</tr>
</cfloop>
</table>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr></tr>
<tr width=100% align="right" bgcolor="#6699CC"><td>Grand Total: <cfoutput>#grand_total#</cfoutput><td></td></tr>
</table>

<br><br><br>
<CFELSEIF #url.sorttype# EQ "date">


<CF_MD_Array_Sort
Sort_Order= 2,3
Array_Name = #bankArray#
Asc_Desc = 'Asc'
Sort_Type = 'text'>


Date-Sorted Array (Sorted By Date, then Lastname):<BR>
<table cellspacing=0 cellpadding=0 width="100%" border=0>
<tr width=100% bgcolor="#6699cc">
<td width=10%><font size=3 color="black">Binder/Policy#</font></td>
<td width=20% align="center"><font size=3 color="black">Date</font></td>
<td width=30% colspan=1 align="left"><font size=3 color="black">Insured</font></td>
<td width=20% align="right"><font size=3 color="black">Account#</font></td>
<td width=20% align="right"><font size=3 color="black">Amount</font></td>
</tr>
<cfloop from=1 to=#ArrayLen(bankArray)# index="i">
<cfif (#i# mod 2) eq 0>
<tr bgcolor="silver" width=100% border=0>
<cfelse>
<tr bgcolor="ffffff" width=100% border=0>
</cfif>
<cfloop from=1 to=5 index="j">
<cfif (#j# eq 5)>
<cfset #grand_total# = #grand_total# + #tmparray[j]#>
</cfif>
<cfif (#j# eq 5) or (#j# eq 4)>
<td align="right" border=1 nowrap>
<cfelseif (#j# eq 2)>
<td align="center" border=1>
<cfelse>
<td border=1>
</cfif>
<cfif (#j# eq 5)>
<cfoutput>#NumberFormat(tmparray[j],"999,999.99&quot#</cfoutput>
<cfelse>
<cfoutput>#tmparray[j]#</cfoutput>
</cfif>
</td>
</cfloop>
</tr>
</cfloop>
</table>
<cfset #grand_total# = #NumberFormat(grand_total,"999,999.99&quot#>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr></tr>
<tr width=100% align="right" bgcolor="#6699CC"><td>Grand Total: <cfoutput>#grand_total#</cfoutput><td></td></tr>
</table>
</CFIF>
</form>
</body>
</html>

Thanks so much. Any help's appreciated.

scripter73
Change Your Thinking, Change Your Life.

scripter73 · Feb 4, 2002

Forgot to add how to get to it:

http://www.freecfm.com/m/meeka1/homepage.cfm

Click on the Sweep Bank Reconciliation link to get to:

http://www.freecfm.com/m/meeka1/sweep.cfm

Thanks.
Change Your Thinking, Change Your Life.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Trigger and Sort and Toggles Between Sorts

scripter73

Programmer

KevinFSI

Programmer

calista

Programmer

scripter73

Programmer

calista

Programmer

MarFisk

Programmer

scripter73

Programmer

scripter73

Programmer

Similar threads

Part and Inventory Search

Sponsor