That's why they're cancelling each other out. I need to a) restructure the query in some fashion to allow the check properly, or b) trim the "FieldValue" checks out, and do some post-query-processing to determine if the record from TableA really *does* qualify based on the criteria I'm checking on. I'd much prefer a) but it's not looking good.
At 08:34 PM 1/27/2003 +0100, you wrote: >Scott Weikert wrote: > > ( > > ( B.CustomFieldID = 23 AND B.FieldValue = 'something' ) > > And > > ( B.CustomFieldID = 24 AND B.FieldValue = 'something else' ) > > ) > >B.CustomFieldID can not be 23 and 24 at the same time. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
