January 15th, 2004, 04:05 PM
using 3 criteria in link sort
I am sure this is rather easy but I am not figuring it out. I have a page set up that allows the user to sort the returned data either alphabetically or phylogentically. the prolem is that to do it phylogenetically I need to pass three column names. When I run it locally it is fine, but when I put it on the server it chokes. it is seeing the "string" as text because of the comma and spaces and I think that is the issue. here is the relevant code.
<cfparam name="sortBy" default="GSID">
<CFQUERY NAME="qryAllTaxa" DATASOURCE="ichweb">
ORDER BY #sortBy#
<link rel="stylesheet" type="text/css" href="iis.css" title="default">
<div class=head3>Sort list:</br>
| <a class=list href="SpecList.cfm?sortBy=GSID">Alphabetically</a> | <a class=list href="SpecList.cfm?sortBy=OrderCode, FamilyCode, SubFamilyCode">Phylogenetically</a> |
<div class=head3>Choose taxa to view</div>
<a class=list href="LHDataIll.cfm?GSID=#qryAllTaxa.GSID#" target="SearchLH">
any help is greatly appreciated.
January 18th, 2004, 01:31 PM
Try using #urlencodeformat("OrderCode, FamilyCode, SubFamilyCode")#.
The syntax maybe off alittle.