On Friday 29 November 2002 20:32, Lucas Franzen wrote:

> Ajay schrieb:
> > hi
> > Is there any way by which you can restrict the no of rows returned
> > in FireBird (eg 1 to 200)
>
> SELECT FIRST <N> SKIP <M> <FIELDS> FROM ...
>
> N = Number of rows returned
> M = Number of records to skip before selecting.
>
> Luc.

Gee, thanks Luc. I've been wondering about that functionality. I thought I
had to resort to a database abstraction layer like ADOdb
(http://php.weblogs.com/ADODB) to get it. But I tried it just now, and it
works like a charm. =)

Thanks!
-eric
--
 .--.  Enrique D. Rosel II
( () ) Q Linux Solutions, Inc.
 `--\\ A Philippine Open Source Solutions Co.  http://www.q-linux.com/