Solved

Returning a single value from resultset in Perl DBI

Posted on 2009-07-01
3
1,397 Views
Last Modified: 2012-05-07
My result set is going to return only one value from the database. I am connecting to the DB using perl dbi. How shd i fetch the value? Please advise.
0
Comment
Question by:saibsk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
Carl Bohman earned 500 total points
ID: 24757874
Something like this should work (untested)
use DBI;
 
my $dbh = DBI->connect(...) or die "Couldn't connect to database: " . DBI->errstr;
my $sth = $dbh->prepare(...) or die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute() or die "Couldn't execute statement: " . $sth->errstr;
($sth->rows > 0) or die "No rows matched.";
 
my $Data = ($sth->fetchrow_array())[0];
 
$sth->finish;
$dbh->disconnect;

Open in new window

0
 
LVL 1

Expert Comment

by:michaelshavel
ID: 24761994
Do you have some code that you've already tried but doesn't work? If so, post it here please.

Mike
0
 
LVL 39

Expert Comment

by:Adam314
ID: 24787114
You can use prepare/exectue/fetch as shown by bounsy, or you can just use one of the selectrow methods, which does all of these at once.
#Get data as array
my @record = $dbh->selectrow_array('SELECT ....');
 
#Get data as arrayref
my $record = $dbh->selectrow_arrayref('SELECT ....');
 
#Get data as hashref
my $record = $dbh->selectrow_hashref('SELECT ....');

Open in new window

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question