Hi,
evaluate() should do the trick:
<cfoutput query="GetResults">
<tr>
<td>#Evaluate("getResults." & sortlist[1])# </td>
<td>#Evaluate("getResults." & sortlist[2])# </td>
...
</cfoutput>
HTH,
Chris
> -----Urspr�ngliche Nachricht-----
> Von: Randi Knutson [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 14. Februar 2001 23:08
> An: CF-Talk
> Betreff: Dynamic column order
>
>
> Sorry for the basic question, but here goes:
>
> I'm trying to allow the columns in a query output table to be dynamic in
> order, depending on the sort selection the user previously made in the
> form (in the form field form.sort). Form.sort has four fields in order,
> and they are comma-delimited. In other words, form.sort will contain
> something like "First, Last, City, State". The sql statement uses
> form.sort in order by.
>
> Then, I thought it would be nice if the columns showed up in the order the
> user selected. So on the search results page, I wrote form.sort to a
> series of variables that I can hopefully use in the CFOUTPUT, like this:
>
> <cfset sortlist = ListToArray(form.sort)>
> <cfset col1value = "GetResults.#sortlist[1]#">
> <cfset col2value = "GetResults.#sortlist[2]#">
> <cfset col3value = "GetResults.#sortlist[3]#">
> <cfset col4value = "GetResults.#sortlist[4]#">
>
> Then I wrote out the table, like this:
> <table>
> <cfoutput query="GetResults">
> <tr>
> <td>#variables.col1value# </td>
> <td>#variables.col2value# </td>
> <td>#variables.col3value# </td>
> <td>#variables.col4value# </td>
> </tr>
> </table>
>
>
> All I get in the output table though, is "variables.col1value".....etc. I
> can't figure out what I did wrong....any help would be appreciated!
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
