Re: using reference to the fetched rows

[Manish Sapariya]

Should have read
perldoc DBI
========
Note that the same array reference is returned for each fetch, so
          don't store the reference and then use it after a later fetch.
          Also, the elements of the array are also reused for each row, so
          take care if you want to take a reference to an element. See also
          "bind_columns".
=============
Thanks anyways, :-)
-Manish
On 04/22/2005 11:27 AM, Manish Sapariya wrote:
Hi list,
When using DBI module as,
my $return_list = $sth->fetchrow_arrayref;
Can I copy the reference to some other variable
say, e.g.
my $CopyOfResult = $return_list;
and do another query using the same handle and
use $CopyOfResult and $return_list?
My question is how does perl will release the
memory used to store the results?
Thanks,
Manish
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>