Re: Query Too Complex for Access?

2008-08-22 Thread David Moore
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

Query Too Complex for Access?

2008-08-20 Thread David Moore
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

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
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

RE: Query Too Complex for Access?

2008-08-20 Thread David Moore, 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),')#) ?? Dave -Original Message- From

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
-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

RE: Query Too Complex for Access?

2008-08-20 Thread David Moore, Jr.
. 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

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
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

Re: Query Too Complex for Access?

2008-08-20 Thread Claude Schneegans
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