Change the and to or.
( ( B.CustomFieldID = 23 AND B.FieldValue = 'something' ) OR ( B.CustomFieldID = 24 AND B.FieldValue = 'something else' ) ) ----- Original Message ----- From: Scott Weikert <[EMAIL PROTECTED]> Date: Monday, January 27, 2003 12:46 pm Subject: Re: SQL: Odd Select Issue > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
