AW: need help to know the column names and data types

2005-10-02 Thread Renee Backer
my ($sth) = $dbh-column_info(undef,undef,$tablename,'%') or die $dbh-errstr(); while(my $row = $sth-fetchrow_hashref()){ print Name: ,$row-{COLUMN_NAME},\tType: ,$row-{TYPE_NAME},\n; } -Ursprungliche Nachricht- Von: Umesh Barik [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 30.

need help to know the column names and data types

2005-09-30 Thread Umesh Barik
Hi I am new to DBI programming. I am trying to write a generic package which will handle all the database operations like create table, insert records, delete and also modify records. For a query user need to enter the table name only and the package will get the column names, data types,

RE: need help to know the column names and data types

2005-09-30 Thread Ian Harisay
You'll want to look for metadata in the man pages of the DBI. You'll also want to make sure your particular DBD supports the DBI calls. -Original Message- From: Umesh Barik [mailto:[EMAIL PROTECTED] Sent: Friday, September 30, 2005 5:36 AM To: dbi-users@perl.org Subject: need help to

Re: need help to know the column names and data types

2005-09-30 Thread Ron Savage
On Fri, 30 Sep 2005 17:05:35 +0530, Umesh Barik wrote: Hi Umesh 1) http://charlotte.pm.org/kwiki/index.cgi?BreadProject 2) http://search.cpan.org/ and search for CGI::Application or DBIx::Admin 3) (Old code) http://savage.net.au/Perl-tutorials.html (# 35 or 41) -- Cheers Ron Savage, [EMAIL