MaxDB error in limit

[victor Saquicela]

when I set rc.limit=10, atomsframework generate a sql with select ... from a where ... limit 10

this is incorrect to maxdb, in maxdb is select ... form a where......... and rowno<=10.

how can solution this

[Richard Banks]

Thanks for the note on the syntax.

To change the syntax just override the getClauseStringLimit function in CMaxDBDatabase for the MaxDB provider as follows:

    Public Overrides Function getClauseStringLimit() As String
        Return "and rowno <="
    End Function

Please let me know if that works and I'll commit the change to CVS.

- Richard

[Nobody/Anonymous]

it is correct, you can do commit the changes to CVS