Pivot table On Mon, Sep 19, 2011 at 6:14 AM, C. Hatton Humphrey <[email protected]> wrote: > > I'm trying to remember the right name for a data output method where > you take the same column in a query result and spread it across > columns in an output table. > > For example: > Recordset - > Employee Name > Jim Bob > Kate Klaus > Joe Schmoe > Slim Pickins > Jane Goodall > > Output - > Jim Bob - Kate Klaus - Joe Schmoe > Slim Pickins - Jane Goodall > > I remember how to do it in CF (<cfif query.currentrow MOD > 3></tr><tr></cfif>) but I can't remember what the concept is called. > > Thanks! > > > > Until Later! > C. Hatton Humphrey > > No trees were killed in the sending of this message, but a large > number of electrons were terribly inconvenienced. > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:342777 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
