Support Forums - View Thread

View Thread

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

Messages 1 to 4 of 4 total

Mon, May 14 2007 11:02 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim Is COLLATE supposed to be OK for in the ORDER BY clause or only in the WHERE clause. If it is meant to be OK for ORDER BY it causes an AV in 1.02. Roy Lambert
Mon, May 14 2007 5:45 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Is COLLATE supposed to be OK for in the ORDER BY clause or only in the WHERE clause. If it is meant to be OK for ORDER BY it causes an AV in 1.02. >> Are you setting RequestSensitive to True and is the query on a table with text indexes ? If so, then it could simply be the other issue that you reported with respect to using an ORDER BY with a sensitive result set. -- Tim Young Elevate Software www.elevatesoft.com
Tue, May 15 2007 3:45 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim >Are you setting RequestSensitive to True and is the query on a table with >text indexes ? If so, then it could simply be the other issue that you >reported with respect to using an ORDER BY with a sensitive result set. Yes and Yes - and I assume COLLATE is allowed in ORDER BY? I'll wait for 1.03 Roy Lambert
Tue, May 15 2007 5:31 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Yes and Yes - and I assume COLLATE is allowed in ORDER BY? >> Yes. -- Tim Young Elevate Software www.elevatesoft.com