Add a column to the table that is not a database column

Add a column to the table that is not a database column

diogogmtdiogogmt Posts: 1Questions: 0Answers: 0
edited July 2011 in General
I'm trying to add a new column to the table, that is not a database column.
I can't find any examples.
Any help is appreciated.

Thanks.

Replies

  • fbasfbas Posts: 1,094Questions: 4Answers: 0
    edited July 2011
    1) You can tell your database to use the same field twice, then you can edit one of those fields at will, i.e. with fnRender or any other callback function.

    http://www.datatables.net/forums/discussion/5862/creating-an-action-column-for-icons-view-edit-delete#Item_6

    2) You could also use database functions in your SQL / DataTables fields
    [code]
    SELECT id, name_last, name_first, rand() as r FROM sometable;
    [/code]


    3) your server side code can add an entry into your aaData anywhere you like with whatever value you like
This discussion has been closed.