comparing multiple values

[Anthony Spears]

I am outputting a cfquery and I want to compare multiple columns within the same record to see which one is the largest. Any suggestion besides a huge complicated if else statement?

[Stressed_Simon]

Yes do it in the database before you get the query this is always preferable.

[Anthony Spears]

Well the problem with that is that I am building a cfquery on the fly from an xml document.

[Dan_Bracuk]

Try a simple if/else statement.

Once you have your query, add a column to it. Then loop through it and update this column based on that simple if/else statement. You might have a few else ifs depending on the number of columns you want to compare, but that just makes it long, not complicated.