Re: Re: How to get fields from a SQL DB one by one

2003-10-15 Thread Manfred . Beilfuss
<[EMAIL PROTECTED]An: [EMAIL PROTECTED] ore.co.in> Kopie:

Re: How to get fields from a SQL DB one by one

2003-10-15 Thread ramakrishna
Ya i am using DBI. Ramakrishna.S - Original Message - From: "Ramprasad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 15, 2003 5:35 PM Subject: Re: How to get fields from a SQL DB one by one > On Wed, 15 Oct 2003 12:11:43 +0530, Ram

Re: How to get fields from a SQL DB one by one

2003-10-15 Thread Ramprasad
On Wed, 15 Oct 2003 12:11:43 +0530, Ramakrishna wrote: > Hi, > > Can any one tell me How to get fields from a SQL Database. > I need to get each field separately. > > Thanks in advance, > Ramakrishna.S Which database, Are U using DBI Ram -- To unsubscribe, e-mail: [EMAIL PROTECTED] For addit

Re: How to get fields from a SQL DB one by one

2003-10-14 Thread simran
this (the method below) is database dependent, i use it with postgres: sub getFieldNames { my $dbh = new DBI(...) my $sth = $dbh->prepare("SELECT * FROM $table WHERE 1=0"); $sth->execute; # # Get all the field names (execlue the field's we were asked to exclude) and return..