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]
