QofQ doesn't support subqueries.
cheers,
barneyb
On 11/9/05, Lee [EMAIL PROTECTED] wrote:
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.
cfquery name=OOrder datasource=database
You can't do sub queries in Q of Q.
Ade
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
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
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:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 5:23 PM
To: CF-Talk
Subject: RE: Query of Queries
to allow for no records though.
Ade
-Original Message-
From: Bobby Hartsfield [mailto:[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
Is cstSpecialZip another query record set? How about...
cfquery name=Minneapolis dbtype=Query
SELECT*
FROM OOrder
Where zip IN (cfqueryparam
value=0#valueList(cstSpecialZip.zip)# cfsqltype=CF_SQL_INTEGER
list=Yes)
/cfquery
In case you're wondering, the 0 will catch empty
5 matches
Mail list logo
