Re: Getting columns in DB order

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

>>>>> "apv" == apv  <apv@xxxxxxxx.xxx> writes:

apv> This philosophical issue re CDBI has come up before. The placement of
apv> parts in a device is usually irrelevant to the end user but not to the
apv> mechanic. The column order sometimes has human logic in it that would
apv> be nice to automatically reflect in some cases.

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

        -- 
        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!