Create hash from MySQL field headers

Hi all,

I've been developing a module for our accounting system and am trying
to create a hash with the names equal to the fieldnames of the
database table.

It seems as though 'ListFields' is not functioning, and am wondering
if there is another way.

I simply want to SELECT a single line from the table, have it stored
in a hash, with the name as the fieldname and the value as the actual
data.

Any help would be greatly appreciated, and I am not afraid to go
R'ingAFM if someone could supply decent links.

TIA,

Steve

Steve Bertrand wrote:

> Hi all,

Hello,

> I've been developing a module for our accounting system and am trying
> to create a hash with the names equal to the fieldnames of the
> database table.
>
> It seems as though 'ListFields' is not functioning, and am wondering
> if there is another way.
>
> I simply want to SELECT a single line from the table, have it stored
> in a hash, with the name as the fieldname and the value as the actual
> data.
>
> Any help would be greatly appreciated, and I am not afraid to go
> R'ingAFM if someone could supply decent links.

perldoc DBI
look for selectrow_hashref

HTH :)

Lee.M - JupiterHost.Net

> Steve Bertrand wrote:
> 
>
> Hello,
> 
>
> perldoc DBI
> look for selectrow_hashref

Mucho gracias... I'll look it up, but the name certainly implies that
it is what I am after.

> HTH :)

I'm certain it will.

Thanks again!

Steve

>
> Lee.M - JupiterHost.Net
>

>>perldoc DBI 
>
>
> Mucho gracias... I'll look it up, but the name certainly implies that
> it is what I am after.

Glad I could help :)
 
>
> I'm certain it will.
>
> Thanks again!
>
> Steve
>