Nissim Karpenstein <[EMAIL PROTECTED]> wrote: [SNIPPED] > What if we put in the criteria setStartRow and setNumberOfRows, and then in > the DB, supportsNativeLimit, and supportsNativeOffset. > > Then in BasePeer, when they have those things set in the criteria, if the DB > supports it all natively, then we'll build the query that way, otherwise, > we'll use the functionality from Village/JDBC, by calling the > getSelectResults which takes the startRow and numberOfRows parameter. > > That way, the functionality will be supported in Turbine for all databases, > and we'll use the custom syntax for the databases which support it. +1 Use the native if possible, then the general form. Nice. Jeff Brekke mailto:[EMAIL PROTECTED] http://sites.netscape.net/ekkerbj ____________________________________________________________________ Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. ------------------------------------------------------------ To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/> Problems?: [EMAIL PROTECTED]
