Quote:
then you need to do a $sth = $db->select
Thats the bit Im referring to. But you have it right.
Its when you include something like ->fetchrow_hashref that you don't use $sth ...eg this is wrong:
my $sth = $table->select( { FatherID => 0 }, ['ID', 'Full_Name'] )->fetchrow;
....but this is right:
my @rec = $table->select( { ID => 1 }, ['ID', 'Full_Name'] )->fetchrow;
....and this is wrong:
my @rec = $table->select( { ID => 1 }, ['ID', 'Full_Name'] );
...but this is right:
my $sth = $table->select( { FatherID => 0 }, ['ID', 'Full_Name'] );