<?xml version="1.0" encoding="windows-1252"?>
<node id="450012" title="Re^2: fetchall( )" created="2005-04-21 10:25:14" updated="2005-06-20 17:55:53">
<type id="11">
note</type>
<author id="145724">
Jasper</author>
<data>
<field name="doctext">
When you do a fetchall_arrayref, that returns a reference to what is essentially a 2d array.

&lt;code&gt;
my $ref = $sth-&gt;fetchall_arrayref();

gives:

$ref   [
          [row of 1st data in here],
          [2nd row data here],
          [3rd row of data here]
       ]
&lt;/code&gt;

</field>
<field name="root_node">
449914</field>
<field name="parent_node">
449965</field>
</data>
</node>
