Hi,
->query returns an array ref of array refs by default. I think what you want is:
my $sth = $table->query_sth ( { review_id => $id } );
which will return an $sth that you can call fetchrow, etc, on.
Or you may just want:
my $sth = $table->select ( { review_id => $id } );
The select method is much simpler, query is useful for taking form input and building an sql query out of it (allows you to pass in max hits, page number, sort order, etc).
Cheers,
Alex
--
Gossamer Threads Inc.
->query returns an array ref of array refs by default. I think what you want is:
my $sth = $table->query_sth ( { review_id => $id } );
which will return an $sth that you can call fetchrow, etc, on.
Or you may just want:
my $sth = $table->select ( { review_id => $id } );
The select method is much simpler, query is useful for taking form input and building an sql query out of it (allows you to pass in max hits, page number, sort order, etc).
Cheers,
Alex
--
Gossamer Threads Inc.