om: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 10:48 AM
To: CF-Talk
Subject: Re: Query of Queries date comparison
. and yes, since you are actually working with strings, not dates,
you do need quotes in WHERE date > '#DateFormat
and yes, since you are actually working with strings, not dates, you
do need quotes in
WHERE date > '#DateFormat(Now(),"/mm/dd")#'
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam t
>>I would like to run a query on this query where it finds only the
records where the date is greater than today.
You cannot compare dates if they are stored in American format.
Use QuerySetCell(event, "date", 2007/07/28, 1) Instead: always with mask
"/mm/dd"
Then
WHERE date > #DateFormat(
event
>WHERE date > #DateFormat(Now(),"mm/dd/")#
>
>
> However I get an error returned
>
> "Query Of Queries syntax error.
> Encountered "date. Incorrect conditional expression, Expected one of
> [like|null|between|in|comparison] condition,
Oh sorry, I only just got everyone else's responses through, thank you to
you guys for your time too.
Much appreciated,
Mark
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
h
Gualtiero and Dave thanks for your help I have resolved the issue with both
your tips.
Thank you for your time again
Mark
> "Date" is possibly(probably) a reserved word? Even if it isn't, your test
> will fail when the year rolls over - you should test /mm/dd. And I
> think you might nee
fied Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Mark Lewis [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 7:43 AM
To: CF-Talk
Subject: Query of Queries date comparison
Hi,
Wondered if someone could advise on
following...
>
>
>SELECT *
>FROM event
> WHERE date > #DateFormat(Now(),"mm/dd/")#
>
>
> However I get an error returned
>
> "Query Of Queries syntax error.
> Encountered "date. Incorrect conditional expression, Expected
Original Message-
From: Mark Lewis [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 7:43 AM
To: CF-Talk
Subject: Query of Queries date comparison
Hi,
Wondered if someone could advise on this problem I am having.
I have created a query as shown below...
I would like to run a
You can try using data object instead of a string formatted as a date. I
think the column in your query is of type string.
Bye
Gualtiero
- Original Message -
From: "Mark Lewis" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, July 30, 2007 1:43 PM
Subj
event
WHERE date > #DateFormat(Now(),"mm/dd/")#
However I get an error returned
"Query Of Queries syntax error.
Encountered "date. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition, "
Does this mean I cannot use this
I would cache your initial result, and build a set of filters that are
applied to it each time the user updates their filter. So, you would
have cachedQuery as your initial base search, then filteredQuery that
you would not cache but would always be the result of a QoQ of your
cached query with up
I've not really needed to use a query of queries before, so here's a
stupid question to be sure it's what I need
The first set of query results comes from a search form.
After the results are returned and displayed, I need to be able to
refine that search based on a sp
Hi everyone, I really need some help with the following problem:
We are upgrading our system from CF 5 to MX 7, and i have a query of queries
problem. My attached code is giving me this error:
The following information is meant for the website developer for debugging
purposes.
Error
Arg. Thanks Jochem. That did it.
> If you want to combine queries you need UNION, not a JOIN.
>
Jochem
~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/prod
do so in a QofQ manner.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 10:14 AM
To: CF-Talk
Subject: RE: INNER/LEFT Joins in query of queries?
> And one just uses the JOIN keyword, don't use 'INNER'
Sorry? What d
> And one just uses the JOIN keyword, don't use 'INNER'
Sorry? What do you mean by this?
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 12:11 PM
To: CF-Talk
Subject: RE: INNER/LEFT Joins in query of queries?
My first ques
update for those of you who care.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 12:03 PM
To: CF-Talk
Subject: INNER/LEFT Joins in query of queries?
I'm continuing work on my Basecamp API integration and have a question.
Basecamp returns
My first question is can anyone confirm if QoQ allows joining? My second
question is what's the syntax? Here's my SQL (pretty vanilla):
Yes, but IIRC only inner joins, no left or right joins. And one just
uses the JOIN keyword, don't use 'INNER'
Confidentiality Notice: This message including an
I'm continuing work on my Basecamp API integration and have a question.
Basecamp returns XML, which I am converting into a query object in certain
cases. My goal is to convert the XML returned by several methods into a
query, which I can then join using query of queries. So I have two qu
Tim Claremont wrote:
>
> The following ain't working. I get a record count of 2 for the first query
> and 1 for the second query. The third query returns the two records from the
> first query, and leaves off the results from the second query.
>
> It never combines the results of the two querie
I am trying to run a query that combines the result of two other queries. The
two other queries come from two separate databases.
I thought I could use query of queries, as the name implies, but I must be
missing something.
Two tables. One contains internal appointments. One contains
B character and in my circumstance it works well
because I'm comparing URLs and they don't contain tab characters.
Hope this helps someone else who runs into the same thing!
Dave
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 10:36 A
ote.
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 11:32 AM
To: CF-Talk
Subject: Query of Queri
Hi,
Anyone know how to force a LIKE comparison in a QofQ query to look for
literals of the following special characters:
%
_
[
]
^
All of the above are characters used in a LIKE comparison, but my string has
several of them in it, so I need to 'escape' them somehow.
I'm on MX 6.1. Thanks!
Hello Jochem,
The error I am getting is that ColdFusion MX gets an error executing Query of
Queries.
Well, here's my testing code:
---
SELECT a.*
FROMstatscountries a
JOIN(
SELECT isocode
L 8.1 and connected CFMX using the
> recommended JDBC3 and JDBC2, each in alternate trials. Both trials
> issued a query of queries (QofQ) error, which I heard of is inherent
> in FC4. With that, I removed PostgreSQL 8.1 and downgraded to 7.4 and
> used the recommended JDBC for 7.4. It
Thanks, then. I guess I'd better stick to 7.4 and MX for the mean time.
>> 2. Has anyone encountered this? What did you do?
>
>I haven't encountered this. But there are a couple of things I would
>suggest.
>
>First, have you considered upgrading to CFMX 7.0.2?
>
>Second, have you considered upgrad
> 2. Has anyone encountered this? What did you do?
I haven't encountered this. But there are a couple of things I would
suggest.
First, have you considered upgrading to CFMX 7.0.2?
Second, have you considered upgrading the JVM? You should be able to upgrade
to a later 1.4.2 JVM.
> 3. How will y
installer. My OS is FC4, and I just can't do any
Query of Queries (which is a bad thing because the CFMX debugger uses it, and
some module of my webapp's, use it too). In short, in this setup Query of
Queries was impossible. I couldn't find anything helpful from Adobe or anywhere
from the
rote:
> Does anyone know if it's possible to extract a 'subset' of records in a query
> utilizing Query of Queries? Basically I want to do something like this:
>
>
> SELECT *
> FROM qSomeQuery
> WHERE currentRow >= 21 AND currentRow < 41
&
Or even easier, without the loop.
SELECT *
FROM qMyQuery
WHERE id IN (#list_id#)
--
Russ
-Original Message-
From: Terry Sta. Maria [mailto:[EMAIL PROTECTED]
Sent: 05 January 2007 20:52
To: CF-Talk
Subject: Re: Query of Queries question
You don't necessarily
You don't necessarily have to create a query from scratch. Instead, if there
is a column (with a simple datatype) that uniquely identifies each row, this
can be done with a list and a query of queries.
If qMyQuery.id is such a column, then you can get those all into a
The query is not coming from a DB. It is actually coming from a CFSEARCH tag,
so unfortunately, I can't use this method.
>not sure what DB you're using.. but with Oracle you can do this in a subquery
>select * from
>(
>select rownum as rn, n.*
>From navmenu n
>)
>where rn >= 5 and rn <= 7
>
>
>
x27;subset' of records in a query
> utilizing Query of Queries? Basically I want to do something like this:
>
>
> SELECT *
> FROM qSomeQuery
> WHERE currentRow >= 21 AND currentRow < 41
> ORDERY BY LastName
>
>
> Of course, this doesn'
Does the result /have/ to be a query? Could you make a structure
instead, using your cfoutput method? That should be pretty quick.
On 1/5/07, Dave Phillips <[EMAIL PROTECTED]> wrote:
> Does anyone know if it's possible to extract a 'subset' of records in a query
>
Does anyone know if it's possible to extract a 'subset' of records in a query
utilizing Query of Queries? Basically I want to do something like this:
SELECT *
FROM qSomeQuery
WHERE currentRow >= 21 AND currentRow < 41
ORDERY BY LastName
Of course, this
You're welcome...glad it helped
On 9/22/06, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote:
> >Selva are you manually creating the first query by using querynew() etc?
> >
> >there is something on this page that may or may not apply for you:
> >http://www.houseoffusion.com/groups/CF-Talk/thread.cfm
>Selva are you manually creating the first query by using querynew() etc?
>
>there is something on this page that may or may not apply for you:
>http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:17237
>
>
>On 9/22/06, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote:
>>
Hi RichL,
The li
IL
>from
>MailQuery
>
> But it gives an error:
>
> Unsupported Numeric type conversion in Query of Queries.
>
> Please help to solve this issue.
> Thanks in advance.
> Selva
>
>
error:
Unsupported Numeric type conversion in Query of Queries.
Please help to solve this issue.
Thanks in advance.
Selva
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion
Hey all, I was just working on some query of queries code that used a
manually value-modified query when I got this error:
Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you have
tried to use a foreign
At 09:29 AM 8/18/2006, Kevin Roche wrote:
>I think its just a matter of:
>
>1/ Do an Inner Join with QonQ
>
>2/ Do a QonQ query on the left hand table that creates an exact similar
>result set with null entries for any right table fields and omits any rows
>from the first query.
>
>3/ Do a QonQ wh
problems with this if the results of 1 are large and can't be
converted quickly into a list.
Kevin
-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED]
Sent: 18 August 2006 12:58
To: CF-Talk
Subject: RE: Query of Queries - showing all entries from DB1
At 07:30 AM 8/18
I was going to suggest a union, so that link you found is the way to go IMO.
On 8/18/06, Roberto Perez <[EMAIL PROTECTED]> wrote:
> I found a link to a "fake left outer join" script at
> http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of.html
>
> A left outer join sound
At 07:30 AM 8/18/2006, you wrote:
>I think with a query of queries, you can do a left outer join using "*="
>syntax:
>
>SELECT
> *
>FROM
> table1,
> table2
>WHERE
> table1.id *= table2.fkey
>
>I AM NOT SURE OF THIS. But
I think with a query of queries, you can do a left outer join using "*="
syntax:
SELECT
*
FROM
table1,
table2
WHERE
table1.id *= table2.fkey
I AM NOT SURE OF THIS. But I think I read it somewhere. The "*=" says select
all records from left. C
Hi all,
I have a query of queries that brings Region information from DB1,
and CityName and Customer information from DB2. The query looks like this:
SELECT
listRegions.regionID AS AregionID,listRegions.region AS Aregion,
listCities.regionID AS BregionID,listCities.cityName AS BcityName
Ah, hadn't considered that. Thanks.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 22, 2006 10:59 AM
To: CF-Talk
Subject: RE: Can't use dot-notation variables in Query of Queries?
I had the same problem. Local is a keyword in SQL...
is local inside your method?
On 22/06/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
> In my CFCs, I like to put
>
>
>
> at the top, and use "local" as if it were a private variable scope.
>
> I needed to do a query of query, and the query I wanted to use was in
> one of those "local"
ation variables in Query of Queries?
In my CFCs, I like to put
at the top, and use "local" as if it were a private variable scope.
I needed to do a query of query, and the query I wanted to use was in one of
those "local" variables. Inside a , I had:
SELECT
In my CFCs, I like to put
at the top, and use "local" as if it were a private variable scope.
I needed to do a query of query, and the query I wanted to use was in
one of those "local" variables. Inside a , I had:
SELECT
*
FROM
local.qAllAppls
WHERE
ML_RPT_HDR_ID=#ML_RPT_HDR_I
d the title of the thread to "SOLVED: Query of
Queries" and Michael's software picked it up as a new thread (pssst, hey
michael - consider taking "SOLVED: " into consideration)
Yeah, I tried that! =)
Rick
AIL PROTECTED]> wrote:
>
> Oops, I was thinking of when I use cf functions on the right side of a
> where clause. :\
>
> > -Original Message-
> > From: Rick Root [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 12, 2006 11:18 AM
> > To: CF-Talk
> &
Oops, I was thinking of when I use cf functions on the right side of a
where clause. :\
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 12, 2006 11:18 AM
> To: CF-Talk
> Subject: Re: Query of Queries
>
> Munson, Jacob wrote:
Munson, Jacob wrote:
> Try using the val() function.
val is a coldfusion function, not a SQL function. you can't use val()
anymore than you can use lcase() or chr() in a query of queries.
Rick
~|
Messa
SOLVED... I got it to give me a different error which led me to a
posting on ExpertsExchange which mentions that "cast" is actually a
valid function to use in query of queries.
http://livedocs.macromedia.com/coldfusion/7/htmldocs/1270.htm#1182700
this page describes the need to c
Why not CAST?
Select SUM(CAST(option_price AS DECIMAL) * QUANTITY) as merch_charge
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 11:53 AM
To: CF-Talk
Subject: Re: Query of Queries
I ran this query and got a different error:
select
boyfriends who have great skills."
- Napoleon Dynamite
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 12:48 PM
To: CF-Talk
Subject: Re: Query of Queries
Ben Nadel wrote:
> Do any parts of the query work? Meaning, If you run with just the
> f
Try using the val() function.
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 12, 2006 10:53 AM
>
> I ran this query and got a different error:
>
> select
> SUM((OPTION_PRICE+0)) AS MERCH_CHARGE
> FROM contents
>
> Cannot
Rick,
What happens when you just do "quantity + option_price"
-Mark
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 11:48 AM
To: CF-Talk
Subject: Re: Query of Queries
Ben Nadel wrote:
> Do any parts of the query work? Meaning, If
I ran this query and got a different error:
select
SUM((OPTION_PRICE+0)) AS MERCH_CHARGE
FROM contents
Cannot mix types "VARCHAR" and "BIGINT" in a "+" binary operation
so it looks like for some reason, coldfusion things "OPTION_PRICE" is a
varchar, even though t
Ben Nadel wrote:
> Do any parts of the query work? Meaning, If you run with just the first SUM
> directive does it work? Does it work if you do not do the "*" in the second
> SUM? Let's see if we can narrow it down to exactly what is breaking?
It is definately this one causing the problem:
select
"
Sent: Friday, May 12, 2006 8:47 AM
Subject: Re: Query of Queries
> Anyone else got any ideas on this? "contents" is a regular query result
> set, not anything made by QueryNew()... and the columns in question are
> both numeric columns (quantity is an integer and option
ts" is a regular
> query result
> set, not anything made by QueryNew()... and the columns in
> question are
> both numeric columns (quantity is an integer and option_price is a
> decimal(10,2)... mysql database)
>
> Rick
>
> Rick Root wrote:
> > I'm
Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 11:47 AM
To: CF-Talk
Subject: Re: Query of Queries
Anyone else got any ideas on this? "contents" is a regular query result
set, not anything made by QueryNew()... and the columns in question are both
numeric columns (quantity
#x27;m getting the following error:
>
> Query Of Queries runtime error. Cannot apply the binary numeric
> operator [*|/] on a non numeric type
>
> When running the following query of queries:
>
> select
> sum(QUANTITY) AS QUANTITY,
> SUM(QUANTI
ot;You know, like nunchuck skills, bowhunting skills, computer hacking
> skills... Girls only want boyfriends who have great skills."
> - Napoleon Dynamite
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 12, 2006 9:42 AM
>
th fields are numeric fields.
Rick
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 12, 2006 9:31 AM
> To: CF-Talk
> Subject: Query of Queries
>
> I'm getting the following error:
>
> Query Of Queries runtime error. C
only want boyfriends who have great skills."
- Napoleon Dynamite
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 9:42 AM
To: CF-Talk
Subject: Re: Query of Queries
When creating a query using QueryNew() you can add an optional second
attribut
gt; skills... Girls only want boyfriends who have great skills."
> - Napoleon Dynamite
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 12, 2006 9:31 AM
> To: CF-Talk
> Subject: Query of Queries
>
> I'm getting the following erro
PROTECTED]
Sent: Friday, May 12, 2006 9:31 AM
To: CF-Talk
Subject: Query of Queries
I'm getting the following error:
Query Of Queries runtime error. Cannot apply the binary numeric
operator [*|/] on a non numeric type
When running the following query of queries:
select
s
I'm getting the following error:
Query Of Queries runtime error. Cannot apply the binary numeric
operator [*|/] on a non numeric type
When running the following query of queries:
select
sum(QUANTITY) AS QUANTITY,
SUM(QUANTITY*OPTION_PRIC
, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 1:44 PM
To: CF-Talk
Subject: Query of Queri
By chance is one or more of the possible values of code a number?
Mike
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 12:44 PM
To: CF-Talk
Subject: Query of Queries
I don't use QofQ much and am having some troubles that maybe so
I don't use QofQ much and am having some troubles that maybe someone can help
with.
I am building a query called getShipping that populates code, description,
rate.
I am then running a query of queries checking on the selected rate.
SELECT code,description,rate
FROM getShi
Thanks, everyone. I just re-write the statement without the use of subquery.
The statement is actually a lot simpler than with the subquery.
(SELECT USERID, HOMEADDR AS ADDRESS FROM QURYUSERS WHERE NOT HOMEADDR IS NULL)
UNION
(SELECT USERID, BUSADDR AS ADDRESS FROM QURYUSERS WHERE HOMEADDR IS N
> against the database. If you read the notes on QofQ,
> you'll see that performance really lags on complex
> operations.
>> Does query of queries allow sub queries? I get this
>> error:
>>
>> Query Of Queries syntax error.
>> Encountered "USE
Subqueries are not supported in QoQ.
On 3/12/06, Robert Munn <[EMAIL PROTECTED]> wrote:
> I don't see anything about support for subqueries, I would be surprised if
> they were supported. Even if they were, I would seriously re-think using a
> QofQ instead of operating against the database. If y
operations.
> Does query of queries allow sub queries? I get this error:
>
> Query Of Queries syntax error.
> Encountered "USERID NOT IN ( SELECT. Incorrect conditional expression,
> Expected one of [like|null|between|in|comparison] condition,
>
> When I tried to run
Does query of queries allow sub queries? I get this error:
Query Of Queries syntax error.
Encountered "USERID NOT IN ( SELECT. Incorrect conditional expression, Expected
one of [like|null|between|in|comparison] condition,
When I tried to run this statement:
(SELECT USERID, HOMEADDR AS AD
>When you figure out the specs on the production server, be sure to post -
>because I've never had this problem and it this is a new issue with 7 (we're
>not there yet), we're going to be in for a world of hurt.
>
Turned out it was an issue with CF5. The server was a W2K server with IIS 5 and
C
Incidentally, you can use [] to escape reserved words in query of
queries. I've had to do that on a few occasions, and I made sure when
I implemented my locale-specific query sorting function that it
escaped the column names being passed in this way since I couldn't
know that it wouldn
I would bet that if you just
> aliased the region field and grouped by it, it would STILL work on
> both your dev box and the other. :0)
>
Mmm... no, I aliased and "unaliased" (if that word exists) one by one all the
columns in different combinations each time (in Group alone, in Group and
My guess is that "Region" is a reserved word *somewhere* between CF, the OS,
the web server...something. That's probably why aliasing the field names fixed
the problem. In fact, I would bet that if you just aliased the region field and
grouped by it, it would STILL work on both your dev box and
11:14 AM 3/4/2006, I myself wrote:
>
> >I tried an alias, but in the end, it would be the same thing (i.e.,
> >the alias would point back to the original master query) ...
>
>
> Ok, it is working now. The solution was:
>
> - use an alias for each column in the query o
At 11:14 AM 3/4/2006, I myself wrote:
>I tried an alias, but in the end, it would be the same thing (i.e.,
>the alias would point back to the original master query) ...
Ok, it is working now. The solution was:
- use an alias for each column in the query of queries
- do not use the alias
At 10:37 AM 3/4/2006, Jochem van Dieten wrote:
> >
> > Regarding the CFOUTPUT GROUP issue with query of queries, is it
> > feasible to convert the output below to cfloop's?
> >
>
>
>Something like:
>
>
>
>
Thanks, I was trying loops with th
At 08:45 PM 3/3/2006, I myself wrote:
>Does anyone know, off the top of their heads, if a GROUP command in
>the output of a query of queries has server-specific issues?
I did more digging and this is what I found: when I do a ColumnList
on my desktop, I get a list like this:
cityID,
Roberto Perez wrote:
>
> Regarding the CFOUTPUT GROUP issue with query of queries, is it
> feasible to convert the output below to cfloop's? What I have is:
>
> (cfouptut group=region)
>
> Region 1
> (cfoutput group=city)
> City1
>
Hi,
Regarding the CFOUTPUT GROUP issue with query of queries, is it
feasible to convert the output below to cfloop's? What I have is:
(cfouptut group=region)
Region 1
(cfoutput group=city)
City1
(cfoutput)
cl
Hi all,
Does anyone know, off the top of their heads, if a GROUP command in
the output of a query of queries has server-specific issues?
I'm displaying the results of a query of queries using GROUP in the
cfoutput tag:
It works fine on my desktop (developer server, MX6), but when I
u
It seems as if that's one area where they may be a benefit (try it and
see) - another may be if you had a large, complex query with many
joins that took a long time to execute - once that dataset is in
memory it may be quicker to extract smaller subsets via QoQ. Of course
it may not; if you use bin
So by that rational only unindexed and non-sequential columns, such as a text
field, is where QoQs would offer performance increases?
>I'm not too surprised in this case. The original query just pulls
>everything from the table. The QoQ has to go through that whole
>recordset and find the matchi
I'm not too surprised in this case. The original query just pulls
everything from the table. The QoQ has to go through that whole
recordset and find the matching record(s), with no index to follow as
would be the case if the DB were doing it.
On 11/25/05, Billy Jamme <[EMAIL PROTECTED]> wrote:
> S
ent: Friday, 25 November 2005 4:16 p.m.
>To: CF-Talk
>Subject: Query of Queries (QoQ) performance question
>
>Hi all,
>
>I'm wondering if someone can explain to me how to properly utilize Query
>of Queries (QoQ) to gain the maximum amount of performance.
>
>Here'
If your initial "Query" query was very complicated then using QoQ to
extract subsets would probably perform better.
-Original Message-
From: Billy Jamme [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 November 2005 4:16 p.m.
To: CF-Talk
Subject: Query of Queries (QoQ) performanc
Hi all,
I'm wondering if someone can explain to me how to properly utilize Query of
Queries (QoQ) to gain the maximum amount of performance.
Here's a code example..
Select ID, name
From TempTable
Select ID, Name
AIL PROTECTED]
Sent: Thursday, 10 November 2005 11:31 a.m.
To: CF-Talk
Subject: Query of Queries Subquery
I'm having trouble doing a subquery using a query of queries. Is this
even possible or am I doing something wrong. I have the simplified code
below. Thanks.
SELECTZip
FROM
:[EMAIL PROTECTED]
Sent: 09 November 2005 22:28
To: CF-Talk
Subject: RE: Query of Queries Subquery
Sad but true... You'll have to run a third QoQ to filter it.
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Adrian Lynch [mailto:[
101 - 200 of 291 matches
Mail list logo
