>
> a) SELECT FLD1 from TAB LIMIT 0, 20
> b) SELECT COUNT(*) from TAB where FLD1 = 'X'
>
I would suggest using the executeQuery method of BasePeer for statements
like these. This allows you complete freedom to specify the sql as you
wish, yet still takes care of getting and returning connections, etc. This
would be the easiest way to solve (a) as the LIMIT clause is not implemented
in Query. (b) could be done in a "standard" Peer, but are you
building/creating/restoring an object based on this statement? I would not
necessarily go to the trouble of creating a Peer for a table, if it is not
mapping to an object.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
