Bug In Aardvark

[Jason]

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

[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
>
>



_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521