Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Wed, Jul 11 2007 5:58 PM	Permanent Link
"A Roberts"	Is there a good way (I'll take a mediocre way, too) to use a parameter to change the Order By clause in a Select statement? I'm guessing that the Case operator would be involved, but I haven't figured out how. Thanks.
Wed, Jul 11 2007 8:28 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	<< Is there a good way (I'll take a mediocre way, too) to use a parameter to change the Order By clause in a Select statement? I'm guessing that the Case operator would be involved, but I haven't figured out how. Thanks. >> Unfortunately you cannot use parameters in an ORDER BY clause, only in WHERE or JOIN clauses. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Jul 16 2007 4:36 PM	Permanent Link
Lance Rasmussen Jazzie Software Team Elevate	Dang... woulda been handy... "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:BCA48759-8CD5-4908-9960-29107AA14A4E@news.elevatesoft.com... > > << Is there a good way (I'll take a mediocre way, too) to use a parameter > to change the Order By clause in a Select statement? I'm guessing that > the Case operator would be involved, but I haven't figured out how. > Thanks. >> > > Unfortunately you cannot use parameters in an ORDER BY clause, only in > WHERE or JOIN clauses. > > -- > Tim Young > Elevate Software > www.elevatesoft.com >