Thanks for your post. This is a known issue and has been fixed in
version 2, which is due in a matter of weeks.
Technical Support Engineer
Red Gate Software Ltd.
T: +44 870 1600 037
"Jason" <firstname.lastname@example.org> wrote in message
> There seems to be a bug in aardvark when doing a bug search.
> If I select a "sort by" field, and a "and then by" to do two sorts on the
> data, the application will crash with the following error:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
> keyword 'ORDER'.
> /Aardvark/bugs.asp, line 514
> Running an SQL trace reveals the following SQL command:
> SELECT TOP 300 Bugs.RecordID
> FROM Bugs LEFT JOIN
> CompanySeverities ON Bugs.SeverityID =
> CompanySeverities.RecordID AND Bugs.CompanyID =
> LEFT JOIN
> Statuses ON Bugs.StatusID = Statuses.RecordID AND
> Bugs.CompanyID = Statuses.CompanyID
> WHERE Bugs.CompanyID = 3 AND ProjectID = 0 AND ProductID = 9 AND
> ISNULL(Bugs.Closed, 'N') = 'N' AND EXISTS
> (SELECT *
> FROM CustomFieldValues
> WHERE BugID = Bugs.RecordID AND
> CustomFieldID = 14 AND CompanyID = 3 AND VALUE = '22')
> ORDER BY CompanySeverities.Sequence DESC
> ORDER BY Statuses.Sequence
> Is this fixed in the new release? When will this new release be released?