"ORDER BY" problem
From: Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com>
Date: Wed, 4 Nov 1998 15:22:12 -0500
Message-ID: <71qd51$t0m2_at_tmpsp002.tmpprv.allied.com>
[Quoted] In a query inside the Reports, I want to be able to do "ORDER BY" in accordance with input parameters. Say, I have a table A with columns named
'columnA' and 'columnB'. I also have user parameters named 'param1' and
'param2'. I would like to do the following:
Date: Wed, 4 Nov 1998 15:22:12 -0500
Message-ID: <71qd51$t0m2_at_tmpsp002.tmpprv.allied.com>
[Quoted] In a query inside the Reports, I want to be able to do "ORDER BY" in accordance with input parameters. Say, I have a table A with columns named
'columnA' and 'columnB'. I also have user parameters named 'param1' and
'param2'. I would like to do the following:
select columnA, columnB
from A
order by :param1, :param2;
This presumes of course that the content of each user parameter would be
'A.columnA' or 'A.columnB'.
What is a correct way to do this?
Thanks
ZAch Agatstein Received on Wed Nov 04 1998 - 21:22:12 CET