?
Solved

perl dbi question

Posted on 2002-07-22
2
Medium Priority
?
253 Views
Last Modified: 2010-03-05
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
Comment
Question by:xiaoxiangz
[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
2 Comments
 
LVL 1

Expert Comment

by:yourbutler
ID: 7171061
DBIx::Recordset::Metadata without getting into details.
0
 
LVL 51

Accepted Solution

by:
ahoffmann earned 400 total points
ID: 7171252
$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

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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 …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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…
Six Sigma Control Plans
Suggested Courses

764 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