Re: Maintaining column name and column order using DBI

It sounds like you're looking for the NAME (or NAME_lc or NAME_uc) statement handle attribute. Per the DBI docs:

NAME (array-ref, read-only)
Returns a reference to an array of field names for each column. The names may contain spaces but should not be truncated or have any trailing space. Note that the names have the letter case (upper, lower or mixed) as returned by the driver being used. Portable applications should use NAME_lc or NAME_uc.

print "First column name: $sth->{NAME}->[0]\n";

HTH

Comment on Re: Maintaining column name and column order using DBI Select or Download Code

Replies are listed 'Best First'.
Re^2: Maintaining column name and column order using DBI by Tatnall (Beadle) on Mar 15, 2006 at 18:58 UTC
Excellent, that's the type of thing I was looking for. Thank you. "Recognizing who we aren't is only the first step toward knowing who we are." - Os Guinness	[reply]