I found this article:
http://www.oracle.com/oramag/code/asktom/q10.html
But I don't think it would be very nice to put something like that into
turbine....
-Nissim
John McNally wrote:
>
> Sounds okay. Is there a syntax for Oracle?
>
> ----- Original Message -----
> From: Nissim <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 03, 2000 9:41 AM
> Subject: PROPOSAL: Limiting resultsets with Criteria and BasePeer
>
> > I want to make a query to postgresql that will look like this:
> >
> > SELECT * FROM emp LIMIT 7
> >
> > For those not familiar with postgres syntax (I think mysql works like
> > this too) this selects the first 7 records from the table.
> >
> > In SQL Server 7.0 you can say
> >
> > SELECT TOP 7 * FROM emp
> >
> > I don't know how it's done in other DB's.
> >
> > The proposal is to add the following:
> >
> > In Criteria:
> > public void setLimit(int n)
> > public int getLimit()
> >
> > In DB:
> > public abstract boolean supportsLimit()
> > public boolean getLimitStyle()
> > public static final int's for none, pqsql/mysql, sql server limit style
> >
> > In Query:
> > public setTop(String top)
> > public setLimit(String limit)
> > change toString to build the new words into the query if necessary
> >
> > In BasePeer.createQueryString add logic to check if the db supports
> > limit, and if so, call the appropriate method in Query based on the
> > db.getLimitStyle.
> >
> > -Nissim
> >
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> > Problems?: [EMAIL PROTECTED]
> >
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
