Hi,
anyone tried to use OQL-LIMIT on MS SQL-Server? My OQL-Statement is like this here:
SELECT r FROM Rechnung r WHERE r.id = $1 LIMIT $2, $3
The class SQLServerQueryExpression converted it to:
SELECT TOP ?, ? ..... FROM "Rechnung" WHERE "Rec"."id" = ?
First Problem is, he changed the oql.bind() order. And the second problem is that the
SQL-Server support in the TOP-section (similar with LIMIT) only one argument (the max.
row count) and variables also not supported in the TOP-section.
Anyone has a workaround?
Thank you very much.
Should I open a bug report?
Conny Krey�el
Leipzig, Germany
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
