Getting columns in DB order

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

Hello all.  I'm using Class::DBI::mysql to automatically create
Class::DBI classes for my tables.  Now I'm working on writing routines
to output my objects into CSV files and I'm having trouble getting the
column ordering right.  Here's what I'm doing:

  @COLUMNS = __PACKAGE__->columns();

That results in a random ordering of columns.  You might wonder why I
can't just:

  @COLUMNS = sort __PACKAGE__->columns();

The problem is that this is demographic data, so the correct ordering
isn't alphabetical - it's the order of the columns in the DB
(firstname, lastname, address1, address2, city, state, country, ...).
Is there any way I can get this ordering without resorting to
hard-coding the columns in my table?

-sam