to reference column names that have
spaces in them when doing a QoQ !
Anyone know how to reference column names with spaces in a QoQ?
I've tried:
SELECT * FROM thetable ORDER BY 'my column'
SELECT * FROM thetable ORDER BY my column
SELECT * FROM thetable ORDER BY [my column]
SELECT
Give it an alias in your original query that doesnt have spaces.
cfquery datasource=...
Select my column as mycolumn
-Original Message-
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 11:15 AM
To: CF-Talk
Subject: QoQ Trouble for Column Names with Spaces
can't seem to reference column names that have spaces in
them when doing a QoQ !
Anyone know how to reference column names with spaces in a QoQ?
I've tried:
SELECT * FROM thetable ORDER BY 'my column'
SELECT * FROM thetable ORDER BY my column
SELECT * FROM thetable ORDER BY [my column]
SELECT
SELECT * FROM thetable ORDER BY [my column]
Mike
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 1:01 PM
To: CF-Talk
Subject: RE: QoQ Trouble for Column Names with Spaces
Give it an alias in your original query that doesnt have spaces.
cfquery
column as mycolumn
-Original Message-
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 11:15 AM
To: CF-Talk
Subject: QoQ Trouble for Column Names with Spaces
Hi everyone --
I'm working for a client who has given me some Oracle stored procedures
which
To: CF-Talk
Subject: RE: QoQ Trouble for Column Names with Spaces
Give it an alias in your original query that doesn't have spaces.
cfquery datasource=...
Select my column as mycolumn
-Original Message-
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August
Baldwin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 3:11 PM
To: CF-Talk
Subject: Re: QoQ Trouble for Column Names with Spaces
I would love to do that, but the problem is I don't have an original query
-- I retrieving the results from a CFSTOREDPROC and not CFQUERY.
:-/
On 8/25/05
to order by. Not pretty - but I'd holler at the guy who wrote the
SP if I were you :)
-Mark
-Original Message-
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 3:11 PM
To: CF-Talk
Subject: Re: QoQ Trouble for Column Names with Spaces
I would love
I'm considering hollering about the spaces... (it's a new client --
treading carefully...)
I would think hollering about this issue would show that you know what
you're doing (unlike the wingnut that put a space in a column name) ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce
: Re: QoQ Trouble for Column Names with Spaces
I would love to do that, but the problem is I don't have an original query
-- I retrieving the results from a CFSTOREDPROC and not CFQUERY.
:-/
On 8/25/05, Ewok [EMAIL PROTECTED] wrote:
Give it an alias in your original query that doesn't have
How do you display a query column that has a space within its name?
I'm executing a MySQL SHOW CREATE statement, which returns a one row data set
with two columns named TABLE and CREATE TABLE, but I'll be hanged if I can
figure out how to get CF to reference the latter.
Thanks.
not sure you can? although, maybe its possible...in sql server i dont
think
you can, but maybe in mysql you can, good luck!!
tony
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 11:34 PM
To: CF-Talk
Subject: Column names with spaces
How do you
I know that in Access it's possible to create column names containing spaces,
so _somebody_ must have had to deal with this problem from within CF before.
- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:45 PM
Subject: RE
You can alias the table name in the select statement, or you might be able
to do:
queryName[CREATE TABLE][1]
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:34 PM
Subject: Column names with spaces
How do you display
Access the query using array notation as in:
QueryName[Column Name][RowNumber]
Jim Davis
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 11:34 PM
To: CF-Talk
Subject: Column names with spaces
How do you display a query column that has
PM
Subject: Re: Column names with spaces
You can alias the table name in the select statement, or you might be able
to do:
queryName[CREATE TABLE][1]
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:34 PM
Subject
16 matches
Mail list logo