>How could I set a parameter for a view that allows me to determine which field to use in the ORDER BY clause?
>
>The scenario is:
>I have a view wich selects 2 fields and the user needs to sort it in one field or the other. Do I need 2 views?
Why not just index the view? Just set buffering to 3 (record), and do all the INDEX ONs you want, then set buffering back to 5 (assuming that's the norm)...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.