in reply to perl dbi : fetchrow_arrayref

Two ideas

Replies are listed 'Best First'.
Re^2: perl dbi : fetchrow_arrayref
by mjscott2702 (Pilgrim) on Oct 22, 2010 at 11:07 UTC
    If caching the results, the following should be taken into consideration (from the DBI perldoc):

    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".