If you query is highly dynamic, this way may not be best.  Let's say the
user can specify groups that are of type college, jewish, preschool,
catholic, and skinny.  Now, you have to join to the type table 5 times
and that ain't looking too good.

~Brad

-----Original Message-----
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 03, 2008 6:27 PM
To: CF-Talk
Subject: Re: Need query help

>No, that'll get one or the other - he wants ones that are both.
>
>Aliasing will work, something like this:

James, I think I got this to work. My first tests are good. I didn't
mention this is a highly dynamic query. I have quite a few other filters
in play, but your example would work nicely with it. 

Thanks much!

Will 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300416
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to