I am try to run a query of queries to order a query I create on the fly. On DEV
I do not get an error. On PROD I am getting:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another
try to dump query docQry chk if it is returning any row.
On Wed, Sep 26, 2012 at 6:50 PM, Chad Baloga cbal...@gmail.com wrote:
I am try to run a query of queries to order a query I create on the fly.
On DEV I do not get an error. On PROD I am getting:
The system has attempted to use
Yes it is, I have been playing with it and dumping results to see what data may
be causing the error
try to dump query docQry chk if it is returning any row.
~|
Order the Adobe Coldfusion Anthology now!
in select statement try to select one column at a time to chk which
column's data is causing the error.
On Wed, Sep 26, 2012 at 7:12 PM, Chad Baloga cbal...@gmail.com wrote:
Yes it is, I have been playing with it and dumping results to see what
data may be causing the error
try to dump
I figured it out. The last column had some NULL values which I guess it didn't
like even though other columns have NULLs and it's fine (Sounds like a bug). I
defaulted the NULL ones to N/A so it works now. Also had to declare all my
columns as VARCHARs in my QueryNew set statement.
try to
I have the following query of queries query
SELECT code, title
FROM Nav
WHERE nav = 'Calendar'
AND order = ''
It has recently stopped returning results when upgrading to CF9. If I change
the where clause to the following it returns the record
WHERE nav = 'Calendar'
AND order IS NULL
Any
Any ideas why the original where clause stopped working? I thought CF
treated all NULL value fields in a record set as an empty string.
probably the CF9 code is more consistent with SQL.
Right, if a field is returned NULL in a query, CF treats it as an empty string,
but apparently, the NULL
Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com]
Sent: Tuesday, August 02, 2011 11:32 AM
To: cf-talk
Subject: Query of Queries Empty String Issue
I have the following query of queries query
SELECT code, title
FROM Nav
WHERE nav = 'Calendar'
AND order = ''
It has
I am using a cfloop condition approach to perform a standard branched tree
operation. I have four tables and my query is pretty straight forward. The
output is not working though. It is returning the correct amount of results and
is organizing them properly but the values displayed are
I am using a cfloop condition approach to perform a standard branched tree
operation. I have four tables and my query is pretty straight forward. The
output is not working though. It is returning the correct amount of results and
is organizing them properly but the values displayed are
use a cfoutput with group attribute instead?
cfoutput query=GetStates group=StateID
#GetStates.StateName# #GetStates.StateID# -
cfoutput group=RegionID
#GetStates.StateRegion# #GetStates.RegionID#BR /
cfoutput group=CountryID
cfoutput
A
either do a query of queries
on each iteration or I can turn the query into a structure and do a
structure lookup (structkeyexists, etc) on each iteration. I'm
assuming that the struct lookup will be faster/more efficient even
after having to turn the query into a structure.
Anyone have
On Tue, Jul 13, 2010 at 12:19 PM, Michael Dinowitz
mdino...@houseoffusion.com wrote:
I've got a loop which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database (outside the loop). I can either do a query of queries
...@gmail.com]
Sent: Wednesday, July 14, 2010 10:27 AM
To: cf-talk
Subject: Re: struct lookup vs. query of queries
On Tue, Jul 13, 2010 at 12:19 PM, Michael Dinowitz
mdino...@houseoffusion.com wrote:
I've got a loop which will need to look up a piece of data on each
iteration. The data
Subject: Re: struct lookup vs. query of queries
On Tue, Jul 13, 2010 at 12:19 PM, Michael Dinowitz
mdino...@houseoffusion.com wrote:
I've got a loop which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database
On Wed, Jul 14, 2010 at 10:54 AM, DURETTE, STEVEN J (ATTASIAIT)
sd1...@att.com wrote:
Correct me if I'm wrong (please) but isn't a query already a Struct of Arrays?
It is, but you can really only use that to select data based on a
column name and row number. Typically, if I were to convert a
I've got a loop which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database (outside the loop). I can either do a query of queries
on each iteration or I can turn the query into a structure and do a
structure lookup
at 12:19 PM, Michael Dinowitz
mdino...@houseoffusion.com wrote:
I've got a loop which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database (outside the loop). I can either do a query of queries
on each iteration or I can
which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database (outside the loop). I can either do a query of queries
on each iteration or I can turn the query into a structure and do a
structure lookup (structkeyexists, etc
...@houseoffusion.com wrote:
I've got a loop which will need to look up a piece of data on each
iteration. The data is standardized so there is really just one call
to the database (outside the loop). I can either do a query of queries
on each iteration or I can turn the query into a structure
HI All -
I have a query which returns the result set like below. The column names are
like 1990, 1991, 1992 and there are certain amount for each year
1990 1991 1992
1000 5000 6000
2000 2000 3000
I have a query of query which finds the sum of the amounts for year 1990, and I
use the query
Should be double quotes I think
Select SUM(1990)
Some DBs use brackets too I think
sum([1990])
Not sure how it would work undr the hood with query of query, can't you
pull this from the db directly?
On Wed, 2010-06-09 at 11:27 -0400, fun and learning wrote:
HI All -
I have a query which
SUM([1990])
Just use square brackets around column name.
On Wed, Jun 9, 2010 at 11:27 AM, fun and learning
funandlrnn...@gmail.comwrote:
HI All -
I have a query which returns the result set like below. The column names
are like 1990, 1991, 1992 and there are certain amount for each year
Your first issue is that that is not a good db practice naming columns as
numbers. If you put a prefix of y in front of the column name in your
table (or whatever you chose, i.e y1990, y1991, y1992) it wouldn't have this
issue, it would force your SQL to actual look for a table column rather
and learning
funandlrnn...@gmail.comwrote:
I get the following error when I use quotes
Query Of Queries syntax error.
Encountered SUM. Lexical error at line 0, column 0. Encountered: \ (34),
after :
and the following error when I use brackets
Query Of Queries syntax error.
Encountered SUM
earlier.
Jim Eisenhauer
On Wed, Jun 9, 2010 at 8:27 AM, fun and learning funandlrnn...@gmail.com
wrote:
I get the following error when I use quotes
Query Of Queries syntax error.
Encountered SUM. Lexical error at line 0, column 0. Encountered: \
(34), after :
and the following error
If you can't rename the columns as someone else suggested, you can
change your select to
select 1990 as y1990, 1991 as y1991, etc..
then in your query of querys you do
select sum(y1990) as sum1990
On Wed, Jun 9, 2010 at 8:27 AM, fun and learning
funandlrnn...@gmail.com wrote:
HI All -
I
Ah, right QoQ can be bitchy. Can't you alias the column names in the initial
query?
SELECT my1990 = [1990], my1991 = [1991]
or
SELECT [1990] as my1990 etc etc
That way can reference them without any issues.
P.S. 1990 and the like are absolutely horrible column names.
On Wed, Jun 9, 2010 at
I have a query which returns the result set like below. The column names are
like 1990, 1991, 1992 and there are certain amount
for each year
1990 1991 1992
1000 5000 6000
2000 2000 3000
This doesn't address your question directly, but again this is a very
poor database design. I
Hi all,
This is probably a stupid question, but my simple mind can't figure
it out. I'm trying to do the following:
1)Have a cfmodule that does a large query.
2)Have a series of cfmodules that do a query of query on the large query
3)Have a script that calls the cfmodules
But I can't
: cfmodule and query of queries
Hi all,
This is probably a stupid question, but my simple mind can't figure
it out. I'm trying to do the following:
1)Have a cfmodule that does a large query.
2)Have a series of cfmodules that do a query of query on the large query
3)Have a script that calls
You should really be doing this in a CFC. They're built for stuff like
this.
Thanks,
Eric Cobb
http://www.cfgears.com
ColdFusion - the most profitable dead language I've ever worked with.
Thane Sherrington wrote:
Hi all,
This is probably a stupid question, but my simple mind can't
But I can't figure out how to pass the query from one module to
another.
You can also set your query in the request scope, ie : request.MyQuery
The request scope is visible in any module and sub modules.
~|
Want to reach the
I'm stuck. Actually, I'm probably just being stupid.
I want to pass a query object into a CFC and then use query of queries to
manipulate that query object.
Here's the contents of my db.cfc file:
cfcomponent
cffunction name=getContacts returntype=query
cfquery name=getData datasource
and then use query of queries to
manipulate that query object.
Here's the contents of my db.cfc file:
cfcomponent
cffunction name=getContacts returntype=query
cfquery name=getData datasource=adventureworks
SELECT top 100 *
FROM person.contact
/cfquery
cfreturn getdata
/cffunction
pruckelsh...@gmail.com
wrote:
I'm stuck. Actually, I'm probably just being stupid.
I want to pass a query object into a CFC and then use query of queries to
manipulate that query object.
Here's the contents of my db.cfc file:
cfcomponent
cffunction name=getContacts returntype
I've never been able to use a multipart identifier for a table in
query of queries until we figured out that it does let you put
brackets in...
ie...
FROM [arguments.dataIn]
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com
(Admittedly this problem for us occurred when we used a defined LOCAL
scope inside the function... ie cfset var LOCAL = structNew() and
then cfquery name=LOCAL.qry datasource=whatever) and then in a
query of queries... we'd always get errors when trying to do select *
from LOCAL.qry
Rick
Is there a way to do SQL Updates and Deletes on record sets organized as Query
of Queries? It seems that only SELECT works. I'm using CF8.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
On Thu, Feb 26, 2009 at 5:56 AM, Ron Gruner webmas...@gruner.com wrote:
Is there a way to do SQL Updates and Deletes on record sets organized as
Query of Queries? It seems that only SELECT works. I'm using CF8.
A query of queries does not make a connection to the actual database
Thanks Matt. Is there some other way to build a small and temporary database
that resides in RAM and can be manipulated with all, or most, SQL functions? I
suppose Structures is the best approach but they're new for me.
~|
On Thu, Feb 26, 2009 at 6:35 AM, Ron Gruner webmas...@gruner.com wrote:
Thanks Matt. Is there some other way to build a small and temporary database
that resides in RAM and can be manipulated with all, or most, SQL functions?
I suppose Structures is the best approach but they're new for
There's no obvious way to delete a QofQ row. Am I missing something? Thanks
again.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
...@gruner.com]
Sent: Thursday, February 26, 2009 8:23 AM
To: cf-talk
Subject: Re: Query of Queries Functions
There's no obvious way to delete a QofQ row. Am I missing something?
Thanks again.
~|
Adobe® ColdFusion® 8 software 8
Cool. The help is really appreciated. What a great resource.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Hi,
I was just wondering what the reason is behind the error I get when I use dot
notation with QoQ in the where clause.
This will throw an error:
cfquery name=myQry dbtype=query
select *
from a.qry
where a.qry.fkPOCId = 1
/cfquery
This won't:
cfset goodQry = a.qry /
cfquery name=myQry
: Justin T [mailto:jus...@treherconsulting.com]
Sent: 23 January 2009 17:43
To: cf-talk
Subject: Tiered Dot Notation in where clause query of Queries (QoQ)
Hi,
I was just wondering what the reason is behind the error I get when I
use dot notation with QoQ in the where clause.
This will throw
Thanks for the replies Carl and Brad.
Turns out you're both on the right track. The query is the same as it loops
over various databases and appends the results using the QofQ. There is no
chance of the records being the same since they are in different databases and
one of the columns is
Here's the beginning of the error message for a query of queries:
Message [empty string]
StackTrace java.lang.ClassCastException at
coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at
coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156
Brent Shaub wrote:
Here's the beginning of the error message for a query of queries:
Message [empty string]
StackTrace java.lang.ClassCastException at
coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at
coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156
with querynew() are you specifying data
types?
~Brad
- Original Message -
From: Carl Von Stetten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, September 17, 2008 4:30 PM
Subject: Re: Empty error message in a query of queries
Brent,
Without seeing the two queries
I have a runtime query of a query error as below.
java.lang.String cannot be cast to java.util.Date
But the output format is correct and is in date. This application was developed
in coldfusion 6.1 and sqlserver2000. But now we get this error when it was
migrated to coldfusion 8 and sql server
i had a similar problem and turned out to be that one of the values in the
order by clause was empty - cf seems to mistake it for a empty string and
therefore was producing the same error you are experiencing... check all values
in the problem column to ensure there are no empty values
i also
I'm trying to use functions in a QoQ to parse out some text. I have a
directory that has folders of images in it. What I want is a simple QoQ that
will extract the directory and filename from a CFDIRECTORY tag into another
query. My plan is to put this resulting query into the application
I know qofq doesn't do substring. I don't think it does any string
manipulation like replace. You will probably need to loop over the
query and do it manually or do it in the database.
Original Message
Subject: Query of Queries
From: Craigsell [EMAIL PROTECTED]
Date: Tue
Dang. I was trying to keep this in a query datatype so I could use it in
subsequent QoQ. I wanted to get rid of the names I don't need to reduce
memory usage -- I have a lot of image names to store!
~|
Adobe® ColdFusion® 8
Subject: Re: Query of Queries
From: Craigsell [EMAIL PROTECTED]
Date: Tue, September 02, 2008 12:24 pm
To: CF-Talk cf-talk@houseoffusion.com
Dang. I was trying to keep this in a query datatype so I could use it
in
subsequent QoQ. I wanted to get rid of the names I don't need to reduce
memory
Thanks! I just realised that I could do that. Now I have to figure out
whether it is a good idea to store 6 rows in an application scope query.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
How about something like this:
cfquery name=qryGetOtherProperties datasource=#appDSN#
SELECT f.AssetID, f.name, i.text, i.amount
FROM FixedAssets f
INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID
WHERE f.JobID = #qryGetInvoice.JobID#
AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE
How about something like this:
cfquery name=qryGetOtherProperties datasource=#appDSN#
SELECT f.AssetID, f.name, i.text, i.amount
FROM FixedAssets f
INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID
WHERE f.JobID = #qryGetInvoice.JobID#
AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE
If a qry a couple of tables:
!---get Job Property details ---
CFQUERY Name=qryGetJobProperties datasource=#appDSN#
SELECT AssetID, Name
FROM FixedAssets
WHERE FixedAssets.JobID=#qryGetInvoice.JobID#
/CFQUERY
cfset PropertyFieldID = ValueList(qryGetJobProperties.AssetID)
!---get invoice Property
:[EMAIL PROTECTED]
Sent: Saturday, August 23, 2008 3:47 PM
To: CF-Talk
Subject: query of queries or something else
If a qry a couple of tables:
!---get Job Property details ---
CFQUERY Name=qryGetJobProperties datasource=#appDSN#
SELECT AssetID, Name
FROM FixedAssets
WHERE FixedAssets.JobID
of Queries
Today our development server got hung up. We had to restart coldfusion and
after the restart all queries using query of queries stopped working. The
error message says (string out of index 7). Our development server is a
linux box with cf 6 installed. If any one has come across
Acctuly none of the tables have changed at all. Also every query that was using
query of queries stoped working. Below is the error.
java.sql.SQLException: String index out of range: 17
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73
#
cfdump var=#qTestQOQ#
Just trying to narrow down the issue.
Sincerely,
Dave Phillips
-Original Message-
From: heath stein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 8:27 AM
To: CF-Talk
Subject: Re: Query of Queries
Acctuly none of the tables have changed at all. Also every
Thanks Dave,
I actually did this out side of the current app, on a new table and got the
same error.
Heath Stein
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
help!
Sincerely,
Dave Phillips
-Original Message-
From: heath stein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 8:55 AM
To: CF-Talk
Subject: Re: Query of Queries
Thanks Dave,
I actually did this out side of the current app, on a new table and got the
same error.
Heath
good thing it's the development server :)
what if you just try:
cfquery type=query
select 1 as id
/cfquery
no datasources involved.
cfset qfoo=querynew(id)
cfset res=queryaddrow(qfoo,1)
cfset res=querysetcell(qfoo,id,1)
no sql involved.
Thanks Dave,
I am afraid your right we might have to do a re-install.
Thanks Heath
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Query of Queries working again
I did one more restart before I was going to do a re-install and Query of
Queries magically started working again. Jrun must have not been starting a
process or something.
Heath
~|
Adobe
cross fingers and start preparing reinstall plan heh
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
I am afraid your right we might have to do a re-install.
If restarting CF fails, and BEFORE reinstalling CF, one could try to
restart the server.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send
, 2008 9:21 AM
Subject: Re: Query of Queries
Query of Queries working again
I did one more restart before I was going to do a re-install and Query of
Queries magically started working again. Jrun must have not been starting
a process or something.
Heath
Today our development server got hung up. We had to restart coldfusion and
after the restart all queries using query of queries stopped working. The error
message says (string out of index 7). Our development server is a linux box
with cf 6 installed. If any one has come across this issue
thats ok mike, very clever idea about the temp table as well
thanks again!
Sorry, I thought you said if, not how.
As another person suggested, you could use nested loops. Or, you could
insert into a temp SQL table and run the outer join.
m!ke
Yes we are aware that they are not supported and
hi,
does anyone know how i can achieve a left join in a query of queries
thanks
richard
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk
Outer joins are not supported in QoQ.
You will have to come up with a workaround. Search this list for some
suggestions.
m!ke
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 12:02 PM
To: CF-Talk
Subject: left join on query of queries
hi
a left join in a query of queries
thanks
richard
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http
Outer joins are not supported in QoQ.
You will have to come up with a workaround. Search this list for some
suggestions.
m!ke
hi,
does anyone know how i can achieve a left join in a query of queries
thanks
richard
http://www.google.com/search?hl=enq=left+join+on+query+of+queriesbtnG=
Google+Search
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 12:14 PM
To: CF-Talk
Subject: Re: left join on query of queries
Yes we are aware that they are not supported
Subject: Re: left join on query of queries
Yes we are aware that they are not supported and we are looking for a
workaround. does anyone have any suggestions?
thansk
Outer joins are not supported in QoQ.
You will have to come up with a workaround. Search this list for some
suggestions.
m!ke
table and run the outer join.
m!ke
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 12:14 PM
To: CF-Talk
Subject: Re: left join on query of queries
Yes we are aware that they are not supported and we are looking for a
workaround. does
hi guys,
can anyone see anything wrong with the following query format...
cfquery dbtype=query
SELECT *
FROM qGetAllProducts
WHERE (
(product_title LIKE '%table%')
OR (product_description LIKE '%table%')
OR (cat_title LIKE '%table%')
OR (artist_fname LIKE '%table%')
OR (artist_lname LIKE
Does the product have a product_title of 'Table' or 'table'?
I haven't checked in a while, but it might be case-sensitive.
::-Original Message-
::From: Mike Little [mailto:[EMAIL PROTECTED]
::Sent: Sunday, April 06, 2008 12:23 AM
::To: CF-Talk
::Subject: using LIKE in query of queries
: using LIKE in query of queries
::
::hi guys,
::
::can anyone see anything wrong with the following query format...
::
::cfquery dbtype=query
::SELECT *
::FROM qGetAllProducts
::WHERE (
::(product_title LIKE '%table%')
::OR (product_description LIKE '%table%')
::OR (cat_title LIKE '%table
Try the lower() function - that might work in the QoQ.
On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote:
hey william, you are right. it does appear to be case sensitive. darn.
Does the product have a product_title of 'Table' or 'table'?
I haven't checked in a while,
thanks james and william, got it sorted.
Try the lower() function - that might work in the QoQ.
On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote:
hey william, you are right. it does appear to be case sensitive. darn.
Does the product have a product_title of 'Table' or
I should think so; problems occur with QoQ when it can't figure out the type
of data in a column accurately. With the cfdirectory result query, there
will be no problems correctly identifying the 'name' column as a string
type.
Dominic
On 27/03/2008, Jim McAtee [EMAIL PROTECTED] wrote:
I have
I have a directory containing dated log files that I need to parse. These
have filenames like:
reMMDD.log
So I do a cfdirectory to pull a list of files:
cfdirectory
action=list
directory=#mylogdir#
filter=re.log
name=dir
But I want exclude today's log from being
Do you have an example of QoQ that is hanging?
CF might have to convert a lot of data for you implicitly.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
eventually, but occasionally the server
completetly hangs.
What is interesting is that 90% of the time, the thread dump shows that
the line it is hanging on is running a query of queries. These do not
have cflocks around them. Does anyone have any clues as to why it is so
often query of queries that seem
All,
Please forgive me if you get this twice, as it did not appear to post
the first time.
I am having an issue with cold fusion query of queries when upgrading to
MX7. Previously, when doing a SUM(querycol) in a query of queries when
all the values of the column were null, the sum would
am having an issue with cold fusion query of queries when upgrading to
MX7. Previously, when doing a SUM(querycol) in a query of queries when
all the values of the column were null, the sum would return a 0. In
MX7, it is returning a blank string, causing all calculations to error
out.
Can
-Original Message-
From: Flesher, Rob [USA] [mailto:[EMAIL PROTECTED]
Sent: Friday, December 28, 2007 12:29 PM
To: CF-Talk
Subject: Query of Queries Issue
All,
Please forgive me if you get this twice, as it did not appear to post
the first time.
I am having an issue
is interesting, is that when these line numbers are followed, they are
always pointing to **Query of Queries**. Has anyone come across this kind of
thing before, my searches on these and other forums reveal nothing.
Many Thanks
Graham,
I haven't seen this exact error before, but do you perchance have a
cflock around the QoQ code?
Query of queries are very expensive on the server and grow more so as
the record set being manipulated increases. Many times, the same
functions performed in QoQ can be performed
So, it looks like column aliasing isn't valid in query of queries.
For example, the following works:
select foo + ' - ' + foo2 from qry
But this does not:
select foo + ' - ' + foo2 as newfoo from qry
Coldfusion seems to automatically alias the dynamic columns .. as
Column_1 in the case above
Try col_alias = expression
Mark
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 6:17 PM
To: CF-Talk
Subject: query of queries and column aliasing
So, it looks like column aliasing isn't valid in query of queries.
For example
Idiot alert, idiot alert!
My alias name was DESC... short for description
Also a reserved word =)
Funny how things work fine when you don't use reserved words.
Rick
~|
ColdFusion is delivering applications solutions at at top
I think he is working with dates
You're right, I didn't notice the CFMX form of the function.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
1 - 100 of 296 matches
Mail list logo
