Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

perl dbi question

Hi, in perl dbi, how do I find out how many columns
each result record has , and what data type is each column?

Thanks.
0
xiaoxiangz
Asked:
xiaoxiangz
1 Solution
 
yourbutlerCommented:
DBIx::Recordset::Metadata without getting into details.
0
 
ahoffmannCommented:
$sth=$dbh->prepare("your command");
$sth->execute():
$sth->bind_columns(undef,@cols);
print "number of columns: $#cols";
$type_info_all = $dbh->type_info_all;
# see also $dbh->type_info;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now