Hi all, Does anyoneknow if torque has any mechanism to support limits on results when the database doesn't support native limits or is complicated to implement like MSSQL? I mean like using the jdbc to limit which results come back?
I was getting errors when trying to use limits and offsets on MSSQL. It looks like MSSQL has a really weird way of supporting limits: http://www.craigsmullins.com/ssu_0900.htm or at least I haven't quite worked out how this can support me grabbing an arbitrary subset of rows. I see currently the SQLServer adaptor just extends the Sybase one. I managed to actually send queries through by over-riding the supportsNativeLimit to return false for SQLServer, assuming that Torque would then use jdbc methods to limit the size of the returning set of results, but apparently not. Is there an intention to support that? I know some dbs don't implement native limits assuming the jdbc will let you take care of it. Thanks in advance. CHEERS> SAM -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
