I wasn't using $hash_ref but I am using it now. It provides column name as key. Thanks !!!
Jie "Kokarski, Anton" wrote: > if you are using method $hash_ref = $sth->fetchrow_hashref; then it should > be easy > > Anton > > -----Original Message----- > From: jie zhang [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 4:58 PM > To: [EMAIL PROTECTED] > Subject: column name > > Hi, > > I am writing a script which constructs dynamic query. I can't hard code > column names. > e.g. select * from $table; Is it possible to print out column names > from database through dbi ? > > Thanks in advance, > > Jie
