Sorting issue

[kensington43]

The below sort works with just one field (names) but wont work when I put in another field (city) to sort on.

The one field attempt that works:

<!--- default value for sorting variable --->
<cfparam name="url.sort" default="#encrypt("names ASC","names")#">

<!--- query to sort, 'order by' used url variable to determine sort order --->
<cfquery name="get_data" datasource="#dsn#">
     SELECT *
     FROM cfml_example_data
     ORDER BY #decrypt(urldecode(url.sort),"names")#

</cfquery>

<table width="300" cellpadding="3" cellspacing="1">
<tr>
<td>
Names
<cfoutput>
<a href="index.cfm?sort=#urlencodedformat(encrypt("names DESC","names"))#"><</a> 
<a href="index.cfm?sort=#urlencodedformat(encrypt("names ASC","names"))#">></a> 
</cfoutput>
</td>

     </tr>
     <!--- output of data --->
     <cfoutput query="get_data">
          <tr>
               <td>
                    #names#
               </td> 
             
          </tr>
     </cfoutput>
</table>

The two fields attempt that wont work:

<!--- default value for sorting variable --->
<cfparam name="url.sort" default="#encrypt("names ASC","names")#">
<cfparam name="url.sort" default="#encrypt("city ASC","city")#">

<!--- query to sort, 'order by' used url variable to determine sort order --->
<cfquery name="get_data" datasource="#dsn#">
     SELECT *
     FROM cfml_example_data
<cfif isDefined("url.names")>
     ORDER BY #decrypt(urldecode(url.sort),"names")#
</cfif>
<cfif isDefined("url.city")>
     ORDER BY #decrypt(urldecode(url.sort),"city")#
</cfif>
</cfquery>

<table width="300" cellpadding="3" cellspacing="1">
<tr>
<td>
Names
<cfoutput>
<!--- links to sort data with --->
<a href="index.cfm?sort=#urlencodedformat(encrypt("names DESC","names"))#"><</a> 
<a href="index.cfm?sort=#urlencodedformat(encrypt("names ASC","names"))#">></a> 
</cfoutput>
</td>
<td>
City
<cfoutput>
<a href="index.cfm?sort=#urlencodedformat(encrypt("city DESC","city"))#"><</a> 
<a href="index.cfm?sort=#urlencodedformat(encrypt("city ASC","city"))#">></a> 
</cfoutput>
</td>
     </tr>
     <!--- output of data --->
     <cfoutput query="get_data">
          <tr>
               <td>
                    #names#
               </td> 
               <td>
                    #city#
               </td>         
          </tr>
     </cfoutput>
</table>

 

[webmigit]

New Param Statement.

<cfparam name="url.sort" default="#encrypt("names ASC, city ASC","QuerySort")#">

New Order By Clause

ORDER BY #decrypt(urldecode(url.sort),"QuerySort")#

You should know that there is some issues with sending encrypted strings in urls... It can be a mess, and sometimes undecryptable.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[kensington43]

Thanks I tried it without encryption but it kept giving me errors about parameters not being correct:

<!--- default value for sorting variable --->
<cfparam name="url.sort" default="names ASC, city ASC","QuerySort")">

<!--- query to sort, 'order by' used url variable to determine sort order --->
<cfquery name="get_data" datasource="#dsn#">
     SELECT *
     FROM cfml_example_data
     ORDER BY url.sort,QuerySort)
</cfquery>

<table width="300" cellpadding="3" cellspacing="1">
<tr>
<td>
Names
<cfoutput>
<!--- links to sort data with --->
<a href="index.cfm?sort=names DESC,names"><</a> 
<a href="index.cfm?sort=names ASC,names">></a> 
</cfoutput>
</td>
<td>
City
<cfoutput>
<a href="index.cfm?sort=city DESC,city"><</a> 
<a href="index.cfm?sort=city ASC,city">></a> 
</cfoutput>
</td>
     </tr>
     <!--- output of data --->
     <cfoutput query="get_data">
          <tr>
               <td>
                    #names#
               </td> 
               <td>
                    #city#
               </td>         
          </tr>
     </cfoutput>
</table>

 

[ecobb]

Drop [red],"QuerySort")[/red] from your cfparam tag.

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[kensington43]

Thanks

 

[webmigit]

Beat me to it ECAR. Been a while.

Have a good night.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[ecobb]

Yep, good to see you back!

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher