At 6:41 AM -0400 8/13/99, Ee Loon wrote:
>consider the following statement:
> select * from table;
> In perl, i used to have a while loop to fetch each
> rows that matches the selection. Is there a way to retreive all rows with a
>single command instead of issuing multiple
>fetchrow() in PERL?
What are you using? DBI?
You can use fetchall_arrayref with a statement handle or selectall_arrayref
with a database handle. I'm being deliberatly vague here, because you
really should look up how to use them in the DBI documentation.
Paul DuBois, paul@stripped