Can I remove a column from Results?

[mdemarzi]

Hello,

I want to use an order by, but not select the order by field. Doing this is simply not ordering it...

So, how can I remove a column from the result? 😕

It would be easy enough if it was just one column, but I have 20 and I'm letting the users choose which columns to order by and which columns they do not want to display.

Evil users will select a column to order by and then indicate the do not want to display it... which really is a valid request.

Thanks for the help.

Max

[Lars_Berg]

That should not be a problem.

select c1,c2,c3 from t order by c4,c5

should work in most dbms.

[mdemarzi]

http://www.highpowerscores.com

Click on "By Competitor".
Select Doe, John
Order by Class.
Retrieve Scores

Then Skip Class and Retrieve Scores again.

--Nevermind. I'm an idiot. I was sorting by the AS 'Whatever' instead of using the actual field name.