Revision 188696a4
Von Sven Schöling vor mehr als 10 Jahren hinzugefügt
| SL/DBUtils.pm | ||
|---|---|---|
|
selectfirst_hashref_query selectfirst_array_query
|
||
|
selectall_hashref_query selectall_array_query
|
||
|
selectall_as_map
|
||
|
selectall_ids
|
||
|
prepare_execute_query prepare_query
|
||
|
create_sort_spec does_table_exist
|
||
|
add_token);
|
||
| ... | ... | |
|
return %hash;
|
||
|
}
|
||
|
|
||
|
sub selectall_ids {
|
||
|
$main::lxdebug->enter_sub(2);
|
||
|
|
||
|
my ($form, $dbh, $query, $key_col) = splice(@_, 0, 4);
|
||
|
|
||
|
my $sth = prepare_execute_query($form, $dbh, $query, @_);
|
||
|
|
||
|
my @ids;
|
||
|
while (my $ref = $sth->fetchrow_arrayref()) {
|
||
|
push @ids, $ref->[$key_col];
|
||
|
}
|
||
|
|
||
|
$sth->finish;
|
||
|
|
||
|
$main::lxdebug->leave_sub(2);
|
||
|
|
||
|
return @ids;
|
||
|
}
|
||
|
|
||
|
sub create_sort_spec {
|
||
|
$main::lxdebug->enter_sub(2);
|
||
|
|
||
Auch abrufbar als: Unified diff
DBUtils: selectall_ids