the
> initial query. I tried Statement.setFetchSize() but that doesn't appear to
> help. Any suggestions in this area?
>
> Thanks,
> Bret
>
> -Original Message-
> From: James Montebello [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 11, 2002 5:57 PM
> To: Bret Ewin
ppear to
help. Any suggestions in this area?
Thanks,
Bret
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5:57 PM
To: Bret Ewin
Cc: [EMAIL PROTECTED]
Subject: Re: returning partial result set
If all you want is the first page, then simpl
In your select statement, use the LIMIT option
SELECT * FROM table limit 10;
will return the first ten rows, or
SELECT * FROM table limit 100,10
will return rows 101-110
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 4:47 PM
To: [EMAIL PRO
If all you want is the first page, then simply use SELECT ... LIMIT n,
which will only return the first n rows of the set. To "page through"
data, use LIMIT offset, n, which will return n rows starting at offset
rows into the dataset. Note that doing this on a changing table will
give results t
