Revision cc125b4f
Von G. Richardson vor fast 7 Jahren hinzugefügt
| SL/DBUtils.pm | ||
|---|---|---|
| 439 | 439 |
you the trouble of mucking around with statement handles for small database |
| 440 | 440 |
queries and does exception handling in the common cases for you. |
| 441 | 441 |
|
| 442 |
Query and retrieval function share the parameter scheme: |
|
| 442 |
Query and retrieval functions share the parameter scheme:
|
|
| 443 | 443 |
|
| 444 | 444 |
query_or_retrieval(C<FORM, DBH, QUERY[, BINDVALUES]>) |
| 445 | 445 |
|
| ... | ... | |
| 600 | 600 |
|
| 601 | 601 |
=item selectrow_query FORM,DBH,QUERY,ARRAY |
| 602 | 602 |
|
| 603 |
Prepares and executes a query using DBUtils functions, retireves the first row
|
|
| 603 |
Prepares and executes a query using DBUtils functions, retrieves the first row
|
|
| 604 | 604 |
from the database, and returns it as an arrayref of the first row. |
| 605 | 605 |
|
| 606 | 606 |
=item selectfirst_hashref_query FORM,DBH,QUERY,ARRAY |
| 607 | 607 |
|
| 608 |
Prepares and executes a query using DBUtils functions, retireves the first row
|
|
| 608 |
Prepares and executes a query using DBUtils functions, retrieves the first row
|
|
| 609 | 609 |
from the database, and returns it as a hashref of the first row. |
| 610 | 610 |
|
| 611 | 611 |
=item selectall_hashref_query FORM,DBH,QUERY,ARRAY |
| 612 | 612 |
|
| 613 |
Prepares and executes a query using DBUtils functions, retireves all data from
|
|
| 613 |
Prepares and executes a query using DBUtils functions, retrieves all data from
|
|
| 614 | 614 |
the database, and returns it in hashref mode. This is slightly confusing, as |
| 615 | 615 |
the data structure will actually be a reference to an array, containing |
| 616 | 616 |
hashrefs for each row. |
| 617 | 617 |
|
| 618 | 618 |
=item selectall_as_map FORM,DBH,QUERY,KEY_COL,VALUE_COL,ARRAY |
| 619 | 619 |
|
| 620 |
Prepares and executes a query using DBUtils functions, retireves all data from
|
|
| 620 |
Prepares and executes a query using DBUtils functions, retrieves all data from
|
|
| 621 | 621 |
the database, and creates a hash from the results using KEY_COL as the column |
| 622 | 622 |
for the hash keys and VALUE_COL for its values. |
| 623 | 623 |
|
Auch abrufbar als: Unified diff
Typos in POD