|
 |
asp_databases thread: Sproc - dynamic ORDER BY clause
Message #1 by "Grant I" <giswim1@a...> on Thu, 16 Aug 2001 14:53:50
|
|
I'm using a Sybase database and I need to allow people to order the
results of a query by a few different things of their choosing. Unlike
SQL Server, Sybase and Oracle databases do not allow for vairables in the
ORDER BY clause. Anyone have any suggestions as to how I can do this?
Thanks!
Grant
Message #2 by David Cameron <dcameron@i...> on Mon, 20 Aug 2001 09:59:19 +1000
|
|
FYI SQL Server does not support dynamic order by clauses.
For a dynamic order by clause build the string and execute it or use
conditional statements.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Grant I [mailto:giswim1@a...]
Sent: Friday, 17 August 2001 12:54 AM
To: ASP Databases
Subject: [asp_databases] Sproc - dynamic ORDER BY clause
I'm using a Sybase database and I need to allow people to order the
results of a query by a few different things of their choosing. Unlike
SQL Server, Sybase and Oracle databases do not allow for vairables in the
ORDER BY clause. Anyone have any suggestions as to how I can do this?
Thanks!
Grant
|
|
|
View Cart
