>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 lo
>>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
http://ad.doubleclick.net/clk;20374891
t, you 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 notice
es though. 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> > Ac
08 1:37 PM
To: CF-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.
e, Jr.
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),&quo
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 s
7 matches
Mail list logo