Skip to main content
I
InDenver
Participating Frequently
October 27, 2009
Question

Any way to use a CFTable with something other than a query?

  • October 27, 2009
  • 1 reply
  • 720 views

Is there a way to create a CFTable with something other than a query? Most of the data for my tables comes from a database query, but I have to make several changes form what is stored in the database to what we display to the user. I was hoping to be able to load the information into an array or something similar and use that for CFTable.

I am only a part-time Cold Fusion developer, so I’m not too savvy with all the CFML functions. Thanks for the help.

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    October 27, 2009

    Depending on what changes you are talking about, you might be able to do it with sql.

    I
    InDenverAuthor
    Participating Frequently
    October 27, 2009

    Definitely not appropriate to make these changes in the SQL. It's very involved, and I have several pages that are very similar to this, so I was hoping to use an array or something else and CFTable to decouple the calculation of the data for the table with the creation of the table itself.  Right now, all these calculations for determining what data to show are in-line with the generation of the tables.

    Thank you for the suggestion, however.

    ilssac
    ilssac
    Inspiring
    October 27, 2009

    Have you looked at the query functions that allow you to modify, add, or even create record set data objects?

    Query functions

    http://livedocs.adobe.com/coldfusion/8/htmldocs/functions-pt0_16.html#1099653

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices