Yes, you can use selectall_hashref, but if you have a huge result set, the performance and memory will be greatly degraded, so it's totally your choice. selectall_hashref does exactly as if you were to iterate through the set and collect data into a hashref.
Ilya -----Original Message----- From: M.W. Koskamp To: Sterin, Ilya; ''Marius Keraitis ' '; ''DBI Perl ' ' Sent: 1/11/02 2:07 PM Subject: Re: SELECT ----- Original Message ----- From: "Sterin, Ilya" <[EMAIL PROTECTED]> To: "'M.W. Koskamp '" <[EMAIL PROTECTED]>; "''Marius Keraitis ' '" <[EMAIL PROTECTED]>; "''DBI Perl ' '" <[EMAIL PROTECTED]> Sent: Friday, January 11, 2002 8:05 PM Subject: RE: SELECT > The list of columns you mean, that will do if you use selectrow_array, and > will equal to the number of columns, but the rows are not known until you > fetch them all, so you must count. > Oops, i confused it with selectall_hashref....
