Outputting SQL aliases as table headers

2013-08-29 Thread Monique Boea
Hello all How can I output sql aliases as headers in a table? See attached. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Russ Michaels
in the same way that you would output any column name in a table. You just output it. thAlias Name/th On Thu, Aug 29, 2013 at 1:29 PM, Monique Boea moniqueb...@gmail.com wrote: Hello all How can I output sql aliases as headers in a table? See attached.

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Monique Boea
but the sql column name is what I need to have as the table column name and there are spaces in the aliases. On Thu, Aug 29, 2013 at 10:46 AM, Russ Michaels r...@michaels.me.uk wrote: in the same way that you would output any column name in a table. You just output it. thAlias Name/th

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Russ Michaels
I still do not see what your problem is, it is just text in a table header, it can be anything you like, including spaces On Thu, Aug 29, 2013 at 4:01 PM, Monique Boea moniqueb...@gmail.com wrote: but the sql column name is what I need to have as the table column name and there are spaces

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Monique Boea
They are dynamic with spaces. On Thu, Aug 29, 2013 at 11:04 AM, Russ Michaels r...@michaels.me.uk wrote: I still do not see what your problem is, it is just text in a table header, it can be anything you like, including spaces On Thu, Aug 29, 2013 at 4:01 PM, Monique Boea

RE: Outputting SQL aliases as table headers

2013-08-29 Thread DURETTE, STEVEN J
Subject: Re: Outputting SQL aliases as table headers They are dynamic with spaces. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Russ Michaels
are you trying to say that you are generating the table dynamically and have no idea in advance what column names you will be using ? On Thu, Aug 29, 2013 at 4:07 PM, Monique Boea moniqueb...@gmail.com wrote: They are dynamic with spaces. On Thu, Aug 29, 2013 at 11:04 AM, Russ Michaels

Re: Outputting SQL aliases as table headers

2013-08-29 Thread Rodney Enke
of the columns returned from a cfquery. Of course replace query_name with the name of your actual query. -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Thursday, August 29, 2013 11:08 AM To: cf-talk Subject: Re: Outputting SQL aliases as table headers