The following module was proposed for inclusion in the Module List:
modid: DBIx::Lookup::Field
DSLIP: Rdpfp
description: Create a lookup hash from a database table
userid: MARCEL (Marcel Grunauer)
chapterid: 7 (Database_Interfaces)
communities:
comp.lang.perl.modules
similar:
rationale:
SYNOPSIS use DBI; use DBIx::Lookup::Field qw/dbi_lookup_field/;
$dbh = DBI->connect(...); my $inst_id = dbi_lookup_field( DBH =>
$dbh, TABLE => 'institution' KEY => 'name', VALUE => 'id', );
print "Inst_A has id ", $inst_id->{Inst_A};
DESCRIPTION
This module provides a way to construct a hash from a database
table. This is useful for the situation where you have to perform
many lookups of a field by using a key from the same table. If, for
example, a table has an id field and a name field and you often have
to look up the name by its id, it might be wasteful to issue many
separate SQL queries. Having the two fields as a hash speeds up
processing, although at the expense of memory.
enteredby: MARCEL (Marcel Grunauer)
enteredon: Sat May 19 11:33:39 2001 GMT
The resulting entry would be:
DBIx::Lookup::
::Field Rdpfp Create a lookup hash from a database table MARCEL
Thanks for registering,
The Pause Team
PS: The following links are only valid for module list maintainers:
Registration form with editing capabilities:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=86000000_503f8ba70ebe4473&SUBMIT_pause99_add_mod_preview=1
Immediate (one click) registration:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=86000000_503f8ba70ebe4473&SUBMIT_pause99_add_mod_insertit=1
