"Robert Hicks" <[EMAIL PROTECTED]> wrote
> If I am pulling data out with a $sth->fetchrow_arrayref, how do I see the
> structure of what is coming back? I need to change the description on some
> of the data coming back out (like changing a "C" to "Closed") but I am not
> sure how to see the arrayref.
>
> Robert
>
if you know the field name or its alias you can use $sth->fetchrow_hashref()
to access the value you would use $row->{[fieldname]}
if you dont know the name fo the field or its alias
you can "shuffle" through the structure as you would a normal hashref
if you would like a result set that is more human readable such as 'closed'
instead of 'c'
and you have access to the sql query
you should have the ability to change the query to perform this logic for you
the solution for this would best be found in a database/sql related forum
or you can also use Data::Dumper as JupiterHost said
but the fetchrow_hashref is functionallity built into DBI
