> > Leigh I tried your suggestion and it outputs the value of the
> column:
> > Name"]) />
>
> It should work fine under CF8/9 because query columns are arrays. What
> is your CF
version?
Oh WAIT!! DUH!! I figured it out. That rocks!!!
Thanks I think this is what I needed.
Sorry, brain
> > Leigh I tried your suggestion and it outputs the value of the
> column:
> > Name"]) />
>
> It should work fine under CF8/9 because query columns are arrays. What
> is your CF
version?
I am using CF9 but I don't understand what you are telling me to do. :)
> Leigh I tried your suggestion and it outputs the value of the column:
>
It should work fine under CF8/9 because query columns are arrays. What is your
CF version?
~|
Order the Adobe Coldfusion Anthology now!
http://www.am
> Add a new column to the QoQ?
Since you cannot use "First Name" in a QoQ, you create a new column with a
valid name. Then use the new column name in your QoQ.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.a
>> What i want to do is this:
>
>AFAIK, you cannot. Check the previous responses. I posted an alternative.
>
>
>-Leig
Leigh I tried your suggestion and it outputs the value of the column:
Here is what I need to do.
The date column in not displaying properly in my file so I need to format
>> What i want to do is this:
>
>AFAIK, you cannot. Check the previous responses. I posted an alternative.
>
>
>-Leig
Leigh, I am sorry I did not understand what you meant:
Add a new column to the QoQ?
~|
Order the Adob
>in SQL you would use square brackets
>e.g.
>select [first name]
>
>does this not work in QofQ ?
>
>if not, then remember a query is just a struct of associative arrays,
>so you can simply reference the columns as struct keys
>
>e.g.
>myquery["first name"][row]
>
>where row is the row number
>
>or
>in SQL you would use square brackets
>e.g.
>select [first name]
>
>does this not work in QofQ ?
>
>if not, then remember a query is just a struct of associative arrays,
>so you can simply reference the columns as struct keys
>
>e.g.
>myquery["first name"][row]
>
>where row is the row number
>
>or
> What i want to do is this:
AFAIK, you cannot. Check the previous responses. I posted an alternative.
-Leig
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=ho
in SQL you would use square brackets
e.g.
select [first name]
does this not work in QofQ ?
if not, then remember a query is just a struct of associative arrays,
so you can simply reference the columns as struct keys
e.g.
myquery["first name"][row]
where row is the row number
or it may be the
>In your original query give the column an alias like
>
>SELECT [First Name] AS FirstName ...
>
>then in your QoQ use the alias (FirstName) to refer to the column.
>
>Azadi
>
>
>>
The original is a stored proc. It retrieves the column names as two words
because those are the column names used to
Modifying the sql to use an alias is preferable. But if that is not possible,
you could create a copy with a valid name. Then use that column name instead.
-Leig
~|
Order the Adobe Coldfusion Anthology now!
http://www.
Sorry, disregard my answer, it has been answered already and my solution
is incorrect
On 11/6/2011 12:41 PM, Rex wrote:
> I posted an answer to this in CF-Newbie, sorry for the cross-post.
>
> In the QoQ, wrap the column name in single-quotes. Only tried in
> CF9+MSSQL, but it works:
>
>
>
I posted an answer to this in CF-Newbie, sorry for the cross-post.
In the QoQ, wrap the column name in single-quotes. Only tried in
CF9+MSSQL, but it works:
SELECT 'this is data in the column' AS [COLUMN WITH SPACES IN THE NAME]
SELECT 'COLUMN WITH SPACES IN THE NAME' AS COLUMNNA
gt; Google says:
> http://www.dreamincode.net/forums/topic/156610-query-of-queries-column-names-with-spaces/
>
> On 11/5/11 10:41 PM, Torrent Girl wrote:
> >> queryName["Column Name"][rowNumber]
> >>
> >> On 11/5/11 9:38 PM, Torrent Girl wrote:
> >
M, Torrent Girl wrote:
>>> Hi All
>>>
>>> How do you output columns from a query that have been formatted as 2
>> words i.e. First Name?
>>> The query is returned by a stored proc that can
> queryName["Column Name"][rowNumber]
>
> On 11/5/11 9:38 PM, Torrent Girl wrote:
> > Hi All
> >
> > How do you output columns from a query that have been formatted as 2
> words i.e. First Name?
> >
> > The query is returned by a stored pro
> queryName["Column Name"][rowNumber]
>
> On 11/5/11 9:38 PM, Torrent Girl wrote:
> > Hi All
> >
> > How do you output columns from a query that have been formatted as 2
> words i.e. First Name?
> >
> > The query is returned by a stored
queryName["Column Name"][rowNumber]
On 11/5/11 9:38 PM, Torrent Girl wrote:
> Hi All
>
> How do you output columns from a query that have been formatted as 2 words
> i.e. First Name?
>
> The query is returned by a stor
Hi All
How do you output columns from a query that have been formatted as 2 words i.e.
First Name?
The query is returned by a stored proc that can't be edited.
~|
Order the Adobe Coldfusion Anthology now!
20 matches
Mail list logo