My name is Karina Nagahama.
I want to know about DBI.
I'm working on Windows NT, Apache, Perl, mod_perl Oracle8 and DBI.
I'm using DBI in a .pm file.
In order to select information from the database I wrote wrote the next
sentences:
my $state = $dbhandler->prepare(q{SELECT USER_ID, PASSWORD, KOKYAKU_CD,
KYOTEN_CD FROM T_M_WEB_USER});
$state->execute();
Then in order to read the information selected, I wrote the next sentences:
while (my $record = $state->fetchrow_arrayref){
print '<BR> User ID : ', $record->[0]; #[USER_ID]
print ' PASSWORD : ', $record->[1]; #[PASSWORD]
}
In this case I have to pick-up the field information with the field number
$record->[0].
I want to pick-up the selected information by calling the fields by their
names.
How can I pick-up the field information with the field name ? (for example
USER_ID)
Sorry for trouble you.
[EMAIL PROTECTED]
