Re: Getting columns in DB order

[prev] [thread] [next] [Date index for 2005/06/14]

>>>>> "Randal" == Randal L Schwartz <merlyn@xxxxxxxxxx.xxx> writes:


Randal> It's not a CDBI issue though.  It's a issue that only comes up with
Randal> misguided DBAs that think that "select *" ordering should be
Randal> controllable.  Stop trying.  Apply a mapping layer where it belongs...
Randal> between the output of the database, and the ultimate report.

And for CDBI relevence, don't use the output of ->columns to control
your output format.  *name* your columns there.  You want address/city/state?
Then say:

        @values = $row->get(qw(address city state));

What's so hard about that?

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!