5 Replies Latest reply on Apr 20, 2010 5:10 AM by Dan Bracuk

    How do I get column headers?

    Jellyhead Level 1

      Long story short:

      I have a database table with literally millions of records.  Every week a new column is added to this table dynamically.

      I need to find out the name of this column is.  I tried using the getColumnList() function, and it works fine – in theory.  The thing is, I have to use a “select * from” query, which I so do not want to do – I have no desire to select asterisk a couple of million records just to get a single column header value.

      I know I’m being an idiot here, but can someone please tell me how to get a column header from a table.  CF8, MySql