projekt kivitendo

you the trouble of mucking around with statement handles for small database

queries and does exception handling in the common cases for you.

  query_or_retrieval(C<FORM, DBH, QUERY[, BINDVALUES]>)

=item selectrow_query FORM,DBH,QUERY,ARRAY

from the database, and returns it as an arrayref of the first row.

=item selectfirst_hashref_query FORM,DBH,QUERY,ARRAY

from the database, and returns it as a hashref of the first row.

=item selectall_hashref_query FORM,DBH,QUERY,ARRAY

the database, and returns it in hashref mode. This is slightly confusing, as

the data structure will actually be a reference to an array, containing

hashrefs for each row.

=item selectall_as_map FORM,DBH,QUERY,KEY_COL,VALUE_COL,ARRAY

the database, and creates a hash from the results using KEY_COL as the column

for the hash keys and VALUE_COL for its values.