#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    4
    Rep Power
    0

    using 3 criteria in link sort


    Hello,

    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">
    SELECT *
    FROM tblSpeciesDict
    ORDER BY #sortBy#
    </cfquery>

    <html>
    <head>
    <title>Species List</title>
    <link rel="stylesheet" type="text/css" href="iis.css" title="default">
    </head>

    <body class=list>
    <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>
    <div class=head3>Choose taxa to view</div>
    <cfoutput query="qryAllTaxa">
    <div>
    <a class=list href="LHDataIll.cfm?GSID=#qryAllTaxa.GSID#" target="SearchLH">
    #qryAllTaxa.Genus# #qryAllTaxa.Species#</a>

    </div>
    </cfoutput>

    any help is greatly appreciated.

    thanks

    bill
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    5
    Rep Power
    0
    Try using #urlencodeformat("OrderCode, FamilyCode, SubFamilyCode")#.

    The syntax maybe off alittle.

IMN logo majestic logo threadwatch logo seochat tools logo