fetchrow_hashref Ilya Sterin
> -----Original Message----- > From: Karina Nahagama [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 12, 2001 12:51 AM > To: [EMAIL PROTECTED] > Subject: About DBI and Oracle > > > 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] > >
