Return-Path: 
 <turbine-user-return-14233-qmlist-jakarta-archive-turbine-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-turbine-user-archive@apache.org
Received: (qmail 73804 invoked from network); 4 Feb 2003 00:33:10 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 4 Feb 2003 00:33:10 -0000
Received: (qmail 12686 invoked by uid 97); 4 Feb 2003 00:34:44 -0000
Delivered-To: qmlist-jakarta-archive-turbine-user@nagoya.betaversion.org
Received: (qmail 12679 invoked from network); 4 Feb 2003 00:34:44 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 4 Feb 2003 00:34:44 -0000
Received: (qmail 72277 invoked by uid 500); 4 Feb 2003 00:32:50 -0000
Mailing-List: contact turbine-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:turbine-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:turbine-user-subscribe@jakarta.apache.org>
List-Help: <mailto:turbine-user-help@jakarta.apache.org>
List-Post: <mailto:turbine-user@jakarta.apache.org>
List-Id: "Turbine Users List" <turbine-user.jakarta.apache.org>
Reply-To: "Turbine Users List" <turbine-user@jakarta.apache.org>
Delivered-To: mailing list turbine-user@jakarta.apache.org
Received: (qmail 72175 invoked from network); 4 Feb 2003 00:32:49 -0000
Received: from emerald.msu.montana.edu (HELO JEWELS.msu.montana.edu)
 (153.90.2.73)
  by daedalus.apache.org with SMTP; 4 Feb 2003 00:32:49 -0000
Received: by jewels.msu.montana.edu with Internet Mail Service (5.5.2656.59)
	id <DRK8JG7X>; Mon, 3 Feb 2003 17:32:56 -0700
Message-ID: <95AC7052DE4A78488DCFB615F7A49EA409C0462C@jewels.msu.montana.edu>
From: "Gaasch, Derek" <dgaasch@montana.edu>
To: 'Turbine Users List' <turbine-user@jakarta.apache.org>
Subject: Criteria Question -- mySQL "Limit" or howto select first X rows r
	eturned
Date: Mon, 3 Feb 2003 17:32:55 -0700 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2656.59)
Content-Type: text/plain
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N


I'm looking for a way to select the first x rows in a table instead of
returning all the rows and then just iterating through the first x values
returned.... with mySQL there's a limit clause, but I cant find a criteria
method which uses it... anyone know of one? If not, I know I can just issue
a direct query, but thought I'd like to stick with Criteria objects (unless
theres a good reason not to).

Thanks
-d

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org