On 12/26/05, Ben Nadel <[EMAIL PROTECTED]> wrote: > Maybe I cannot quite imagine how your DB is designed... but I am not sure > how it is possible for all of those to return 6 if you AND'ing the TypeIDFK= > parts. I am assuming this is an integer field in the DB table - how can they > ever equal two different values?
He is after another field in the record. SELECT someKey FROM someTable WHERE bigComplexConditionInvolvingOtherKeys -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
