Bug In Aardvark

Brian Donahue

Hi Jason,

Thanks for your post. This is a known issue and has been fixed in
version 2, which is due in a matter of weeks.

Regards,



Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

T: +44 870 1600 037

E: mailto:brian.donahue@red-gate.com





"Jason" <jspeight@advaoptical.com> wrote in message
news:O80HDBxtCHA.2304@server53...
> 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 =
CompanySeverities.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?
>
> Thanks,
>
> Jason
> jasons@advaoptical.com
>
>