Have you tried:
AND Works.ThisInventory not in
(#listQualify(valueList(getActiveWorks.ThisReference),')#)
Dave
I went in and applied the solution to all my other queries where I was having a
problem and it works great. You were right. None better. Thanks!
Already I am learning a lot from
I know I am setting myself up for another Query too complex issue, so before
I start I thought I would ask for suggestions. I run into this when I have to
reference two different Access databases that are Client imposed (don't ask).
Basically, I have to use one for active data and one to show
Have you tried:
AND Works.ThisInventory not in
(#listQualify(valueList(getActiveWorks.ThisReference),')#)
??
Dave
-Original Message-
From: David Moore [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2008 1:18 PM
To: CF-Talk
Subject: Query Too Complex for Access?
I know I am
.
UpstateWeb. LLC Subject: RE: Query Too Complex for Access? From: [EMAIL
PROTECTED] To: cf-talk@houseoffusion.com Date: Wed, 20 Aug 2008 13:27:34
-0500 Have you tried: AND Works.ThisInventory not in
(#listQualify(valueList(getActiveWorks.ThisReference),')#) ?? Dave
-Original Message- From
-Talk
Subject: RE: Query Too Complex for Access?
No I haven't.
What you are saying is that I should use valueList to build a full list from
all values in the getActiveWorks query and then listQualify to see if any
variable matches.
Thanks David! I will give it a shot.
Does anyone else know
. This will
not have the same issue once their are like 100 records in the getActiveWorks
query. Right?
~David G. Moore, Jr. Subject: RE: Query Too Complex for Access? From: [EMAIL
PROTECTED] To: cf-talk@houseoffusion.com Date: Wed, 20 Aug 2008 15:18:11
-0500 Acutally, the first part is correct
may need to break your query
down somehow. Hopefuly that won't be an issue though.
Hope this helps!
Dave
-Original Message-
From: David Moore, Jr. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2008 3:48 PM
To: CF-Talk
Subject: RE: Query Too Complex for Access?
I noticed that after
Does anyone else know of any other ways?
Plenty of them, but no one is better ;-)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
8 matches
Mail list logo