Re: getting column names with reply

2002-09-10 Thread Kyle
Thanks to all who replied. Your quick suggestions got me in the right place to solve the problem. -Kyle > Hello! > > If you use fetchrow_hashref(), you'll end up with a hash that has the column > names as the keys. To get get the column names from a record, simply > retrieve the keys of the h

RE: getting column names with reply

2002-09-09 Thread Steve Sapovits
; To: PERL DBI Users > Subject: getting column names with reply > > Hello > > How can I get SQL to return the column names when doing a select using > the DBI? > > Why do I need this? I am trying to make one sub that will do my various > selects. Right now I'

Re: getting column names with reply

2002-09-09 Thread Ronald J Kimball
On Mon, Sep 09, 2002 at 05:03:48PM -0400, Kyle wrote: > Hello > > How can I get SQL to return the column names when doing a select using > the DBI? > > Why do I need this? I am trying to make one sub that will do my various > selects. Right now I'm doing it with discrete subs. I find that the

getting column names with reply

2002-09-09 Thread Kyle
Hello How can I get SQL to return the column names when doing a select using the DBI? Why do I need this? I am trying to make one sub that will do my various selects. Right now I'm doing it with discrete subs. I find that these subs are EXACTLY the same except for parsing the SQL returns by t