Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Retrieving a fixed number of rows

Quote Reply
Retrieving a fixed number of rows
Hi, from Argentina.

I need to retrieve a fixed number of rows from a table using an SQL statement. I mean, I need to retrieve the first "n" rows of a table where "n" is a number variable.

Does anybody know how to do this ? Blush

I'll really appreciate any help on this.

Thanks in advance.

Bye.

Smile
Quote Reply
Re: [gpbarsky] Retrieving a fixed number of rows In reply to
I'd advise looking at the GT::SQL::Table docs for select_options

The syntax is:

$table->select_options("LIMIT 5");

Last edited by:

Paul: May 23, 2003, 11:38 AM